Data Warehouse Architect

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.

$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., Power Designer, ERWIN).
• Proficiency in database technologies such as Oracle, DB2, Teradata, Hadoop, MS SQL Server, Postgre
  
  SQL, and GCP Big Query.
• 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
  
  Mid-Senior level

• Employment type
  
  Contract

• Job function
  
  Design and Information Technology
• Industries Retail Motor Vehicles

Referrals increase your chances of interviewing at EPITEC by 2x

Medical insurance

Vision insurance

401(k)

Disability insurance

Apply BELOW