Senior Data Architect — BI & EDW Solutions

Delan Associates, Inc; Auburn Hills (MI); On-site; USD 120,000 - 180,000; Full time

Job summary

Delan Associates, Inc is seeking a Senior Enterprise Data Architect to design and implement BI and data management solutions. The role emphasizes MDM and DW technologies, with leadership under the Senior Manager for Enterprise Data Architecture.

The candidate should have strong SQL skills, experience with EDW/ODS/Data Marts, and proficiency in BI software and data integration technologies, enabling effective dashboards and analytics across complex datasets.

Qualifications

• SQL skills required for data querying and modeling.
• Experience creating metrics and dashboard analytics for BI.
• Strong business and technical communication skills (verbal & written).
• Analytical ability and creativity for solving complex problems on medium projects.
• Familiarity with enterprise BI software and data integration technologies.

Responsibilities

• Architect and design BI solutions for data and metadata access.
• Work with EDW, Data Mart, and ODS architectures.
• Model data using star/snowflake schemas and other dimensional methods.
• Develop DB solutions with OLAP and OLTP technologies.
• Create and maintain SDLC artifacts and technical docs.
• Lead design sessions and training with business users and IT.

Skills

SQL

Dashboard analytics

Communication skills

Analytical thinking

Data analysis tools

Tools

ETL tools

BI software

Data integration technologies

OLAP/OLTP

Job description

Delan Associates, Inc is seeking a Senior Enterprise Data Architect to design and implement BI and data management solutions. The role emphasizes MDM and DW technologies, with leadership under the Senior Manager for Enterprise Data Architecture.

The candidate should have strong SQL skills, experience with EDW/ODS/Data Marts, and proficiency in BI software and data integration technologies, enabling effective dashboards and analytics across complex datasets.