Data Warehouse Architect

EPITEC; Southfield (MI); Hybrid; USD 118,473 - 126,739; Full time

Benefits offered by this job

Health insurance

Vision insurance

Dental insurance

Paid time off

401(k)

Flexible schedule

Job summary

A leading company is seeking a Data Architect to drive the design and implementation of data architecture for Dealer Systems within Marketing, Sales, and Service. The role requires a strategic thinker with extensive experience in data modeling and analytics architecture, collaborating with various teams to enhance data-driven decision-making.

Qualifications

• 7+ years of data modeling experience.
• 5+ years in data warehouse design.
• Strong understanding of data modeling principles.

Responsibilities

• Lead data design discussions and create data models.
• Conduct data quality analysis and propose solutions.
• Guide product teams in data model design.

Skills

Data modeling

Data quality

Analytics architecture

Communication

Collaboration

Education

Bachelor’s degree

Tools

PowerDesigner

ERWIN

Oracle

DB2

Teradata

Hadoop

MS SQL Server

PostgreSQL

GCP BigQuery

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by EPITEC. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$86.00/hr - $92.00/hr

Direct message the job poster from EPITEC

Job Title: Data Architect – Marketing, Sales & Service Systems

Location: Hybrid – Onsite in Southfield, MI a few days per week

Employment Type: Full-time

Benefits: Health, Vision, Dental, Paid time off, 401(k), Flexible schedule

Pay Range: $86 to $92 an hour

About the Role:

We are seeking a seasoned Data Architect to lead the design and implementation of data architecture for a major initiative focused on Dealer Systems within the Marketing, Sales, and Service domain. This role requires a strategic thinker with deep technical expertise in data modeling, data quality, and analytics architecture. You will collaborate with enterprise and solution architects, product teams, and business stakeholders to shape the future of data-driven decision-making.

Key Responsibilities:

• Lead data design discussions and create conceptual and logical data models, data dictionaries, and information flows.
• Define and maintain reporting strategies and identify authoritative data sources.
• Conduct data quality analysis, identify issues, and propose solutions.
• Guide product teams in physical data model design and implementation.
• Ensure adherence to data architecture standards, best practices, and governance.
• Develop and maintain an information architecture roadmap (now, near, and far view).
• Facilitate discussions to identify systems of record and define current and future state data flows.

Required Skills & Experience:

• 7+ years of data modeling experience with expertise in relational and/or dimensional analysis.
• 5+ years of experience in data warehouse design.
• Strong understanding of data modeling principles and architecture concepts.
• Hands-on experience with enterprise modeling tools (e.g., PowerDesigner, ERWIN).
• Proficiency in database technologies such as Oracle, DB2, Teradata, Hadoop, MS SQL Server, PostgreSQL, and GCP BigQuery.
• Experience with data analytics and cloud platforms, especially Google Cloud.
• Excellent communication and collaboration skills.

Preferred Qualifications:

• Experience with Master Data Management (MDM).
• GCP certification or other relevant data architecture certifications.

Education:

• Bachelor’s degree required; advanced certifications preferred.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Design and Information Technology

• Industries

  Retail Motor Vehicles

Referrals increase your chances of interviewing at EPITEC by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Disability insurance

Get notified about new Data Warehouse Architect jobs in Southfield, MI.

Delivery Solutions Architect - Data & AI

Livonia, MI $140,000.00-$200,000.00 2 weeks ago

Principal Data Security Engineer Dallas or Detroit metro

Detroit, MI $131,175.00-$218,625.00 1 day ago

Detroit, MI $112,597.33-$152,810.66 1 month ago

Pontiac, MI $140,000.00-$160,000.00 2 weeks ago

Data Architecture & Information Strategy Engineer

Detroit, MI $144,768.00-$209,109.33 1 month ago

Software Engineer I (Merchant Data Platform)

Senior Software Engineer - Data Delivery

Software Engineer I (Merchant Data Platform)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.