Data Engineer - Snowflake & Azure

Children's Hospital Association is hiring a Data Engineer to help build Snowflake and Azure data platforms that teams can trust for reporting, analytics, and operational decision-making. This hybrid role is based in Lenexa, KS, with a three days in-office, two days optional remote schedule. You will be supported with competitive pay, robust benefits, and opportunities to contribute to both new development and ongoing operational support.

What You’ll Do

As a Data Engineer, you will support the design, development, testing, and maintenance of Snowflake and Azure-based data platforms. The work includes data lakes, SQL databases, and data warehouse solutions. You will contribute to reliable, scalable, and high-performing data solutions, while also providing operational support for production data processes.

Responsibilities

• 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 to improve efficiency and data quality.
• Support Snowflake platform performance, security, governance, and operational initiatives.
• Prepare and validate data assets for reporting, analytics, and self-service data consumption.
• Participate in code reviews, testing, troubleshooting, and continuous improvement across data platforms.
• 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 accurate, reliable data.

What You’ll Bring

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or an equivalent combination of education and experience.
• 3+ years designing, developing, and supporting enterprise data platforms with strong focus on Snowflake.
• Experience building and maintaining data integration and ETL/ELT solutions using Snowflake and tools such as Azure Data Factory, DBT, SSIS, or similar technologies.
• Experience delivering cloud-based data solutions 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.

Technologies

Snowflake, Azure, SQL, data lakes, data warehouse solutions, ETL, ELT, Azure Data Factory, DBT, SSIS, Azure DevOps, Git, CI/CD, source control

Benefits

• Competitive total compensation package
• Medical, dental and vision insurance
• Retirement Savings program with generous company contribution
• Hybrid working model
• Health Savings Account with company contribution
• Wellness program
• Paid time off and personal days
• 9 paid holidays
• Paid Parental Leave
• And more!

Compensation: $82,000 - $166,000 per year. This pay range is a guideline and may vary based on qualifications, skill level, and competencies. Compensation is based on location and may change based on work location.

Equal Opportunity: Children’s Hospital Association is a Diversity, Equity and Inclusion focused employer and an Equal Opportunity Employer. Visa sponsorship is not available for this position. #LI-Hybrid