Data Engineer

WSP is a leading engineering and professional services consulting firm seeking a talented individual to join their team. In this role, you will play a key role in translating business needs into actionable insights through data analysis and compelling data visualizations.

Responsibilities:

• Translate complex business requirements into clear technical specifications for data analysis and visualization.

• Design, develop, and maintain data visualizations, dashboards, and key performance indicators (KPIs).

• Collaborate with data warehousing and BI storage teams to access data for visualization purposes (e.g., OLAP cubes, self-service analytics tools).

• Conduct thorough testing and troubleshooting of data and visualizations.

• Develop and execute SQL queries to extract and analyze data from databases.

• Work comfortably with various data formats, including structured, semi-structured, and geospatial data.

• Cleanse and normalize data to ensure accuracy and consistency.

• Integrate data from multiple sources into comprehensive dashboards.

• Create visually appealing and informative dashboards to effectively communicate insights.

We are looking for a candidate with the following qualifications:

• 5-8 years of experience in data visualization and/or data engineering (required).

• Proven experience with popular BI tools such as Power BI and Tableau (required).

• In-depth understanding of database management systems, online analytical processing (OLAP) for self-service analytics, and ETL processes (required).

• Experience and thorough grasp of data warehouse design and dimensional modeling (required).

• Ability to design and build data models from scratch (required).

• Hands-on experience with Microsoft SSIS, SSAS (essential).

• Strong knowledge and practical experience in SQL (required).

• Any certifications in data analysis or data visualization (a plus).

• Bachelor's degree in computer science, engineering, or a related field (required).

• Fluency in English and Arabic (required).

Plus factors:

• Microsoft Certified: Azure Data Engineering

• DA-100: Analyzing Data with Microsoft Power BI

• Familiarity with data management platforms such as Informatica ETL, Axon, EDC, or Collibra