Enterprise Data Architect

United Technology
Auburn Hills, MI, United States
25 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Business Analytics Applications Information Systems Databases Data Architecture Data Governance Data Integration Extract Transform Load (ETL) Data Mart Data Migration Data Systems Data Warehousing Database Design
+16 more
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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:43 min

Building an anti-money laundering production architecture with Python

Stefan Donsa Stefan Donsa +1 · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

1:42 min

System architecture for ingesting and processing enterprise data

Sandeep Kusuma Sandeep Kusuma · WWC Europe 2026

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

Videos

See all

Related articles

See all