Technical Data Architect

About the role

Our consulting client is looking for a Technical Data Architect to work on a hybrid schedule in their client's office in Auburn Hills, Michigan. The Technical Data Architect will design and implement enterprise data management and business intelligence solutions that support strategic business initiatives. This role will lead data architecture efforts across data warehousing, master data management (MDM), data integration, and analytics platforms.

Responsibilities

• Design and architect enterprise data warehouse (EDW), data mart, and operational data store (ODS) solutions.
• Develop data models using star, snowflake, and dimensional modeling techniques.
• Lead data integration, migration, and MDM initiatives.
• Architect and support BI reporting and analytics solutions.
• Collaborate with business and IT stakeholders to define requirements and deliver scalable data solutions.
• Provide SME support and maintain technical documentation.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• A minimum of 7 years of experience in enterprise data architecture, data warehousing, and application architecture.
• Experience with Master Data Management (IBM InfoSphere MDM or Informatica MDM).
• Expertise in data modeling, OLTP/OLAP technologies, SQL, and database design.
• Experience with BI tools such as SAP BusinessObjects, QlikView.

Work Environment

This position is onsite and requires you to work closely with other individuals in a collaborative team environment. In this position, you may have access to client or customer systems, confidential and/or proprietary information or data.