Data Engineer: Analytics
Core
Design and build data ingestion, transformation, and modeling layers for client reporting; present findings and recommendations directly to client stakeholders.
Role type
Senior data engineer (analytics & reporting)
Builds
Production data pipelines, analytics layers, and client reporting dashboards
Domain
Technology consulting, financial services, insurance, manufacturing, hospitality
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL (window functions, CTEs, set logic), Relational database modeling (normalization, grain, keys, SCDs), dbt (incremental models, snapshots, tests), Python for data automation, Data profiling and cleaning, Quantitative reasoning, Presentation of data to non-technical audiences
Preferred skills
Snowflake SnowPro Core certification, Production Snowflake experience, Machine learning deployed to production
Technologies
Snowflake, dbt, Python, AWS, Google Cloud
Responsibilities
Design and build ingestion, transformation, and modeling layers for client reporting; Own data models end-to-end including grain, keys, relationships, and testing; Profile, clean, and reconcile source data; Build analytics layers to answer client questions; Present designs, findings, and recommendations to client stakeholders; Contribute to scoping at the pre-sales stage
Seniority
Senior, hands-on IC