Cloud Data Engineer - Snowflake

Snowflake; Chicago (IL); Hybrid; USD 59,000 - 91,000; Full time

Benefits offered by this job

Incentive pay for select positions

Annual increases based on performance

Career Pathways to Promote Growth

Medical, Dental, Vision options

Tuition Reimbursement

Free Parking

Wellness Program

Savings Plan Health Savings Account

Retirement Options with Company Match

Paid Time Off and Holiday Pay

Community Involvement Opportunities

Job summary

Endeavor Health is seeking a Cloud Data Engineer to design and optimize scalable cloud data architectures using Snowflake and Azure. You will collaborate with data engineers, BI teams, and security to deliver robust ELT/ETL pipelines and secure data access.

The role requires 4+ years in data warehousing and cloud data engineering, with hands-on Snowflake experience, strong SQL, and knowledge of Azure services. Hybrid work and a competitive benefits package are offered.

Qualifications

• 4-year college degree in computer science/information systems preferred or equivalent experience.
• 4+ years of enterprise data warehouse experience and 2+ years in cloud data engineering.
• Experience with Snowflake data loading, SQL development, and warehouse management.
• Familiarity with Azure services and data integration tools is a plus.

Responsibilities

• Assist in designing and implementing scalable cloud data architectures using Snowflake and Azure.
• Support setup and configuration of Snowflake environments (warehouses, roles, resource monitors).
• Work with Azure services like ADF, Blob Storage, ADLS, Key Vault and AD to support ELT/ETL pipelines.
• Collaborate with data engineers to optimize ELT/ETL pipelines and performance.
• Document architecture designs, data flows, and security controls; monitor costs.

Skills

Analytical skills

Problem solving

Communication

SQL

Education

4-year college degree in computer science/information systems

Tools

Snowflake

Microsoft Azure

Azure Data Factory

Power BI

Job description

Hourly Pay Range: $42.47 - $65.83 - The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors.

Position Highlights:

Position: Cloud Data Engineer

Location: Skokie, IL / Arlington Heights, IL / Warrenville, IL (choice)

Full Time Hours: Monday-Friday, 8:00am - 4:30pm

Hybrid Position - primarily remote with bi-weekly onsite expectations

Job Summary:

The Cloud Data Engineer is considered a subject matter expert, involved with all phases of software development from design to implementation to post implementation problem solving. This position is easily able to code, tests, debugs and documents program applications specific to their team. May be required to develop application designs, devise or modify procedures to solve system software or user problems and prepare detailed specifications. This position may be required to mentor peers and provide educational/informational sessions to improve workflows, troubleshooting or system design pertaining to their team.

What you will do:

• Assist in designing and implementing scalable cloud data architectures using Snowflake and Azure.
• Support the setup and configuration of Snowflake environments (warehouses, roles, resource monitors, data sharing).
• Work with Azure services such as Azure Data Factory, Azure Blob Storage, Azure Data Lake Storage (ADLS), Azure Key Vault, and Azure Active Directory.
• Collaborate with data engineers to design and optimize ELT/ETL pipelines.
• Help optimize Snowflake performance (clustering, partitioning, query optimization, warehouse sizing).
• Assist in implementing role-based access control (RBAC) within Snowflake and Azure.
• Support data security strategies including encryption, masking, and row/column-level security.
• Monitor system performance and cost usage in Snowflake and Azure.
• Support cost optimization strategies and resource scaling.
• Troubleshoot data load and performance issues.
• Document architecture designs, data flows, and standards.
• Collaborate with enterprise architects, data engineers, BI teams, and security teams.
• Participate in design reviews and contribute to architecture best practices.

What you will need:

• Education: 4-year college degree in computer science/information systems preferred or equivalent experience.
• Experience: 4+ years of enterprise data warehouse industry experience 2+ years of experience in cloud data engineering or cloud platform support 4+ years of experience with data architecture and implementing data warehouse data marts

Unique or Preferred Skills:

• Understanding of cloud networking basics (VNet, private endpoints, firewall rules)
• Hands-on experience with: Snowflake (data loading, SQL development, warehouse management) Microsoft Azure (ADF, Blob Storage, IAM concepts) Familiarity with CI/CD pipelines and DevOps concepts Informatica Power Center/ Cloud Data Integration experience a plus 4+ years of experience in writing complex SQL
• Strong analytical, problem solving, negotiation, issue resolution and facilitation skills are required
• Excellent written and verbal communication and decision-making skills
• Experience and understanding of data sources including 3rd party RDBMS, SQL server and Oracle
• Experience in QA/QC testing a plus
• Project management skills a plus
• Experience working with Research data models like OMOP/CAPriCORN a plus
• Experience with Business Intelligence tool like Power BI a plus
• Familiarity with healthcare industry, healthcare information systems is a plus

Benefits (For full time or part time positions):

• Incentive pay for select positions
• Opportunity for annual increases based on performance
• Career Pathways to Promote Professional Growth and Development
• Various Medical, Dental, Pet and Vision options
• Tuition Reimbursement
• Free Parking
• Wellness Program
• Savings Plan Health Savings Account Options
• Retirement Options with Company Match
• Paid Time Off and Holiday Pay
• Community Involvement Opportunities

Endeavor Health is a fully integrated healthcare delivery system committed to providing access to quality, vibrant, community-connected care, serving an area of more than 4.2 million residents across six northeast Illinois counties. Our more than 25,000 team members and more than 6,000 physicians aim to deliver transformative patient experiences and expert care close to home across more than 300 ambulatory locations and eight acute care hospitals – Edward (Naperville), Elmhurst, Evanston, Glenbrook (Glenview), Highland Park, Northwest Community (Arlington Heights) Skokie and Swedish (Chicago) – all recognized as Magnet hospitals for nursing excellence.

For more information, visit www.endeavorhealth.org.

When you work for Endeavor Health, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential. Please explore our website (www.endeavorhealth.org) to better understand how Endeavor Health delivers on its mission to “help everyone in our communities be their best”. Endeavor Health is committed to working with and providing reasonable accommodation to individuals with disabilities. Please refer to the main career page for more information. At Endeavor Health, we are united by a shared commitment to working together to create a culture of connection and belonging—each of us bringing different skills and experiences as we deliver safe, seamless, and personal care. Every person, every time. We are committed to fostering an environment where all team members can be their best, learn, and pursue excellence together.

EOE:

Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor.

Welcome to Endeavor Health Careers At Endeavor Health, we believe every role plays an important part in advancing our mission to help everyone in our communities be their best. Whether you’re just beginning your career journey or are a seasoned professional, you’ll find opportunities here to learn, grow, and thrive. Your Career is our Endeavor.