Enterprise Data Architect

Coforge; Auburn Hills (MI); On-site; USD 140,000 - 190,000; Full time

Job summary

Coforge is seeking a Senior Enterprise Data Architect to design and implement BI and data management solutions. The role centers on leveraging MDM and DW/EDW technologies, ensuring alignment with business requests under the Enterprise Data Architecture leadership.

Ideal candidates will have substantial experience in BI software, data integration, and metadata analysis, along with strong communication skills to collaborate across IT and business units.

Qualifications

• 15+ years of hands-on experience in data architecture and BI
• Experience with MDM, DW/EDW, data modeling and data integration
• Strong knowledge of OLAP/OLTP and dimensional modeling techniques
• Expertise in designing Enterprise Data Warehouse architectures and data marts
• Familiarity with Snowflake and modern BI tools

Responsibilities

• Architect and design BI solutions for accessing data and metadata.
• Lead EDW, DW, ODS, and data modeling initiatives across SDLC.
• Develop and maintain technical documentation and architecture artifacts.
• Collaborate with business users and IT teams to deliver data solutions.
• Mentor team members and oversee complex data migrations.

Skills

Enterprise Data Architect

MDM

DW

EDW

Data Mart

ODS

Data Modeling

Star

Snowflake

OLAP

OLTP

Job description

Skills

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

Experience

15+ years

3 Days Onsite

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.

General

• Must be self‑motivated and able to work independently while consistently meeting deadlines.
• Strong business and technical verbal and written communication skills.
• Experience creating metrics and dashboard analytics.
• Strong working knowledge of different analysis tools and techniques.
• Demonstrated analytical ability and creativity in developing and implementing solutions for complex problems on medium‑size projects.

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.