DeveloperJobs.io
← Back to all jobs

Job Description

Stafford Gray is building reliable, governed data foundations that enable analytics and machine learning. This Lead Data Engineer role (hybrid in Lansing, MI) focuses on architecting and delivering a modern cloud data lakehouse, leading technical execution across the data engineering lifecycle, and mentoring engineers while partnering closely with data science and business teams.

What you’ll do

  • Design, build, and maintain ingestion pipelines that bring 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 remains traceable to its source system.
  • Implement data sharing and access controls so each subscriber receives only the entitled version of every data product.
  • Design star-schema operational data stores that feed Power BI and Tableau reporting.
  • Define standards for data quality, monitoring, validation, and governance.
  • Lead and mentor data engineers through design reviews, code reviews, and hands-on training.
  • Partner with data scientists, analysts, product teams, and business stakeholders to deliver data and ML solutions.

What you bring

  • Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.
  • 4+ years building extract-and-load pipelines into an enterprise data lake on a major cloud provider.
  • 4+ years transforming data lake datasets into data products with traceability to systems of record.
  • 2+ years enforcing data sharing or access policies for data products.
  • 4+ years programming with 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, ML pipelines.

Preferred background

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

Similar Jobs