Data Engineer

Role overview Build and maintain the production data platform behind customer-facing analytics. The role covers the pipeline from ingesting customer data into a cloud data lake through transformation and dimensional modeling for dashboards and AI-driven insights, with a focus on reliable multi-customer datasets.

Responsibilities - Build ELT pipelines for scheduled loads and near-real-time change capture from customer systems into a cloud data lake. - Develop medallion-style transformations and dimensional models, including incremental processing, slowly changing dimensions, and derived metrics. - Write and optimize SQL for data transformations, aggregations, and quality checks across large datasets. - Extend configuration-driven pipelines to onboard data sources and validate each onboarding against acceptance criteria. - Add automated quality checks, reconciliation queries, and monitoring; investigate data issues from source through final reported values. - Contribute infrastructure as code and support dashboards by ensuring their underlying models meet reporting needs.

Requirements - The available source does not include a complete list of required candidate qualifications.

Nice to have - Experience with AWS CDK or Terraform for infrastructure as code. - Experience developing business intelligence reports in QuickSight or Tableau.