Haystack
← Back to Jobs
Technology

Job for Sr. Enterprise Data Architect at Auburn Hills, Michigan

Galactic Minds Inc.Auburn Hills, MI🇺🇸United StatesPosted 17 Jul 2026

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

Position: Sr. Enterprise Data Architect
Location: Auburn Hills, Michigan( Hybrid -3 day onsite)
Experience: 15+ Years

 

Job Summary

The Senior Enterprise Data Architect will be responsible for designing and implementing solutions within Business Intelligence and Data Management software and hardware to meet business requests. The ideal candidate should be able to create data solutions leveraging Master Data Management (MDM) and Data Warehouse (DW) technologies. This role will work under the direct leadership of the Senior Manager for Enterprise Data Architecture. Knowledge of industry-standard Business Intelligence software and Data Integration Management technologies is required.


Key Skills Required:

  • Enterprise Data Architecture
  • Master Data Management (MDM)
  • Data Warehouse (DW) & Enterprise Data Warehouse (EDW)
  • Data Marts & Operational Data Store (ODS)
  • Data Modeling
  • Star & Snowflake Schemas
  • OLAP & OLTP Systems
  • Strong SQL skills.

 

What We're Looking For:

  • Deep expertise in enterprise data strategy and governance
  • Strong experience designing and implementing large-scale data architectures
  • Proven ability to build and optimize data warehousing solutions
  • Expertise in dimensional modeling and data integration frameworks

Skills: Enterprise Data Architect, MDM, DW, EDW, Data Mart, operational Data Store (ODS), Data Modeling, Star, Snowflake, OLAP, OLTP

 

Functions Performed

  • This individual may be asked to solely perform these functions or may choose to delegate some of these functions to other members of their team, per agreement with the Senior Manager for Enterprise Data Architecture. Ultimately, responsibility for ensuring that the functions are performed rests with this position.
  • General Functions/Responsibilities
  • Architect and design business intelligence solutions for accessing and analyzing data and metadata.
  • Experience with Enterprise Data Warehouse (EDW), Data Mart, and Operational Data Store (ODS) architectures.
  • Expertise in data modeling, including star, snowflake, and other dimensional modeling techniques.
  • Experience architecting and developing database solutions using both OLAP and OLTP technologies.
  • Extensive experience in architecture, data modeling, design, development, data migration, and data integration throughout the Software Development Life Cycle (SDLC).
  • Participate in and/or lead design sessions, demonstrations, prototype sessions, testing, and training workshops with business users and IT associates.
  • Develop and maintain technical documentation.
  • Support business projects by providing Subject Matter Expert (SME) knowledge in Enterprise Data Management.

Skills

SQL
Snowflake

Similar jobs