Data Engineer (KSA)

The ideal candidate must be able to work with large dataset with a strong experience using a variety of data analysis & ETL approaches (familiar with some technology providers and solutions in the market), using a variety of data tools, building, and understanding Data models, developing ETL pipelines for business data to be ultimately visualized for decision support. Must have the technical capabilities which allow him / her to extract / ingest the data from various sources, transform the data, and develop dashboards reflecting the required KPIs.

The candidate must be comfortable working with a wide range of stakeholders and functional teams. The right candidate will have a passion for discovering solutions hidden in large data sets and working with stakeholders to improve business outcomes.

• Translate business needs to technical specifications.
• Design, build and maintain charts, dashboards and KPIs.
• Communicate with data warehousing & BI storage tools (e.g. OLAP cubes – self-service analytics) to get the data for visualization.
• Conduct testing and troubleshooting.
• Develop and execute SQL database queries and conduct analysis.
• Work with different data format, structured, semi-structured and geospatial.
• Data cleansing and normalization
• Integrate data from multiple data sources in one dashboard.
• Create high quality design dashboards (visuals)

• 5 to 8 years of experience in data visualization and data engineering role
• Experience with common BI technologies such as Power BI and Tableau
• Deep understanding of database management systems, online analytical processing (OLAP for self-service analytics) and ETL process.
• Experience and thorough understanding of data warehouse design and dimensional modelling.
• Ability to design & build data models from scratch.
• Experience in Microsoft stack such as SSIS and SSAS is essential.
• Deep knowledge & hands-on experience in SQL
• Any certificate(s) in the same field is a plus.
• Bachelor’s degree in computer sciences, engineering, or similar fields
• Fluent in English & Arabic

Certification (as a plus):

• Microsoft Certified: Azure Data Engineering
• DA-100: Analyzing data with Microsoft Power BI

Tools & Solutions Familiarity:

• Microsoft SSIS, SSAS, SSRS (to show familiarity dealing with a data pipeline and ETL)
• Hands-on experience and knowledge in Microsoft OLAP & self-service analytics
• Power BI, Tableau, Qlik (Data Visualization knowledge)
• Informatica ETL, Axon, EDC etc. (or similar solutions like Collibra) (familiarity in Data Management platforms)

WSP is one of the world’s leading engineering and professional services consulting firms. Dedicated to our local communities, and propelled by international expertise, we are technical experts and strategic advisors, working together to solve some of the most complex challenges.

Here at WSP, we greatly value your work-life balance, and your requirements for flexibility. Work is only one part of our lives, and making time for other things is important, be that our families, our friends, or ourselves.

As well as rewarding you with competitive pay, WSP offers first class medical cover, generous annual leave, and paid professional subscriptions.

Be you, be happy – we strive to maintain a friendly and inclusive culture which respects and maximises the contribution every individual can bring to WSP. We recognize the value of working with diverse teams of varying backgrounds and experiences, and we positively encourage applications from suitably qualified and eligible candidates of all backgrounds.

Our team is made up of technical experts and strategic advisors including engineers, technicians, scientists, architects, planners, surveyors, environmental specialists, designers, and program and construction management professionals.

Together we utilise our local understanding, international reach, and global scale to prepare our cities and environments for the future, connect communities, and help societies thrive in built and natural ecosystems.

We design lasting solutions in the Property & Buildings, Transportation & Infrastructure, Environment, Industry, Resources (including Mining and
Oil & Gas) and Power & Energy sectors as well as project delivery and
strategic consulting services.