Senior Specialist - Data Engineering & Analytics

Role Overview

Senior Specialist - Data Engineering & Analytics at Al Ghurair. This role is responsible for the design, development, implementation, management and support of mission critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments.

Role Purpose

Drive adoption of Analytics and Reporting capabilities by designing and implementing scalable data pipelines, ETL processes, and business intelligence solutions. Enable the organization to become data-driven by transforming structured, unstructured and disparate source data into actionable insights, while building internal data capability and strategy.

Key Responsibilities

Strategy & Planning

• Support the development of data strategy and internal processes of the organization.
• Evaluate existing data and analytics systems and support planning of Data Analytics and AI roadmap.
• Enable a data-driven strategy by recommending the best way to organize, analyze, and present data.
• Stay up to date with the latest trends, technologies, and best practices in data engineering and recommend innovative solutions to improve data infrastructure and processes.

Business Requirements & Analysis

• Gather, document, and approve business requirements for data analytics reporting projects.
• Perform business analysis to gather required needs on overall analytic needs.
• Translate business requirements into specifications that will be used to drive data store/data warehouse/data mart design and configuration.
• Collaborate with data scientists, analysts, and stakeholders to understand data requirements and translate them into technical specifications and data models.
• Manage the business analytics portfolio for the respective business which you are going to lead.
• Work with business and cross-functional teams on requirements gathering and documentation.

Data Pipeline & ETL Development

• Design, develop and implement ETL processes to transform structured, unstructured and disparate source data into the target data store(s)/data warehouse(s)/data mart(s).
• Design and develop scalable and robust data pipelines for ingesting, processing, and transforming large volumes of data from various sources.
• Optimize and tune data pipelines for performance, reliability, and scalability.
• Develop and maintain data processing frameworks and tools to facilitate efficient data analysis and reporting.

Data Warehouse & Storage Design

• Design and maintain data warehouses, data lakes, and other data storage systems.
• Demonstrate expertise in data modelling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modelling, Fact and Dimensional tables, Physical and logical data modelling.

Data Quality & Governance

• Implement data quality checks, validation rules, and monitoring systems to ensure data integrity and accuracy.

Analytics & Reporting

• Prototype and showcase dashboards to collect additional feedback and build additional requirements in iterative manner.
• Drive business to self-enable on the self-service analytics and provide enough support to upskill.
• Develop and implement Data Warehousing using Alteryx and Business Intelligence (BI) applications using Power BI/Tableau/Business Objects.

Community & Capability Building

• Build data community among the business and lead them deliver business value on data and embrace data as strategic asset.

Operations & Support

• Transition developed BI systems to the Operations & Support team.
• Provide support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users.

Qualifications & Experience

• Bachelor's or Master's degree in Computer Science.
• 8 to 11 years' experience implementing Advanced Analytics, data engineering and Reporting Solutions.
• Working with users in a requirements analysis role.
• Proven track record in administering, developing and implementing Data Warehousing using Alteryx and Business Intelligence (BI) applications using Power BI/Tableau/Business Objects.
• Desired: Certification in Data Warehousing, ETL, Analytics and Reporting Solutions.

Skills & Competencies

• Hands-on experience with Python for Data Engineering.
• Extensive use of SQL and RDBMS systems (DB2, Oracle, SQL Server, etc.).
• Strong experience in Query Languages like PL/SQL, SQL Server, Spark SQL, T-SQL.
• Knowledge of using Airflow.
• Hands-on experience working with multiple data sources and APIs.
• Good understanding of Algorithms and basic statistics.
• Proficiency with Data wrangling, Data visualization, Analytics and Reporting.
• Cloud knowledge on AWS, Azure or Google platform for data warehouse.
• Ability to manage multiple priorities and assess and adjust quickly to changing priorities.
• Must be able to perform duties with moderate to low supervision.

Additional Information

• Full details are available on the employer's original posting.