Data Warehouse Architect (MDM & ODI)

Arisen IT Services; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A government solutions provider is looking for a highly experienced Data Warehouse Architect to implement enterprise-level data warehouse solutions in Albany, NY. The candidate must have over 12 years of experience in Data Warehouse development, along with expertise in Master Data Management (MDM) and Oracle Data Integrator (ODI). This role requires a Day 1 onsite presence, making it crucial for the candidate to collaborate directly with government agencies to gather requirements and implement data solutions.

Qualifications

• 12+ years of experience in Data Warehouse development and implementation.
• 7+ years of experience with Master Data Management (MDM).
• 7+ years of experience with Oracle Data Integrator (ODI).
• 7+ years of experience working with government agencies.

Responsibilities

• Architect, design, document, and implement enterprise data warehousing solutions.
• Work closely with agency/business subject matter experts to gather requirements.
• Develop data integrations for heterogeneous systems.

Skills

Enterprise Data Warehouse Architecture

Master Data Management (MDM)

Oracle Data Integrator (ODI)

ETL Development

SQL Data Modeling

COTS Integration

Kafka Integration

Government Data Systems

Job description

Position Overview

The State of New York is seeking a highly experienced Data Warehouse Architect with strong expertise in Master Data Management (MDM), Oracle Data Integrator (ODI), and government agency environments.

The ideal candidate will have extensive experience architecting, designing, and implementing enterprise-level data warehouse solutions within government agencies, working closely with business stakeholders, COTS vendors, and technical teams.

Job Details

• Client: State of New York
• Location: Albany, NY (Day 1 Onsite)
• Duration: 30 Months

Minimum Experience Requirements

• 12+ years of experience in Data Warehouse development and implementation
• 7+ years of experience with Master Data Management (MDM)
• 7+ years of experience with Oracle Data Integrator (ODI)
• 7+ years of experience working with government agencies

Detailed Qualifications

• 84 months of experience working with agency/business subject matter experts to gather requirements and translate them into data warehouse, application, and system designs within a government environment.
• 84 months of experience architecting, designing, documenting, and implementing:
  • Enterprise Data Warehousing solutions
  • COTS and Custom application integrations
  • Master Data Management solutions
  • (For a government agency)
• 84 months of experience in:
  • Data modeling
  • Designing normalized enterprise data warehouse environments
  • Implementing solutions using Oracle Data Integrator (ODI) and ETL technologies
  • (Within a government agency)
• 84 months of experience developing data integrations for heterogeneous systems and Business Intelligence environments using SQL.
• 84 months of experience performing database comparative analysis for:
  • Designing new transactional databases and data warehouses
  • Enhancing existing transactional systems and warehouse environments
• 84 months of experience applying analytical reasoning, data computation, interpretation, and presentation techniques to solve complex business problems.
• 84 months of experience implementing systematic Data Error/Recovery and Data Cleanup procedures.
• 84 months of experience integrating enterprise systems with Kafka.

Key Skills

• Enterprise Data Warehouse Architecture
• Master Data Management (MDM)
• Oracle Data Integrator (ODI)
• ETL Development
• SQLData Modeling (Normalized & Dimensional)
• COTS Integration
• Kafka Integration
• Government Data Systems

Work Requirement

This role requires Day 1 onsite presence in Albany, NY.