Data Architect II

Select Minds LLC; Lansing (MI); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Onsite

Competitive salary

Opportunity for advancement

Job summary

Select Minds LLC is seeking a Senior Enterprise Data Architect to design and implement BI and data management solutions. The role partners with business and IT to deliver scalable data architectures, MDM, DW, reporting, and analytics.

Responsibilities include modeling, data integration, and leading design sessions while maintaining architecture documentation. In-person interview in Auburn Hills, MI is required.

Qualifications

• Experience architecting MDM and Data Warehouse solutions.
• Experience with BI, Data Management, and data integration technologies.
• Hands-on knowledge of SAP BusinessObjects and Oracle Hyperion Essbase.
• Strong SQL and data analysis skills.
• Experience with Enterprise Data Warehouse, Data Mart, and ODS architectures.
• Expertise in dimensional data modeling (star/snowflake).
• Experience across OLTP and OLAP清晰.
• Ability to lead/design sessions and create documentation.

Responsibilities

• Architect and design BI solutions for accessing, managing, and analyzing data and metadata.
• Define scalable data models, warehouse structures, and integration patterns.
• Provide MDM and enterprise data-management SME support for initiatives.
• Collaborate with business users and IT teams through design, prototyping, testing, and implementation.
• Produce and maintain architecture and technical documentation.
• Support delivery of reliable analytics and data-management solutions.

Skills

MDM

Data Warehouse

BI

Data modeling

SQL

OLTP/OLAP

Data analysis

communication

independence

Tools

SAP BusinessObjects

Oracle Hyperion Essbase

Job description

Benefits

• Onsite
• Competitive salary
• Opportunity for advancement

Job Title: Data Architect II / Senior Enterprise Data Architect

Location: Auburn Hills, MI — Day 1 Onsite

Employment Type: Contract

Pay Rate: based on experience, skills, and engagement type

Duration: Long Term

Interview Requirement: Candidates must be available to attend an in‑person, face‑to‑face final‑round interview in Auburn Hills, MI.

We are seeking a Senior Enterprise Data Architect to design and implement Business Intelligence and Enterprise Data Management solutions. This role will partner with business and IT stakeholders to deliver scalable data architecture, Master Data Management (MDM), Data Warehouse (DW), reporting, and analytics solutions.

Required Skills and Experience

• Strong experience architecting MDM and Data Warehouse solutions.
• Experience with Business Intelligence, Data Management, and data integration technologies.
• Hands‑on knowledge of SAP BusinessObjects and Oracle Hyperion Essbase.
• Strong SQL and data analysis skills.
• Experience with Enterprise Data Warehouse, Data Mart, and Operational Data Store architectures.
• Expertise in data modeling, including dimensional, star‑schema, and snowflake‑schema design.
• Experience designing solutions across OLTP and OLAP technologies.
• Background in data architecture, modeling, design, development, migration, and integration across the SDLC.
• Experience building metrics, dashboards, and analytical reporting.
• Ability to lead or participate in design sessions, demonstrations, prototypes, testing, and user training.
• Strong written and verbal communication skills.
• Ability to work independently, manage deadlines, and solve complex technical problems.

Key Responsibilities

• Architect and design BI solutions for accessing, managing, and analyzing data and metadata.
• Define scalable data models, warehouse structures, and integration patterns.
• Provide MDM and enterprise data‑management subject matter expertise for business initiatives.
• Collaborate with business users and IT teams through design, prototyping, testing, and implementation.
• Produce and maintain architecture and technical documentation.
• Support delivery of reliable, high‑quality analytics and data‑management solutions.