Data Warehouse Senior Consultant - Remote - Octopus by RTG

robusta; Remote; SAR 200,000 - 300,000; Full time

Job summary

A leading tech firm is seeking a Data Warehouse Senior Consultant in Saudi Arabia. This role focuses on managing the deployment of an enterprise Data Warehouse using Microsoft Fabric, including collaboration with vendors and ensuring data governance. Candidates should have at least 5 years of relevant experience and a Bachelor's degree in a related field. Critical skills include expertise with Microsoft tools like Power BI and strong communication in Arabic and English. This position offers a dynamic work environment with exciting projects.

Qualifications

• 5+ years of experience in Data Warehousing, ETL, or Business Intelligence projects.
• Strong hands-on experience with Microsoft Fabric tools.
• Fluent in Arabic and English.

Responsibilities

• Manage and coordinate day-to-day activities with the external vendor.
• Participate in designing data architecture and integration processes.
• Oversee ETL/ELT processes, ensuring data quality.

Skills

Data Warehousing

ETL

Microsoft Fabric tools

Data modeling

Analytical skills

Communication skills

Education

Bachelor's degree in Information Systems, Data Science, or Software Engineering

Tools

Microsoft Data Factory

Microsoft Synapse

Power BI

Job description

About Octopus by RTG

Octopus by RTG is the tech hiring and outsourcing arm of Robusta Technology Group, dedicated to connecting exceptional tech talent with top-tier organizations across the MENA, GCC, Europe, the US, and Canada. We specialize in building strong, long-term partnerships between skilled professionals and innovative companies. Our mission is to empower growth, innovation, and excellence by matching the right talent with the right opportunities.

Currently, we are hiring a Data Warehouse Senior Consultant for one of our partner organizations in KSA, offering the opportunity to contribute to exciting projects within a dynamic and forward-thinking environment.

Job Purpose

The Data Warehouse Senior Consultant is responsible for overseeing, coordinating, and supporting the implementation and operation of the organization’s enterprise Data Warehouse built on Microsoft Fabric. The platform leverages Data Factory, Synapse, and Power BI for data integration, modeling, and visualization. This role ensures effective collaboration with external implementation vendors, validates solution design, and builds internal data capabilities through knowledge transfer during the project phase. After implementation, the role will manage ongoing operations, governance, and performance of the Data Warehouse.

Key Responsibilities

• Manage and coordinate day-to-day activities with the external vendor implementing the Data Warehouse solution.
• Participate in designing data architecture, models, and integration processes using Microsoft Fabric components.
• Oversee ETL/ELT processes and data ingestion pipelines, ensuring data consistency and quality.
• Ensure proper integration between source systems (e.g., CRM, ERP, Finance, HR, Contact Center systems) and the Data Warehouse.
• Collaborate with business stakeholders to define KPIs, metrics, and reporting requirements.
• Ensure data governance, security, and compliance standards are followed.
• Document data mappings, lineage, and architecture diagrams.
• Manage and optimize performance, monitoring, and capacity planning post go-live.
• Conduct knowledge transfer sessions to empower internal data and analytics teams.
• Act as the organization’s subject matter expert for Data Warehousing and Microsoft Fabric platform operations.

Qualifications

• Bachelor’s degree in Information Systems, Data Science, or Software Engineering.
• 5+ years of experience in Data Warehousing, ETL, or Business Intelligence projects.
• Strong hands-on experience with Microsoft Fabric tools (Data Factory, Synapse, Power BI).
• Preferred certifications: Microsoft Certified Data Engineer Associate or Fabric Analytics Engineer.
• Solid understanding of data modeling, governance, and integration principles.
• Proven experience working with external vendors and managing data implementation projects.
• Excellent analytical, documentation, and communication skills.
• Fluent in Arabic and English.