Data Engineer
Salma Health Inc.
Sacramento, United States of America
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Intermediate Compensation
$ 185KJob location
Sacramento, United States of America
Tech stack
Query Performance
API
Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Code Review
Continuous Integration
Software Debugging
Entity Framework
Identity and Access Management
Python
Standard Sql
EHR Systems
Google Drive
Delivery Pipeline
Amazon Web Services (AWS)
Cloudformation
Pytest
Git Flow
Infrastructure Automation Frameworks
Amazon Web Services (AWS)
GraphQL
Data Management
Terraform
Pagination
Data Pipelines
Job description
- Maintaining and improving the orchestration layer: Dagster assets, jobs, schedules, sensors, and the dependency graph that ties extraction loading transformation together.
- Adding new data sources to the pipeline; extracting from APIs (GraphQL, REST), Google Drive folders, and CSV/JSONL drops on S3, then landing them in our bronze schemas via Dagster assets.
- Building silver and gold dbt models that transform raw source data into our unified entity model following the medallion architecture.
- Extending our semantic layer so business metrics are available to downstream consumers (BI tool dashboards, AI agents, ad-hoc analysis) without re-deriving logic
- Operating the platform on AWS: ECS Fargate services, RDS, S3, Secrets Manager, CloudFormation templates, and the CodePipeline-based CI/CD that deploys our data platform. All of our data platforms are deployed with IaC tools.
- Writing tests (pytest for Python, dbt tests for models, data quality tests) and contributing to internal documentation as new patterns emerge.
Requirements
Do you have experience in Technical writing within technology?, * 4-7 years of professional experience building and operating data pipelines in production
- From conversation to shipped data product: you're comfortable owning a request end-to-end: scoping it with a non-technical stakeholder, writing requirements clear enough that you (and others) can build against them, implementing the models or metrics, and verifying with the stakeholder that what shipped solves their problem.
- Strong Python: comfortable writing modules, structuring code for reuse and testability, and debugging issues across an async or orchestrated pipeline.
- Solid SQL skills, including window functions, CTEs (including recursive ones), and the ability to reason about query performance.
- Hands-on experience with dbt: building models, writing tests, and understanding materializations.
- Working knowledge of an orchestration framework: (Dagster, Airflow, Prefect, or similar), including the mental model of assets/tasks, dependencies, and scheduling.
- Comfort with AWS fundamentals: S3, IAM, Secrets Manager, and either ECS or Lambda for compute.
- Git-based workflows: code review, and writing PRs that are reviewable., * Experience with Dagster specifically.
- Experience with semantic layer tools (Cube.js, dbt Semantic Layer/MetricFlow, LookML)
- Healthcare data experience (HIPAA, EHR systems, ICD-10/CPT codes)
- CloudFormation, Terraform, or another IaC tool
- Experience with GraphQL APIs as a consumer (pagination, introspection, dealing with rate limits and retries)
- Familiarity with identity resolution patterns or slowly-changing dimension modeling
Benefits & conditions
Pulled from the full job description
- Paid time off
- Vision insurance
- Dental insurance, * Small, focused team; your work ships and gets used quickly
- Pragmatic engineering: we favor readable code, clear naming conventions, and well-documented patterns over clever abstractions. Our internal "how to add X" guides are first-class artifacts.
- Tests on everything; CI runs dbt parse, dg check defs, and pytest on every PR., * Base: The base salary range for this role is $119,000-$185,000, depending on geographic location, experience, and qualifications. Salma Health uses a tiered compensation structure based on candidate location. Specific range details are available during the interview process.
- Incentives: Discretionary bonus based on company and individual performance
- Benefits: Medical, dental, vision, PTO, and additional benefits
About the company
Salma Health is reimagining brain healthcare. We bring together advanced diagnostics, evidence-based treatments and continuous support under one connected system-so every person can receive the right care at the right moment.
Our multidisciplinary team of psychiatrists, neurologists, neuropsychiatrists, therapists and technologists work together to deliver personalized, compassionate care for people living with brain and mental health conditions. By combining cutting-edge science with human understanding, we're creating a new model of care that replaces fragmentation with connection and uncertainty with clarity.
Headquartered in California, Salma Health is expanding access to innovative brain health care across the U.S., beginning with clinics in San Diego, Orange County, and clinics in the Bay Area and Los Angeles opening soon.