Lead Data Engineer

Stafford Gray

Lansing (MI)

Hybrid

USD 120,000 - 170,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Stafford Gray is seeking a Lead Data Engineer to architect a modern cloud data lakehouse and lead data engineering execution. You will mentor engineers, drive data governance, and collaborate with data science and business stakeholders to deliver data and ML solutions.

You will design pipelines across AWS/Azure/GCP, implement medallion-based transformations to Parquet data products, and enable self-service data sharing while ensuring data quality and traceability.

Qualifications

  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
  • 4+ years hands-on experience building extract-and-load pipelines into an enterprise data lake on a major cloud provider.
  • 4+ years hands-on experience transforming data lake datasets into data products with traceability to systems of record.
  • 2+ years experience enforcing data sharing or access policies on data products.
  • 4+ years programming in Python, PySpark, and SQL, including SQL tuning and loading data into Parquet from databases, flat files, CSV, JSON, and APIs.
  • Experience designing star-schema data stores for BI reporting.
  • Must live within 90 miles of Lansing, MI and be able to work a hybrid onsite schedule.

Responsibilities

  • Design, build, and maintain pipelines that ingest relational, semi-structured, and unstructured data into a cloud data lake on AWS, Azure, or GCP.
  • Transform lake datasets using a Medallion (bronze/silver/gold) approach into Parquet-based data products with traceability to source systems.
  • Implement and enforce data sharing and access policies so subscribers view only entitled versions of data products.
  • Design star-schema operational data stores that feed Power BI and Tableau reporting.
  • Define and uphold standards for data quality, monitoring, validation, and data governance.
  • Lead and mentor data engineers through design reviews, code reviews, and hands-on training.
  • Collaborate with data scientists, analysts, product teams, and business stakeholders to deliver data and ML solutions.

Skills

Mentoring
Data governance
Leadership
Collaboration

Education

Bachelor's degree

Tools

Databricks
Spark
DBT
Glue
Redshift Spectrum
SageMaker
Kafka
Kubernetes
Docker
GitHub
Jenkins
Terraform
YAML
Airflow

Job description

The Lead Data Engineer at Stafford Gray will architect and deliver a modern cloud data lakehouse, while acting as the technical lead for data engineering execution. The role includes building governed data products, overseeing pipeline and transformation patterns, and mentoring engineers through reviews and hands-on support, in coordination with data science and business stakeholders.

Responsibilities
  • Design, build, and maintain pipelines that ingest relational, semi-structured, and unstructured data into a cloud data lake on AWS, Azure, or GCP.
  • Transform lake datasets using a Medallion (bronze/silver/gold) approach into Parquet-based data products, ensuring each attribute can be traced back to its source system.
  • Implement and enforce data sharing and access policies so subscribers can view only the versions of data products they are entitled to.
  • Design star-schema operational data stores that feed Power BI and Tableau reporting.
  • Define and uphold standards for data quality, monitoring, validation, and data governance.
  • Lead and mentor data engineers through design reviews, code reviews, and hands-on training.
  • Collaborate with data scientists, analysts, product teams, and business stakeholders to deliver data and ML solutions.
Requirements
  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
  • 4+ years of hands-on experience building extract-and-load pipelines into an enterprise data lake on a major cloud provider.
  • 4+ years of hands-on experience transforming data lake datasets into data products with traceability to systems of record.
  • 2+ years of experience enforcing data sharing or access policies on data products.
  • 4+ years of programming in Python, PySpark, and SQL, including SQL tuning and loading data into Parquet from databases, flat files, CSV, JSON, and APIs.
  • Experience designing star-schema data stores for BI reporting.
  • Must live within 90 miles of Lansing, MI at the time of submission and be able to work a hybrid onsite schedule.
Technologies

Work includes AWS, Azure, GCP, Medallion (bronze/silver/gold), Parquet, Power BI, Tableau, Python, PySpark, SQL, CSV, JSON, APIs, Databricks, Spark, DBT, Glue, Redshift Spectrum, SageMaker, Kafka, Kubernetes, Docker, GitHub, Jenkins, Terraform, YAML, Airflow DAGs, NoSQL, and graph databases, plus ML pipeline development.

Preferred
  • Experience with Databricks, Spark, DBT, Glue, Redshift Spectrum, and SageMaker.
  • Experience with Kafka, Kubernetes, and Docker.
  • DevOps and infrastructure-as-code experience using GitHub, Jenkins, Terraform, YAML, and Airflow DAGs.
  • Experience with cloud-native data governance and security tooling.
  • Experience with NoSQL and graph databases, and with ML pipelines.
  • A track record of championing data engineering standards across a developer community.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer (Lakehouse / Databricks)
Lead Data Engineer (Lakehouse / Databricks)

Stafford Gray • Town of Lansing (NY)

Hybrid
USD 130,000 - 180,000
Lead Data Engineer
Lead Data Engineer

MasterApp Labs • Lansing (MI)

Hybrid
USD 83,000 - 165,000
401(k) matching
Dental insurance
Health insurance
+1
Lead Data Engineer
Lead Data Engineer

Recru • Houston (TX)

On-site
USD 130,000 - 150,000
Lead Data Engineer
Lead Data Engineer

Accion Labs • Dallas (TX)

On-site
USD 140,000 - 200,000
Lead Databricks Data Engineer
Lead Databricks Data Engineer

EXL Talent Acquisition Team • New York (NY)

On-site
USD 180,000 - 240,000
Data Engineer Lead / Data Warehouse Architect
Data Engineer Lead / Data Warehouse Architect

Govan Systems inc • Lansing (MI)

Hybrid
USD 120,000 - 180,000
Data Engineer Lead
Data Engineer Lead

Ethereum Technologies • Lansing (MI)

On-site
USD 83,000 - 118,000
Lead Data Architect
Lead Data Architect

FinThrive • United States

On-site
USD 90,000 - 150,000
Data Engineer Lead
Data Engineer Lead

Robotic Technologies Automation • Lansing (MI)

On-site
USD 83,000 - 124,000
Cloud Data Platform Lead — Lakehouse & BI Pipelines
Cloud Data Platform Lead — Lakehouse & BI Pipelines

Stafford Gray • Lansing (MI)

Hybrid
USD 120,000 - 170,000