Senior Enterprise Data Architect; MDM | EDW | BI
Job in
Auburn Hills, Oakland County, Michigan, 48326, USA
Listed on 2026-07-17
Listing for:
United Technology
Full Time
position Listed on 2026-07-17
Job specializations:
-
IT/Tech
Data Engineering, Data Warehousing, Data Analyst, Database Administrator
Job Description & How to Apply Below
Position Summary
We are seeking an experienced Data Architect to design, develop, and implement enterprise data architecture solutions supporting Business Intelligence, Data Management, Master Data Management (MDM), and Data Warehouse initiatives. The ideal candidate will have extensive experience in enterprise data architecture, dimensional data modeling, data integration, and database design while partnering closely with business and technology stakeholders to deliver scalable, high-performance data solutions.
Key Responsibilities- Design and architect enterprise Business Intelligence (BI) and Data Management solutions.
- Develop scalable Enterprise Data Warehouse (EDW), Data Mart, and Operational Data Store (ODS) architectures.
- Design and implement Master Data Management (MDM) solutions.
- Create logical and physical data models using dimensional modeling techniques including Star Schema and Snowflake Schema.
- Architect database solutions utilizing both OLTP and OLAP technologies.
- Lead enterprise data architecture, data migration, and data integration initiatives throughout the Software Development Life Cycle (SDLC).
- Collaborate with business users and technical teams to gather requirements and define data solutions.
- Conduct design workshops, architecture reviews, prototype sessions, testing, and user training.
- Develop and maintain architecture documentation, technical specifications, and data standards.
- Provide subject matter expertise for Enterprise Data Management initiatives.
- Design dashboards, reporting solutions, and business metrics to support decision-making.
- Ensure data quality, governance, scalability, and performance across enterprise platforms.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- 12+ years of experience in Data Architecture, Data Warehousing, or Enterprise Data Management.
- Strong experience designing enterprise-scale data architecture solutions.
- Excellent analytical, communication, and documentation skills.
- Ability to work independently while managing multiple priorities and meeting deadlines.
- Enterprise Data Warehouse (EDW)
- Master Data Management (MDM)
- Data Mart & Operational Data Store (ODS)
- Data Modeling (Star Schema, Snowflake Schema, Dimensional Modeling)
- SQL (Advanced)
- Business Intelligence (BI) Architecture
- Data Integration
- Data Migration
- OLTP & OLAP Database Technologies
- Metadata Management
- Dashboard & Analytics Development
- SDLC
- Data Governance
- Performance Optimization
- Enterprise Business Intelligence platforms
- Data Integration and ETL tools
- Enterprise Analytics and Reporting
- Data Governance and Metadata Management
- Cross-functional collaboration with business and IT teams
- Technical leadership and architecture governance
- Enterprise Data Architecture
- Data Strategy & Governance
- Strong SQL and Database Design
- Problem Solving & Analytical Thinking
- Stakeholder Communication
- Technical Documentation
- Solution Design
- Team Collaboration
- Business Intelligence
12–18+ Years
Work Arrangement- Hybrid (3 Days Onsite)
- Auburn Hills, MI
- Local or Nearby Candidates Preferred
Position Requirements
10+ Years
work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×