Data Warehouse Senior Consultant - Remote - Octopus by RTG

About Octopus By RTGOctopus 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 PurposeThe 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 ResponsibilitiesManage and coordinate day-to-day activities with the external vendor implementing the Data Warehouse solutionParticipate in designing data architecture, models, and integration processes using Microsoft Fabric componentsOversee ETL/ELT processes and data ingestion pipelines, ensuring data consistency and qualityEnsure proper integration between source systems (e.g., CRM, ERP, Finance, HR, Contact Center systems) and the Data WarehouseCollaborate with business stakeholders to define KPIs, metrics, and reporting requirementsEnsure data governance, security, and compliance standards are followedDocument data mappings, lineage, and architecture diagramsManage and optimize performance, monitoring, and capacity planning post go-liveConduct knowledge transfer sessions to empower internal data and analytics teamsAct as the organization's subject matter expert for Data Warehousing and Microsoft Fabric platform operationsRequirementsBachelor's degree in Information Systems, Data Science, or Software Engineering5+ years of experience in Data Warehousing, ETL, or Business Intelligence projectsStrong hands-on experience with Microsoft Fabric tools (Data Factory, Synapse, Power BI)Preferred certifications: Microsoft Certified Data Engineer Associate or Fabric Analytics EngineerSolid understanding of data modeling, governance, and integration principlesProven experience working with external vendors and managing data implementation projectsExcellent analytical, documentation, and communication skillsFluent in Arabic and English