Data Warehouse Architect

Stellar Professionals
Lansing, MI, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours
Job source

Tech stack

Sql Data Warehouse Amazon Web Services Microsoft Azure Big Data Cloud Computing Cloud Database Information Systems Computer Programming Databases Directed Acyclic Graph (Directed Graphs) Data Governance Data Transformation
+30 more
Data Sharing Data Warehousing DevOps Github R (Programming Language) Python (Programming Language) NoSQL Operational Data Store Operational Databases Query Optimization Power BI DataOps SQL Databases Tableau (Software) Unstructured Data YAML Enterprise Data Management Parquet Google Cloud Apache Spark Pyspark Kubernetes Information Technology AWS Glue Apache Kafka Terraform Docker Jenkins Amazon Redshift Databricks

Job description

We are looking for a hands-on Lead Data Engineer / Cloud Data Warehouse Architect to design, build, and optimize scalable cloud data pipelines, Lakehouse architectures, and enterprise data/ML products. In this position, you will establish data engineering best practices, enforce data governance policies, mentor engineering staff, and collaborate across data science and analytics teams.

Requirements

Work Arrangement: Hybrid (Mandatory in-office on Wednesdays & Thursdays - no remote-only option)

Education: Bachelor’s Degree in Computer Science, Data Science, or Information Systems

About the Position

We are looking for a hands-on Lead Data Engineer / Cloud Data Warehouse Architect to design, build, and optimize scalable cloud data pipelines, Lakehouse architectures, and enterprise data/ML products. In this position, you will establish data engineering best practices, enforce data governance policies, mentor engineering staff, and collaborate across data science and analytics teams.

Must-Have Skills & Experience

  • Cloud Data Lake Engineering (4+ Years): Hands-on experience ingesting relational, semi-structured, and unstructured data into enterprise Data Lakes (AWS, Azure, or Google Cloud Platform) via Extract & Load pipelines.
  • Data Transformation & Lineage (4+ Years): Transforming cloud Data Lake datasets into production Data Products with clear traceability to Critical Data Elements (CDEs) in source systems.
  • Data Modeling & Programming (4+ Years): Strong proficiency in SQL, Python, PySpark, and R, query tuning, Star-schema operational data stores, and Lakehouse / Medallion Architecture (Parquet formats).
  • Data Governance & Access Control (2+ Years): Enforcing row/column-level Data Sharing Policies so subscribers only access entitled data versions.
  • Communication: Clear, concise written and verbal communication to lead technical discussions and mentor peers.

Preferred Tech Stack

  • Cloud & Big Data: Databricks, Spark, Kafka, AWS Glue, Redshift Spectrum, SageMaker, DBT
  • DevOps & Orchestration: Terraform, Docker, Kubernetes, GitHub, Jenkins, YAML, DAGs
  • Databases & BI: Relational, NoSQL, Graph DBs, Power BI, Tableau

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…