EngineerJobs.io
← Back to all jobs

Job Description

Stafford Gray is hiring a Lead Data Engineer in Lansing, Michigan (hybrid) to help shape and deliver a modern cloud data lakehouse. In this role, you will act as the technical lead for data engineering, architecting end-to-end pipelines and building governed, traceable data products while partnering closely with data science and business stakeholders.

What you’ll do

  • Design, build, and maintain pipelines to 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 every attribute is traceable back to its source system.
  • Implement data sharing and access controls so subscribers see only the version of each data product they are entitled to.
  • Design star-schema operational data stores to support Power BI and Tableau reporting.
  • Define and enforce standards for data quality, monitoring, validation, and 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 from databases, flat files, CSV, JSON, and APIs into Parquet.
  • 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 you may work with

AWS, Azure, GCP, Medallion (bronze/silver/gold) architecture, 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, graph databases, and ML pipelines.

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.

Similar Jobs