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 5–10 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 hr@isupportz.com