At SCP Health, what you do matters As part of the SCP Health team, you have an opportunity to make a difference. At our core, we work to bring hospitals and healers together in the pursuit of clinical effectiveness. With a portfolio of over 8 million patients, 7500 providers, 30 states, and 400 healthcare facilities, SCP Health is a leader in clinical practice management spanning the entire continuum of care, including emergency medicine, hospital medicine, wellness, telemedicine, intensive care, and ambulatory care.
Why you will love working here:
- Strong track record of providing excellent work/life balance.
- Comprehensive benefits package and competitive compensation.
- Commitment to fostering an inclusive culture of belonging and empowerment through our core values - collaboration, courage, agility, and respect.
Responsibilities:
- Platform architecture & technical direction: Define and evolve reference architectures and standards for ingestion, transformation, orchestration, and serving layers (Snowflake + dbt and adjacent tooling); lead design reviews and set guardrails that enable teams to deliver scalable, secure, observable, and maintainable solutions.
- Highest-impact data products (ownership & service levels): Own end-to-end delivery and operational excellence for the most critical datasets and pipelines that support revenue cycle, physician scheduling, billing, and performance monitoring; define SLAs/SLOs, error budgets (where applicable), and support models for sustained reliability.
- Complex integrations & facility onboarding at scale: Lead strategy and implementation for complex, multi-facility integrations (EHR extracts, HL7, FHIR, APIs, flat files), including backfills, reconciliation, and long-term maintainability; establish repeatable onboarding playbooks and reusable patterns adopted across teams.
- Medallion lifecycle standards & governance leadership: Own and enforce platform-wide conventions across Bronze/Silver/Gold layers (naming, modeling, testing, documentation, lineage, certification); drive alignment on canonical definitions and patterns to reduce ambiguity and rework across domains.
- Operational ownership & major-incident leadership: Serve as an escalation point for major incidents impacting critical pipelines or multiple domains; lead triage, coordinate cross-team resolution, run blameless post-incident reviews, and drive systemic fixes (alerting, runbooks, resilience patterns, and backlog priorities) to prevent recurrence.
- Performance, reliability & FinOps leadership: Lead Snowflake performance and cost optimization initiatives (warehouse/workload design, scheduling, resource monitors, query tuning); establish team practices and decision frameworks that balance reliability, latency, and consumption, and communicate tradeoffs and drivers to stakeholders.
- Governance, security & compliance architecture: Architect and implement HIPAA-aligned controls for PHI/PII (least-privilege RBAC, masking, row/column policies, auditing, secure sharing); partner with Security/Compliance on access patterns, periodic reviews, audits, and remediation for platform-level controls.
- Data quality strategy, testing & observability: Define and operationalize platform-level data quality strategy (tests, reconciliation, anomaly detection, freshness/completeness targets) and observability standards; ensure measurable coverage for critical pipelines and data products and guide teams toward consistent adoption.
- Cross-team technical leadership: Lead technical discovery with stakeholders; clarify ambiguous requirements; propose implementation options; and align on definitions, acceptance criteria, change impacts, and rollout plans across multiple teams and initiatives.
- Mentorship & technical bar-raising: Mentor Data Engineers I-III through coaching, pairing, and feedback; raise the engineering bar via code/design reviews, reusable libraries/macros, documentation standards, and pragmatic guidance on tradeoffs.
- Release engineering & SDLC improvements: Lead improvements to data CI/CD and release practices (testing gates, automated checks, environment promotion, release strategy, rollback planning) that reduce defects and improve delivery predictability across teams.
- Technical roadmap partnership: Partner with the Data Engineering Manager and stakeholders to shape the platform roadmap, identify systemic risks and dependencies, and propose investments that improve scalability, reliability, governance, and team velocity.
Knowledge, Skills, and Abilities:
- Expert SQL & data engineering craft: Expert-level ability to design, optimize, and troubleshoot complex SQL workloads; diagnose performance at the query and system level; and define scalable patterns for data access and transformation.
- Snowflake platform leadership: Deep expertise with Snowflake architecture and operations, including workload strategy, governance controls, performance tuning, cost optimization, and operational monitoring; ability to set standards and c