Data Engineer - Snowflake & Azure

Children's Hospital Association; Lenexa (KS); Hybrid; USD 82,000 - 166,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Retirement Savings program

Health Savings Account

Wellness program

Paid time off and personal days

9 paid holidays

Job summary

Children’s Hospital Association in Lenexa, KS is seeking a Data Engineer to design, develop, and maintain Snowflake and Azure‑based data platforms that support analytics, reporting, and data products. You’ll optimize data models, pipelines, and governance while enabling reliable self‑service insights.

The role requires 3+ years building enterprise data platforms with Snowflake, strong SQL, and experience with ETL/ELT tools.

Qualifications

• Bachelor's degree in CS/IS/Data Engineering or equivalent.
• 3+ years designing and supporting enterprise data platforms with a focus on Snowflake.
• Experience building ETL/ELT with Snowflake, Azure Data Factory, DBT, or SSIS.
• Experience delivering cloud-based data solutions in modern data warehousing environments.

Responsibilities

• Design, develop, test, and maintain Snowflake and Azure-based data platforms.
• Develop and support ETL/ELT processes.
• Build scalable data solutions for reporting and analytics.
• Automate data ingestion, validation, transformation, and monitoring.
• Support Snowflake platform performance, security, governance.
• Prepare data assets to support reporting and self-service data consumption.
• Participate in code reviews, testing, and troubleshooting.

Skills

SQL

Analytical skills

Communication

Collaboration

Education

Bachelor's degree in CS/IS/Data Engineering

Tools

Snowflake

Azure Data Factory

DBT

SSIS

Job description

Data Engineer – Snowflake & Azure
Hybrid in Lenexa, KS

Join us in shaping a healthier future for kids. At Children’s Hospital Association, we unite more than 200 member hospitals to put children first—advancing care, informing policy, and driving progress together.

Where You’ll Work

This position is based in our Lenexa, KS office. We leverage a hybrid working model working three days in the office, two days optional remote work.

What You’ll Do

The DataEngineerwill support the design, development, testing, and maintenance of Snowflake and Azure-based data platforms, including data lakes, SQL databases, and data warehouse solutions. This role contributes to new development initiatives and ongoing operational support while helping deliver reliable, scalable, and high-performing data solutions.

• Develop, optimize, and maintain Snowflake databases, data models, and cloud-based data pipelines.
• Design, develop, and support ETL/ELT processes using Snowflake and related data integration technologies.
• Build and maintain secure, reliable, and scalable data solutions that support reporting, analytics, and operational needs.
• Automate data ingestion, validation, transformation, and monitoring processes to improve efficiency and data quality.
• Support Snowflake platform performance, security, governance, and operational initiatives.
• Prepare and validate data assets to support reporting, analytics, and self-service data consumption.
• Participate in code reviews, testing, troubleshooting, and continuous improvement efforts across data platforms and solutions.
• Monitor production data processes, diagnose issues, and resolve failures, performance concerns, and data inconsistencies.
• Partner with business and technical stakeholders to support data quality initiatives and ensure reliable, accurate data.

What You’ll Bring to CHA

Any combination of education and experience providing the required skill and knowledge is qualifying.

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or an equivalent combination of education and experience.
• 3+ years of experience designing, developing, and supporting enterprise data platforms with a strong focus on Snowflake.
• Experience building and maintaining data integration and ETL/ELT solutions using Snowflake, Azure Data Factory, DBT, SSIS, or similar technologies.
• Experience delivering cloud-based data solutions and working within modern data warehousing or lakehouse environments.
• Strong SQL skills and experience with Snowflake data platform development and optimization.
• Experience with source control and CI/CD tools such as Azure DevOps or Git.
• Strong analytical, problem-solving, communication, and collaboration skills.

Our Perks and Benefits

• Medical, dental and vision insurance
• Retirement Savings program with generous company contribution
• Health Savings Account with company contribution
• Wellness program
• Paid time off and personal days
• 9 paid holidays
• And more!

More About CHA

This pay rangeshown isa guideline. Min:$82,000 – $166,000 Compensation is based on factors such as qualifications, skill level, and competencies; compensation is based on therole'slocation and is subject to change based on work location.

Diversity, Equity and Inclusion

CHA is committed to advancing diversity, equity and inclusion within our organization, our membership, the care delivery of children’s hospitals and their communities and through the federal policymaking environment. With children’s hospitals we strive to ensure organizational cultures where everyone feels valued and actively participates in the mission of our organizations. Racism stands firmly in the way of improving children’s health. We remain vigilant in our quest for a diverse and inclusive community and in standing against racism and discrimination wherever it exists.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, and protected veteran status, or disability status.

Visa sponsorship is not available for this position.
#LI-Hybrid