Data Warehouse Expert

Master-Works; Riyadh; On-site; SAR 262,000 - 338,000; Full time

Job summary

A leading data solutions company in Riyadh is seeking a highly experienced Data Warehouse Expert to lead the design and implementation of data warehousing solutions. You'll develop ETL pipelines, ensure data quality, and collaborate across teams. If you have 5-7 years of experience and a degree in Computer Science, apply to help drive strategic decisions through insightful data management.

Qualifications

• 5-7+ years of experience as a Data Warehouse Expert.
• Extensive knowledge of data warehousing best practices.
• Strong understanding of dimensional modeling.

Responsibilities

• Lead design and architecture of data warehouse systems.
• Develop comprehensive ETL pipelines.
• Monitor data warehouse performance.

Skills

Data warehousing methodologies

SQL proficiency

ETL tools

Data modeling

Problem-solving skills

Strong communication skills

Education

Bachelor’s or master’s degree in Computer Science

Tools

SQL Server

Oracle

Snowflake

Talend

Informatica

Microsoft SSIS

Tableau

Power BI

SAS

Job description

Master-Works is seeking a highly experienced Data Warehouse Expert to join our team. In this role, you will take the lead in designing and implementing sophisticated data warehousing solutions that support business intelligence and analytics initiatives. You will collaborate with various teams to ensure the effective integration, management, and utilization of data across the organization, providing insights that drive strategic decisions.

Key Responsibilities:

• Lead the design and architecture of data warehouse systems, ensuring scalability and performance optimization

• Develop comprehensive ETL pipelines to integrate data from multiple sources into the data warehouse

• Collaborate with stakeholders to define data requirements and translate business needs into technical specifications

• Implement data governance practices and ensure data quality and integrity within the data warehouse

• Monitor data warehouse performance and implement tuning and optimization strategies

• Provide guidance and mentorship to junior data warehouse engineers and analysts

• Stay abreast of the latest developments in data warehousing technologies and best practices

• Document data warehouse architectures, data flows, and processes for future reference and compliance

Requirements:

• Bachelor’s or master’s degree in Computer Science, Information Systems, or a related field

• Proven experience (5-7+ years) as a Data Warehouse Expert or in a similar role

• Extensive knowledge of data warehousing methodologies and best practices

• Proficiency in SQL and experience with database management systems (e.g., SQL Server, Oracle, Snowflake)

• Hands-on experience with ETL tools (e.g., Talend, Informatica, Microsoft SSIS) and data integration techniques

• Strong understanding of data modeling concepts (dimensional modeling, star schema, snowflake schema)

• Familiarity with BI tools (e.g., Tableau, Power BI, SAS) for reporting and analytics

• Excellent problem-solving skills and the ability to work under tight deadlines

• Strong communication skills and the ability to present complex technical concepts to non-technical stakeholders

• Certifications related to data warehousing or cloud platforms (e.g., AWS, Azure) are a plus