DirectJobHub
Jobs · Michigan

Hiring - Data Architect - Auburn Hills, MI (Onsite / Hybrid) - Contract (W2)

C-Vision Inc. · Auburn Hills, MI · 2 mo ago
Contract

Location: Auburn Hills, MI (Onsite/Hybrid) – Long-term W2 contract

About the role

The Senior Enterprise Data Architect will design and implement Business Intelligence and Data Management solutions to meet business needs. This role reports directly to the Senior Manager for Enterprise Data Architecture and requires expertise in Master Data Management (MDM) and Data Warehouse (DW) technologies.

Responsibilities

  • Architect and design business intelligence solutions for accessing and analyzing data and metadata.
  • Design Enterprise Data Warehouse (EDW), Data Mart, and Operational Data Store (ODS) architectures.
  • Apply data modeling techniques, including star, snowflake, and other dimensional models.
  • Architect and develop database solutions using OLAP and OLTP technologies.
  • Lead or participate in design sessions, demonstrations, prototype sessions, testing, and training workshops.
  • Develop and maintain technical documentation.
  • Support business projects as a Subject Matter Expert (SME) in Enterprise Data Management.
  • Perform or delegate functions as agreed with the Senior Manager, ensuring all responsibilities are met.

Requirements

  • 7+ years of IT experience architecting solutions using Business Intelligence tools such as:
    • SAP BusinessObjects
    • QlikView
    • SAS
    • Oracle Hyperion Essbase
  • 7+ years of experience with:
    • Application Architecture
    • Data Warehousing
    • Master Data Management (IBM InfoSphere or Informatica MDM)
    • Data modeling
  • Extensive experience in architecture, data modeling, design, development, data migration, and data integration throughout the Software Development Life Cycle (SDLC).
  • Strong SQL skills.
  • Demonstrated analytical ability and creativity in solving complex problems on medium-sized projects.
  • Strong business and technical communication skills (verbal and written).
  • Experience creating metrics and dashboard analytics.
  • Self-motivated with the ability to work independently and meet deadlines.

Qualifications

Bachelor’s Degree in Computer Science, Information Systems, or equivalent.

Similar jobs