Senior Data Engineer
Core
Design and build the governed Snowflake transformation layer (raw → staging → conformed → marts) and migrate legacy SQL views to versioned dbt models to unify multi-ERP data for reporting and AI/ML use cases.
Role type
Senior Data Engineer (Analytics Engineering focus)
Builds
Production data transformation pipelines, conformed dimensional models, and semantic layers for BI and AI/ML consumption
Domain
Enterprise Data Engineering, Cloud Data Warehousing, ERP Integration
Deliverable
production ML models | product features
Required skills
Snowflake, dbt, SQL, Kimball dimensional modeling, Python, CI/CD, Git, Data Quality Testing, ERP modeling
Preferred skills
SAP ECC/S4HANA table modeling, Power BI semantic models, MDM tooling, SOX ITGC controls
Technologies
Snowflake, dbt, Python, Git, GitHub Actions, Airflow, Fivetran, Airbyte, Power BI, Elementary
Responsibilities
Design and build the transformation layer in Snowflake; Migrate existing SQL views to dbt-style versioned models; Define conformed dimensions and operational facts across multi-ERP environment; Implement data quality testing, observability, and lineage; Partner with AI/analytics team on feature-table patterns and data foundations; Set modeling, testing, naming, documentation, and CI/CD standards
Seniority
Senior, hands-on IC