Data Architect – MDM & DW Solutions (Onsite)

Mango Analytics; Auburn Hills (MI); On-site; USD 120,000 - 150,000; Full time

Job summary

Mango Analytics is seeking a Data Architect - MDM in Auburn Hills, MI to design and implement BI and data management solutions. The role focuses on MDm and DW technologies, with strong SQL, analytics, and BI tool expertise. On-site collaboration with the Enterprise Data Architecture team is required.

Applicant should have experience in EDW, DW, ODS architectures, dimensional modeling, and SDLC data integration. Strong communication and independent work ethic are valued in this mid-to-senior role.

Qualifications

• Experience with EDW, DW, and ODS architectures.
• Expertise in data modeling (star, snowflake).
• Experience with OLAP and OLTP architectures.
• SDLC data migration and data integration experience.
• Ability to lead design sessions and training workshops.

Responsibilities

• Architect and design business intelligence solutions for accessing data and metadata.
• Experience with Enterprise Data Warehouse architectures and data marts.
• Model data using star, snowflake, and other dimensional techniques.
• Develop and maintain technical documentation.
• Support Enterprise Data Management as SME knowledge.

Skills

SQL

Communication

Metrics & analytics

Analytical thinking

BI knowledge

Tools

BI software

Data integration tools

Job description

Mango Analytics is seeking a Data Architect - MDM in Auburn Hills, MI to design and implement BI and data management solutions. The role focuses on MDm and DW technologies, with strong SQL, analytics, and BI tool expertise. On-site collaboration with the Enterprise Data Architecture team is required.

Applicant should have experience in EDW, DW, ODS architectures, dimensional modeling, and SDLC data integration. Strong communication and independent work ethic are valued in this mid-to-senior role.