Senior Data Warehouse Specialist

Role: Senior Data Warehouse Specialist

Key Responsibilities

1. Data Warehouse Establishment & Strategy

Design and implement the overall Data Warehouse architecture (staging, integration, data marts, and analytics layers).

Develop a roadmap for enterprise data management aligned with business and digital transformation goals.

Define standards, governance policies, and best practices for data modeling, ETL, and master data management.

Ensure scalability to support future AI, predictive analytics, and IoT/Industry 4.0 initiatives.

2. System Design & Development

Build and maintain ETL processes for extracting and transforming data from multiple operational systems (ERP, MES, SCADA, CRM, HR, Finance).

Develop data models and semantic layers to support analytics and reporting needs.

Integrate real-time production, maintenance, and quality data to enhance decision-making in manufacturing operations.

Implement performance optimization and data validation mechanisms for accuracy and efficiency.3. Data Integration & Automation

Create seamless integration across different systems (SAP, MES, SCADA, LIMS, etc.) using APIs, middleware, and automation tools.

Design automated data pipelines to reduce manual intervention and improve reliability.

Develop data quality and reconciliation frameworks for financial, production, and logistics data consistency.

Support automation initiatives by making structured data available for RPA and AI models.

4. Business Intelligence & Advanced Analytics

Collaborate with business units to translate requirements into dashboards, KPIs, and analytical models.

Build SAC/Power BI / Tableau dashboards for operations, finance, sales, and production KPIs.

Support predictive analytics projects for demand forecasting, production optimization, and maintenance planning.

Partner with AI engineers and data scientists to operationalize machine learning models within the warehouse.

5. Governance, Security & Compliance

Implement data governance policies ensuring compliance with Saudi cybersecurity and data protection regulations (NCA, SAMA, CITC).

Define access control, data privacy, and encryption mechanisms.

Ensure full data lineage, traceability, and auditability across systems.

Maintain comprehensive documentation and disaster recovery procedures.

Qualifications

Bachelor's degree in Computer Science, Information Systems, or Data Engineering (Master's preferred).

Minimum 510 years of experience in data warehousing, data engineering, or BI, preferably in manufacturing or industrial sectors.

Strong experience with SQL, ETL tools (SSIS, Informatica, Talend), and data modeling (Kimball/Inmon).

Proficiency with cloud and on-prem data warehouse solutions (Azure Synapse, Snowflake, or SQL Server).

Experience integrating with SAP ERP, SCADA/MES, and industrial automation systems.

Knowledge of AI/ML data preparation and automation integration is a strong advantage.

Familiarity with cybersecurity and data governance frameworks in KSA.

Key Competencies

Strategic planning and execution

Strong analytical and problem-solving skills

Cross-functional collaboration with business and technical teams

Excellent communication and documentation skills

Ability to lead technical initiatives independently

Value Added to Organization

Establishes a unified enterprise data foundation for analytics and decision-making.

Enhances production efficiency through integrated data visibility.

Enables predictive and AI-driven insights to improve operations and reduce costs.

Strengthens governance, compliance, and data-driven culture across all subsidiaries.

If interested, kindly send your resume to [HIDDEN TEXT]