Senior Data Engineer
Core
Design and own the target architecture for a multi-tenant data warehouse and curated layer serving the plastic surgery industry, enabling patient journey analysis and practice growth metrics.
Role type
Senior hands-on IC data engineer (warehouse architecture & semantic layer)
Builds
Amazon Redshift warehouse, curated data layers, semantic metric repository, and automated migration pipelines for healthcare practices.
Domain
Healthcare technology (vertical SaaS for plastic surgery)
Deliverable
production ML models | product features | dashboards & analysis
Required skills
End-to-end warehouse/lakehouse architecture ownership, deep SQL and Python, semantic/metrics layer design (dbt), dimensional/Data Vault modeling, infrastructure as code (Terraform), data quality testing/observability, AI integration in pipelines, regulated data handling.
Preferred skills
Experience with Snowflake/BigQuery/Databricks, LLM-assisted schema mapping, anomaly detection, natural language querying over semantic layers.
Technologies
Amazon Redshift, PostgreSQL, Python, Fivetran, Power BI, dbt, Airflow, Terraform, AWS, Claude Code, LLMs.
Responsibilities
Define semantic layer and business metric definitions; build gold layer and baseline reports; automate migration profiling and reconciliation; integrate unstructured clinical records; partner with engineering on data contracts; work with leadership on key performance indicators.
Seniority
Senior, hands-on IC