Enterprise Data Architect
United Technology
Auburn Hills, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Auburn Hills, United States of America
Tech stack
Business Analytics Applications
Information Systems
Databases
Data Architecture
Data Governance
Data Integration
ETL
Data Mart
Data Migration
Data Systems
Data Warehousing
Database Design
Dimensional Modeling
Meta-Data Management
Online Analytical Processing
Operational Data Store
Online Transaction Processing
Performance Tuning
Systems Development Life Cycle
Standard Sql
Software Engineering
SQL Databases
Enterprise Data Management
Data Strategy
Information Technology
Star Schema
Data Management
Tools for Reporting
Job description
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., * 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.
Requirements
- 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.
Required Technical Skills
- 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
Preferred Experience
- 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
Key Competencies
- 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