Snowflake Engineer

Blue Cross of Idaho; Carmel (IN); Hybrid; USD 96,183 - 144,275; Full time

Benefits offered by this job

Paid time off

401(k) matching

Health insurance

Job summary

Blue Cross of Idaho is seeking a Snowflake Engineer responsible for designing and optimizing scalable data solutions on the Snowflake platform. The ideal candidate will have 3-5 years of relevant experience and will work in a hybrid setting based in Carmel, Indiana.

The role involves developing data pipelines, ensuring data governance, and collaborating with various teams. Compensation includes a robust benefits package and an estimated pay range between $96,183 to $144,275, based on experience level.

Qualifications

• 3-5+ years in data engineering or data warehousing, preferably in healthcare.
• 2-3+ years of hands-on experience with Snowflake.
• Strong proficiency in Python for scripting and automation.

Responsibilities

• Design and build scalable, secure data solutions using Snowflake.
• Develop and optimize SQL and Python for ELT/ETL processes.
• Implement data pipelines with Snowflake features like Snowpipe and Streams.

Skills

SQL

Python

Data modeling techniques

Data pipeline orchestration tools

Performance tuning

Education

Bachelor’s degree in Computer Science, Engineering, or related field

Tools

Snowflake

AWS

Azure

GCP

Job description

Our Snowflake Engineer will be a leading technical expert responsible for designing, implementing, and optimizing scalable and high-performance data solutions on the Snowflake Data Cloud. This role requires deep, practical experience across all aspects of the Snowflake platform, including architecture, performance tuning, data modeling, and security. You will play a crucial role in building, maintaining, and automating enterprise-level data pipelines and warehouses to support our business intelligence and analytical needs.

Key Responsibilities

• Design and build scalable, secure, and cost‑effective data solutions using Snowflake architecture, including virtual warehouses, databases, and schemas.
• Develop and optimize complex SQL, Python, and other code for ELT/ETL processes to load, transform, and manage data within the Snowflake environment.
• Implement data pipelines using Snowflake features like Snowpipe, Streams, and Tasks, along with orchestration tools such as dbt or Airflow.
• Guide performance tuning, cost optimization, and workload management; monitor and fix query performance, analyze execution plans, and implement solutions to ensure efficient data processing.
• Implement robust data governance and security measures, such as RBAC, data masking, and encryption; ensure data solutions align with regulations and standards like HIPAA and GDPR.
• Automate essential data processes and deployment workflows using CI/CD pipelines, Git‑based version control, scripting languages, and IaC tools such as Terraform to manage Snowflake infrastructure.
• Collaborate with data engineers, architects, data scientists, and business partners to define requirements and deliver solutions that meet business needs; mentor other engineers and support collaboration within the team.
• Fully document all solution work, including designs, configurations, and data lineage.

Qualifications

• Location preference: hybrid work location (onsite at Meridian Idaho campus and WFH); opportunity for fully remote within a mutually acceptable location.
• Education: Bachelor’s degree in Computer Science, Engineering, or a related quantitative field; or equivalent practical experience (two years’ relevant work experience is equivalent to one-year college).
• Experience: 3‑5+ years in data engineering, data warehousing, or a similar role, preferably in healthcare.
• 2‑3+ years of hands‑on experience with Snowflake, including advanced features like Zero Copy Cloning and Time Travel.
• Deep expertise in SQL, data modeling techniques (dimensional modeling, data vault), and ELT concepts.
• Strong proficiency in Python for scripting and automation; experience with cloud platforms (AWS, Azure, or GCP).
• Demonstrable experience with data pipeline orchestration tools such as dbt, Airflow, or Fivetran.
• Experience with DevOps principles and CI/CD standard processes.
• Excellent analytical, problem‑solving, and communication skills; diligent approach.
• Have or willing to obtain SnowPro Core Certification.
• Preferred: Experience leveraging AI‑Driven Development (Snowflake Cortex AI, Cortex Code, Snowpark) and AI‑native tools (Cortex Search, Notebooks, Streamlit).
• Advanced Snowflake certifications (e.g., SnowPro Advanced Architect) are a plus.

Compensation & Benefits

Estimated pay range (2026): Engineer II $96,183 to $144,275; Engineer III $118,506 to $177,758. The position is eligible for an annual incentive bonus. We offer a robust benefits package including paid time off, paid holidays, community service and self‑care days, medical/dental/vision/pharmacy insurance, 401(k) matching and non‑contributory plan, life insurance, short and long term disability, education reimbursement, employee assistance plan (EAP), adoption assistance program, and paid family leave program.

Reasonable Accommodations

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Equal Opportunity Employer

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.