Data Warehouse Architect 3, Data Engineering Lead
  • Shiro Technologies
3 Days Ago
NA
W2
Lansing-MI
4-10 Years
Required Skills: Tableau, Product Development, Python, Recruiting, SQL, Microsoft Power BI, NoSQL, Data Orchestration, PySpark, Marketing Intelligence, Microsoft Azure, SQL*Plus, Marketing Intelligence, MI, Machine Learning, ML, Management, Mentorship, Information Systems, Jupyter Notebook, Kubernetes, Google Cloud Platform, GCP, Graph Databases, Spectrum, GitHub, Good Clinical Practice, GCP, Google Cloud, Docker, Extract, Load, Transform ELT, Extract, Transform, Load ETL, File Formats, Data Warehousing, Data Warehouse Architecture, Databricks, Data Processing, Data Quality, Data Science, Data Governance, Data Lakes, Data Modeling, Continuous Integration, CI, Data Engineering, Jenkins, Computer Science, Continuous Delivery, CD, Dashboard Development, Apache Spark, Cloud Computing, Collaboration, Amazon Web Services, AWS, Apache Kafka, Apache Parquet, Access Control, Amazon Redshift, Amazon SageMaker, Workflow Management, YAML, Star Schema, Terraform, Training, Unstructured Data
Job Description

We are looking for an experienced Data Warehouse Architect / Data Engineering Lead with strong expertise in Cloud Data Engineering, Data Lakehouse, Medallion Architecture, Data Modeling, and Enterprise Data Pipelines.

The ideal candidate should have hands-on experience building scalable ETL/ELT pipelines, transforming structured and unstructured data, implementing data governance and security policies, and delivering enterprise-level Data and ML products using AWS, Azure, or Google Cloud Platform.

Mandatory Technical Skills

  • 4+ years of hands-on experience in Cloud Data Engineering (AWS/Azure/Google Cloud Platform).
  • 4+ years of experience building ETL/ELT pipelines and ingesting data from relational, semi-structured, and unstructured sources.
  • 4+ years of experience in Data Lakehouse and Medallion Architecture (Bronze, Silver, Gold).
  • 4+ years of experience in Data Transformation, Data Modeling, and Data Product development.
  • 4+ years of Python, PySpark, Spark, and SQL programming.
  • 2+ years of experience implementing Data Sharing Policies, Data Governance, and access controls.
  • Strong experience with Star Schema, Data Warehousing, and Operational Data Stores.
  • Experience with Parquet file formats and large-scale distributed data processing.
  • Experience designing and delivering Power BI/Tableau dashboards.

Preferred Technical Skills

  • AWS Glue, Redshift, Redshift Spectrum, and SageMaker.
  • Azure Data Services / Google Cloud Data Services.
  • Databricks, DBT, Apache Spark, and Kafka.
  • Kubernetes, Docker, and Jupyter Notebooks.
  • Terraform, GitHub, Jenkins, YAML, and CI/CD.
  • DAGs and workflow orchestration.
  • NoSQL and Graph Databases.
  • DataHub and Data Governance/Security tools.
  • Machine Learning and Data/ML Pipeline development.
  • Power BI and Tableau.

Key Responsibilities

  • Lead the architecture, development, and maintenance of enterprise data pipelines.
  • Design and optimize Cloud Data Lake and Lakehouse architectures.
  • Implement Medallion Architecture for scalable data processing.
  • Build and manage ETL/ELT pipelines from multiple enterprise data sources.
  • Ensure data quality, lineage, traceability, security, and governance.
  • Implement data-sharing policies and role-based access controls.
  • Design Star Schema-based Operational Data Stores.
  • Collaborate with data scientists, analysts, and business stakeholders.
  • Mentor and provide technical guidance to data engineering teams.
  • Establish enterprise data engineering standards and best practices.
  • Support the State of Michigan's data engineering initiatives and provide technical guidance and training to data engineers.

Required Education

Bachelor's Degree in Computer Science, Data Science, Information Systems, or a related field.

Ideal Candidate Profile

We are looking for candidates with strong experience in:

Cloud Data Engineering + Data Warehouse Architecture + Lakehouse Architecture + Python/PySpark + SQL + Data Governance + AWS/Azure/Google Cloud Platform.

Jobseeker

Looking For Job?
Search Jobs

Recruiter

Are You Recruiting?
Search Candidates