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