You are applying for a position through Medix, a staffing agency. The actual posting represents a position at one of our clients.
Job Summary
Our client is seeking an experienced Lead SQL Developer with expertise in Health Catalyst / SQL EDW development. This role is crucial as our client undergoes an active Snowflake implementation, requiring dedicated engineering support to build and maintain Enterprise Data Warehouse (EDW) dashboards, integrate healthcare data (clinical, financial, operational), and enhance internal capacity.
Key Responsibilities
- Design, build, and optimize Enterprise Data Warehouse (EDW) dashboards and reporting structures.
- Integrate complex data streams across clinical, financial, and operational domains.
- Support data pipeline, data modeling, and ETL/ELT development during the client's transition/implementation into Snowflake.
- Collaborate with data architecture and business intelligence teams to ensure data integrity, performance, and proper SAM (Subject Matter Mart) creation.
Qualifications
- Strong hands-on experience with the Health Catalyst Data Operating System (DOS) platform, Health Catalyst SAMs (Subject Matter Marts), and Health Catalyst EDW architecture.
- In-depth understanding of healthcare domain knowledge, including clinical workflows, financial billing/claims data, or operational health system metrics.
- Advanced T-SQL / SQL development capabilities (stored procedures, views, complex joins, query optimization).
- Deep experience in a hospital/health system environment working on large-scale Enterprise Data Warehouses (EDW).
- Strong data modeling skills with clinical, financial, or operational data pipelines.
- Snowflake experience or familiarity with modern cloud data warehouse migrations is a strong plus.
Experience
- Demonstrated experience in designing, building, and optimizing Enterprise Data Warehouses (EDW).
- Proven track record of integrating complex data streams across clinical, financial, and operational domains within healthcare systems.
- Experience supporting data pipeline, data modeling, and ETL/ELT development during data warehouse transitions or implementations.
Skills
- Healthy Catalyst
- SQL
- EDW
- Developer
- Building Dashboards
Additional Requirements
- Start Date: ASAP
- Hours Per Week: 40
- Length of Assignment: 3-6 months (with possible extension)
- This is a 100% remote contract position.
Benefits
- Paid Sick Leave (Medix provides paid sick leave according to state and local sick leave ordinances).
- Health Benefits / Dental / Vision (Medix offers 6 different health plans: 3 Major Medical Plans, 2 Fixed Indemnity Plans (Standard and Preferred), and 1 Minimum Essential Coverage (MEC) Plan. Eligibility for health benefits is based on verifying that an average of 30 hours per week during the first 4 weeks of the work assignment has been met. If you meet eligibility requirements and take action to enroll, you will be covered no earlier than 60 days into your assignment, depending on plan selection(s)).
- 401k (Eligible on the first 401k open enrollment date following 6 consecutive months on assignment. 401k Open Enrollment dates are 1/1, 4/1, 7/1, and 10/1).
- Short Term Disability Insurance.
- Term Life Insurance Plan.
*We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state, and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance (FCIHO), Los Angeles Fair Chance Ordinance for Employers (ULAC), The San Francisco Fair Chance Ordinance (FCO), and the California Fair Chance Act (CFCA).
Medix Overview:
With over 20 years of experience connecting organizations with highly qualified professionals, Medix is a leading provider of workforce solutions for clients and candidates across the healthcare, scientific, technology, and government industries. Through our core purpose of positively impacting lives, we’re dedicated to creating opportunities for job seekers at some of the nation's top companies. As an award-winning career partner, Medix is committed to helping talent find fulfilling and meaningful work because our mission is to help you achieve yours.
*This position is subject to a background check based on its job duties, which may include patient care, working with vulnerable populations, access to financial and confidential information, driving, working with heavy machinery, or working in a warehouse or laboratory environment. Due to these job duties, this position has a significant impact on the business operations and reputation, as well as the safety and well-being of individuals who may be cared for as part of the job position or who may interact with staff or clients.
