Note: The job is a remote job and is open to candidates in USA. Optomi, in partnership with a leader in the healthcare revenue space, is seeking a Data Analytics Engineer to join their growing team! This team is building the platform foundation and semantic layer from the analysts' specs.
Responsibilities
- Connecting source systems into the enterprise data platform
- Integrating data through APIs or file transfers depending on the source
- Following established data architecture standards
- Building standardized pipelines within Databricks
- Federating cleaned data into Snowflake
- Repeating this integration process across roughly twenty different product data sources
Skills
- Strong SQL + data engineering (ELT/ETL pipeline development)
- Databricks — Spark/PySpark, Delta Lake, notebooks/jobs (standardization layer)
- Snowflake — SQL, warehouses/roles, and ideally semantic views / semantic models
- Data modeling— dimensional modeling, SCD Type 2 history, marts
- Cross-platform data federation (Databricks ? Snowflake)
- Python for pipelines; Git/DevOps version control, testing
- Snowflake Cortex / AI features and semantic-view definitions
- Healthcare RCM domain
- Transformation frameworks (e.g., dbt), performance tuning, data-platform ingestion frameworks
Company Overview