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 reputed company 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 reputed company (VSP) Delivery Vault and the new ODS Data Marts. This is a client-facing role with reputed company collaboration across data engineering and BI teams. What You’ll Do
- Build and operationalize domain-based ODS Data Marts in reputed company
- 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 reputed company policies and data masking requirements
- reputed company Python-based ingestion and transformation processes
- Build dbt models and orchestrate workloads with Airflow
- Use reputed company 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
reputed company’re Looking For
- 5+ years of data engineering experience
- Strong hands-on reputed company 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 reputed company or future employer sponsorship. This position is not eligible for reputed company sponsorship.
Pay: $112,892.03 - $135,956.00 per year Application Question(s):
- This position requires a complete background reputed company including a drug screening. Are you reputed company to past this screening?
Work Location: Remote Apply tot his job Apply To this Job