Data Warehouse Expert

Job Title: Data Warehouse Expert

Engagement Type

Consultant – Project Management & Consulting (PMC) and Technical Support

Project Phase

Phase 3 – Implementation, PMC, and Technical Support

Reporting To

Project Director / Client Representative

Job Summary

The Data Warehouse Expert will provide specialized consulting, technical oversight, and project management support during Phase 3 of the project. The role is responsible for overseeing the implementation, integration, and optimization of the Data Warehouse solution, ensuring alignment with approved architecture, data governance standards, performance requirements, and project timelines through to the issuance of the Final Acceptance Certificate (FAC).

The consultant will work closely with system integrators, data engineers, vendors, and stakeholders to ensure the Data Warehouse solution is delivered, validated, and fully operational.

Key Responsibilities

Project Management & Oversight

• Monitor and oversee Data Warehouse implementation activities to ensure adherence to the approved project plan, scope, timelines, and milestones.
• Support the client in tracking progress, risks, issues, and dependencies related to data platforms and analytics deliverables.
• Ensure compliance with contractual, architectural, and data governance requirements.

Data Warehouse Architecture & Implementation

• Provide expert guidance on Data Warehouse architecture, data models, ETL/ELT pipelines, and integration approaches.
• Review and validate logical and physical data models, data integration designs, and implementation documents.
• Ensure scalability, performance, security, and reliability of the Data Warehouse solution.

Data Integration & Quality

• Oversee integration of data from multiple source systems, including transactional systems, applications, and third-party platforms.
• Ensure data accuracy, consistency, completeness, and timeliness across the Data Warehouse.
• Support the definition and enforcement of data quality, metadata management, and master data standards.

Stakeholder Coordination

• Facilitate coordination between system integrators, data engineers, BI/analytics teams, and business stakeholders.
• Participate in project meetings, design reviews, technical workshops, and status reporting.
• Act as a subject matter expert and trusted advisor to the client on Data Warehouse–related matters.

Testing, Validation & Performance

• Support and oversee data validation, reconciliation, and testing activities.
• Review results of system testing, integration testing, and user acceptance testing (UAT).
• Ensure performance tuning, optimization, and issue resolution during implementation.

Technical Support & Issue Resolution

• Identify, analyze, and resolve technical or operational challenges related to data ingestion, transformation, storage, and reporting.
• Provide hands-on technical support in specialized data domains as required during the implementation phase.