Data Warehouse Architect

Hybrid in Lansing, MI, US • Posted 3 hours ago • Updated 3 hours ago
Contract Corp To Corp
Contract W2
Contract Independent
12 Months
No Travel Required
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Warehouse Architect

Summary

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.

Role: Lead Data Engineer / Cloud Data Warehouse Architect

Location: Lansing, MI (Onsite required from Day 1; occasional travel to Ann Arbor, MI)

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

Interview Process

  • Round 1: Virtual interview (Candidates must join from a laptop, be ready to share their screen, and provide a live verification photo).
  • Round 2: In-person interview in Lansing, MI.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91138038
  • Position Id: 12519-13875-1794519607
  • Posted 3 hours ago

Company Info

About Stellar Professionals LLC

Stellar Professionals LLC stands out in the industry, offering a distinctive fusion of over 15 years of seasoned Staffing professionals and a vibrant community of over 150,000 LinkedIn followers. Our AGILE Staffing services are tailored to assist businesses in finding the ideal talent for their projects. In contrast, our Client Acquisition Services are focused on securing more public/private sector projects. Our disruptive approach to staffing and business consulting, encapsulated in our motto 'Agility and Excellence,' truly sets us apart. Contact us today to explore how we can transform your business. Stellar Professionals has a proven track record of success, offering comprehensive capabilities and profound industry knowledge to help you tackle your organization's most intricate issues.

Since our establishment, we have consistently broadened our client base, with a burgeoning roster of returning and new clients each year. This steady expansion is a testament to the value and caliber of our services, instilling unwavering confidence in our potential clients. ​ Many remarkable people want to do something significant but different. With over 15 years of experience in the Talent Acquisition and Staffing industry, we found that Staffing agencies spend a lot of money on Business Development and recruitment activities with low ROI. Therefore, we at Stellar Professionals LLC develop an innovative, cost-effective solution to help you build great Business partnerships and increase revenue.

Stellar Professionals LLC is currently accepting resumes for a variety of positions. Please review the database of positions that we are seeking to fill and contact us for additional information about any specific opportunity.

About_Company_OneAbout_Company_Two
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.