Job Description
\n
Title: Senior Enterprise Data Architect
\n
Location: Auburn Hills, MI 48326 (Locals Preferred)
\n
Work Schedule: Hybrid (3 Days Onsite)
\n
Employment Type: Contractual Role
\n
\n
Position Overview:
\n
\n
Client is seeking an experienced **Senior Enterprise Data Architect** to join its Enterprise Data Architecture team. This role will be responsible for designing and implementing enterprise-wide data solutions that support Business Intelligence, Data Management, Analytics, and Master Data Management initiatives.
\n
\n
The ideal candidate will possess deep expertise in Enterprise Data Warehousing, Data Modeling, Data Integration, and Business Intelligence architectures. This individual will work closely with business stakeholders, data engineers, analysts, and IT leadership to develop scalable and efficient enterprise data solutions that drive business decision-making.
\n
\n
Key Responsibilities:
\n
\n
* Design and architect enterprise-wide Business Intelligence and Data Management solutions.
\n
* Develop and maintain Enterprise Data Warehouse (EDW), Data Mart, and Operational Data Store (ODS) architectures.
\n
* Create logical and physical data models using dimensional modeling techniques including Star and Snowflake schemas.
\n
* Design and implement Master Data Management (MDM) solutions to improve data quality and consistency.
\n
* Architect data integration, ETL/ELT, and data migration solutions across enterprise platforms.
\n
* Collaborate with business and technical teams to gather requirements and translate them into scalable data solutions.
\n
* Support analytics, reporting, dashboarding, and performance management initiatives.
\n
* Participate in architecture reviews, design sessions, testing, demonstrations, and user workshops.
\n
* Provide technical leadership and subject matter expertise in Enterprise Data Management.
\n
* Develop and maintain architecture standards, data governance frameworks, and technical documentation.
\n
* Ensure alignment with enterprise architecture and data governance best practices.
\n
\n
Required Qualifications:
\n
\n
* 10+ years of experience in Data Architecture, Data Warehousing, Business Intelligence, or Enterprise Data Management.
\n
* Strong expertise in Enterprise Data Warehouse (EDW), Data Marts, and Operational Data Stores (ODS).
\n
* Extensive experience with data modeling, including Star Schema, Snowflake Schema, and Dimensional Modeling.
\n
* Strong understanding of Master Data Management (MDM) concepts and implementations.
\n
* Advanced SQL skills and database design expertise.
\n
* Experience with OLTP and OLAP database architectures.
\n
* Hands-on experience with data integration, ETL/ELT, and data migration initiatives.
\n
* Strong understanding of Software Development Life Cycle (SDLC) methodologies.
\n
* Excellent analytical, problem-solving, and communication skills.
\n
* Ability to work independently and effectively manage multiple priorities.
\n
\n
Preferred Qualifications:
\n
\n
* Experience with Snowflake, Databricks, Azure Data Platform, SQL Server, Oracle, Informatica, Talend, Power BI, Tableau, or similar technologies.
\n
* Experience within Automotive, Manufacturing, Supply Chain, or large enterprise environments.
\n
* Prior experience leading enterprise data transformation initiatives.
\n
\n