Data Architect Lead Consultant

NTT DATA North America; Michigan; On-site; USD 145,000 - 166,000; Full time

Benefits offered by this job

Medical insurance

401k

AD&D insurance

Job summary

NTT DATA North America seeks a Data Architect Lead Consultant to design and lead BI and data management initiatives in Auburn Hills, MI. You will architect solutions leveraging EDW, Data Mart, and ODS, with strong data modeling and MDM expertise.

The role requires 7+ years in BI and data warehousing, plus proficiency in SAP BO, QlikView, SAS, and Oracle Hyperion Essbase. Collaborative leadership and clear communication are essential.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, or equivalent.
• 7+ years of BI, data architecture experience.
• Experience with EDW, Data Mart and ODS architectures.
• Experience with OLAP and OLTP technologies.
• Knowledge of Master Data Management and DW technologies.
• Strong communication and analytical skills.

Responsibilities

• Architect and design BI solutions for accessing and analyzing data and metadata.
• Experience with EDW, Data Mart, and ODS architectures.
• Expertise in data modeling, including star and snowflake schemas.
• Develop database solutions using OLAP and OLTP technologies.
• Lead design sessions, demonstrations, prototype sessions, testing and training.
• Develop and maintain technical documentation.
• Provide SME knowledge in Enterprise Data Management.

Skills

SQL skills

Data warehousing

Data modeling

BI tools

Technical leadership

Enterprise architecture

MDM

Education

Bachelor's degree in CS/IS

Tools

SAP BusinessObjects

QlikView

SAS

Oracle Hyperion Essbase

Job description

NTT DATA strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward‑thinking organization, apply now. We are currently seeking a Data Architect Lead Consultant to join our team in Auburn Hills, Michigan (US-MI), United States (US).

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‑size projects.
• Strong SQL skills.

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.

Technical Experience

• 7 years of IT experience architecting solutions using Business Intelligence reporting and development tools such as:
  • SAP BusinessObjects
  • QlikView
  • SAS
  • Oracle Hyperion Essbase
• 7 years of experience with Application Architecture
• 7 years of experience with Data Warehousing
• 7 years of experience with Master Data Management (IBM InfoSphere or Informatica MDM)
• 7 years of experience with data modeling.

Educational Requirements

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

Benefits & Compensation

NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $70/hr to $80/hr. Actual compensation will depend on a number of factors, including the candidate’s relevant experience, technical skills, and other qualifications. This position is eligible for company benefits including participation in medical, dental, and vision insurance, flexible spending or health savings account, and AD&D insurance, employee assistance, participation in a 401k program, and additional voluntary or legally‑required benefits.

EEO Statement

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you’d like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.