Senior Analytics Engineer with dbt, Data Team

DataArt; Georgia; On-site; USD 120,000 - 180,000; Full time

Job summary

DataArt is seeking a Senior Analytics Engineer to work hands-on across metrics governance, pipeline development, and legacy asset consolidation. You will contribute to reliable analytics workflows and improve data quality, consistency, and visibility across the organization.

The role involves building governed dbt models, developing Lightdash dashboards, and maintaining Airflow pipelines to feed Redshift. You will engage with non-technical stakeholders and help drive data-driven decisions.

Qualifications

• Strong analytics engineering or data engineering background.
• Advanced SQL skills.
• Experience with dbt and Redshift.
• Experience with Lightdash or similar dbt-native BI tool.
• Fluent English and ability to communicate with non-technical stakeholders.

Responsibilities

• Build governed dbt models for key business metrics.
• Develop Lightdash dashboards and metric trees for quality and drift monitoring.
• Create automated alerts for metric owners and owners' notifications.
• Document metric definitions, calculations, ownership, and data sources.
• Align metric definitions across business teams and ensure consistency.

Skills

Analytical thinking

Non-technical stakeholder engagement

English fluency

Tools

dbt

Lightdash

Airflow

Amazon Redshift

Python

Job description

We are looking for a Senior Analytics Engineer to work hands on across metrics governance, pipeline development, and legacy model consolidation. You will contribute to reliable analytics workflows and help improve consistency, quality, and visibility across business data.

You will work on a data initiative within an established analytics environment that uses dbt, Lightdash, Airflow, S3, and Redshift. The work includes governed business metrics, dashboard quality monitoring, API based ingestion, and the rationalisation of legacy analytics assets.

• Build governed dbt models for critical business metrics
• Develop Lightdash dashboards and metric trees to monitor metric quality freshness and drift
• Create automated alerts for metric owners
• Document metric definitions calculations ownership and sources
• Align metric definitions across business teams
• Build and maintain Airflow pipelines that ingest data from external APIs into Redshift
• Improve the Zendesk pipeline
• Reconcile ticket volume and CSAT figures with the source system
• Migrate or retire legacy dbt models and Lightdash content
• Use usage data and clear communication with users during legacy content consolidation

• Strong experience in analytics engineering or data engineering
• Strong experience with dbt
• Advanced SQL skills
• Experience with Amazon Redshift
• Experience with Lightdash or a similar dbt native BI tool
• Experience with Python
• Experience with Airflow for API based data ingestion
• Experience with data quality monitoring including freshness checks anomaly detection and alerting
• Experience with metric and semantic layer design
• Experience with data reconciliation against source systems
• Solid understanding of PII handling and data minimisation
• Confidence working with non technical stakeholders
• Fluent English