Senior Data Engineer - ODS Data Marts
Senior Data Engineer – ODS Data Marts / ETL-ELT
Overview
Simatree is seeking a Senior Data Engineer to support development of domain-based Operational Data Store (ODS) Data Marts on our Snowflake platform as a hands-on senior contributor. The ODS model is already designed; this role is focused on implementing orchestration and translation between the existing Snowflake (VSP) Delivery Vault and the new ODS Data Marts. This is a client-facing role with close collaboration across data engineering and BI teams. What You’ll Do
- Build and operationalize domain-based ODS Data Marts in Snowflake
- Implement orchestration and translation pipelines from the VSP Delivery Vault to ODS Data Marts
- Build secure ETL/ELT pipelines using RBAC-aware, least-privilege ingestion patterns
- Ensure pipelines are compatible with row access policies and data masking requirements
- Develop Python-based ingestion and transformation processes
- Build dbt models and orchestrate workloads with Airflow
- Use Snowflake Streams and Tasks for incremental load patterns
- Implement data quality checks, reconciliation controls, and end-to-end auditability
- Partner closely with the BI development team supporting report migrations
- Evaluate legacy reporting logic and determine best-practice placement across: Data layer, Yellowfin semantic layer, A hybrid approach where appropriate
What We’re Looking For
- 5+ years of data engineering experience
- Strong hands-on Snowflake experience
- Advanced Python and SQL skills
- Proven experience with dbt and Airflow
- Experience implementing data quality, reconciliation, and governance controls
- Experience collaborating with BI/reporting teams on logic ownership across data and semantic layers
- Strong client-facing communication and collaboration skills
Requirements
- Bachelors degree
- Applicants must be legally authorized to work in the United States without current or future employer sponsorship. This position is not eligible for visa sponsorship.
Pay: $112,892.03 - $135,956.00 per year Application Question(s):
- This position requires a complete background check including a drug screening. Are you able to past this screening?
Work Location: Remote Apply tot his job Apply To this Job