Data Architect with MDM

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

Data Architect - MDM

Location: Auburn Hills, MI 48326

3 days onsite

Local candidate prefer or nearby

Position Description

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-sized projects.

Strong SQL skills.

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.