Data Engineer KSA - WSP

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 selfservice 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 semistructured 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 selfservice 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 & handson experience in SQL
• Any certicate(s) in the same eld is a plus.
• Bachelors degree in computer sciences engineering or similar fields
• Fluent in English & Arabic

Certification (as a plus):

• Microsoft Certied: Azure Data Engineering
• DA100: Analyzing data with Microsoft Power BI

Tools & Solutions Familiarity:

• Microsoft SSIS SSAS SSRS (to show familiarity dealing with a data pipeline and ETL)
• Handson experience and knowledge in Microsoft OLAP & selfservice 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 worlds 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 worklife 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.