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.