Data Engineer

Kindsight; United States; Remote; USD 120,000 - 170,000; Full time

Benefits offered by this job

AWS CDK

Terraform

Tableau

QuickSight

Job summary

Kindsight is seeking a data platform engineer to 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.

You will deliver reliable, scalable data pipelines, write optimized SQL, and extend IaC for onboarding data sources, with a focus on security, quality, and governance.

Qualifications

• Qualifications not fully disclosed in source.

Responsibilities

• Build ELT pipelines for scheduled and near-real-time data loads into a cloud data lake.
• Develop medallion-style transformations and dimensional models including SCDs.
• Write and optimize SQL for transformations, aggregations, and data quality checks.
• Extend pipelines to onboard new data sources and validate against acceptance criteria.
• Add automated quality checks, reconciliation queries, and monitoring across data flow.
• Contribute infrastructure as code and support dashboards by aligning models with reporting needs.

Skills

SQL

Data modeling

ETL/ELT design

Cloud data platforms

Problem solving

Tools

AWS

Tableau

QuickSight

Terraform

AWS CDK

Job description

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.