Data Engineer
Core
Design and implement modern semantic models and production ELT/ETL pipelines to support AI querying and analytical consumption for U.S. clients.
Role type
Data Engineer (ELT/ETL & Semantic Modeling)
Builds
Curated analytical views, production ELT/ETL pipelines, and semantic data layers
Domain
Data Engineering, AI/ML Infrastructure, Cloud Data Warehousing
Deliverable
production ML models
Required skills
SQL, ETL/ELT pipeline development, dimensional modeling (Kimball), semantic layering (dbt), database security (RBAC, RLS, dynamic masking), query optimization, data governance
Preferred skills
Orchestration platforms (Airflow/Prefect), vector databases, RAG frameworks
Technologies
Azure SQL, PostgreSQL, dbt, Airflow, Prefect
Responsibilities
Design and implement modern semantic models; Build curated, high-performance analytical views and production ELT/ETL pipelines; Optimize database query performance and schema definitions; Implement granular data governance frameworks; Establish comprehensive data quality and pipeline monitoring standards; Collaborate with cross-functional AI engineering teams to align data structures with RAG architectures.
Seniority
Mid-Senior (3+ years experience)