Job Description

Overview:

We are seeking a highly skilled and detail-oriented Financial Data Analyst & Reporting Specialist to consolidate and refine financial master data, develop dynamic analysis tools, and build powerful reporting frameworks using Excel and Power BI. The role involves hands-on creation of financial models, reporting systems, and data integration logic to support budgeting, forecasting, and strategic reporting initiatives.

Key Responsibilities:

The Data Analyst will be responsible for the following deliverables and activities:

1. Master Data Consolidation - Cost Centers & Chart of Accounts

Consolidate existing cost center data (from DMI, Masar, and Tawseel) into a unified master dataset. Map internal cost centers to sectors and reporting structures across subsidiaries. Refine and maintain the Chart of Accounts, including main and sub-accounts. Build an editable master data format with version control, formula protection, and historical mapping preservation. Ensure consistent coding across departments with future scalability in mind.

2. Unified Financial Reporting & Analysis Tool Development

Design a dynamic master file consolidating actuals (from 2024), budget (2025), and forecast data. Enable automated output. Integrate with existing data sources (e.g., Splash BI reports: PRs, LPOs, freelancer/program-level details). Include cash flow reporting features for tracking funding vs usage.

3. Newspaper Printing & Distribution Cost of Sales Modeling

Build a cost model covering Provide flexibility for structural updates in the cost model.

4. GRP System Reporting Enhancements

Act as a bridge between Finance, IT, and DDA for GRP report upgrades. Align outdated reports with updated master data and reporting logic. Define new GRP logic for: Payroll cash-basis tracking (e.g., EOS, leave) CAPEX vs Budget comparison Document reporting logic, system formats, and functional requirements.

5. EPM Budgeting Tool Support & BI Transition Planning

Support completion and validation of EPM tool templates and outputs. Engage with stakeholders to align budget reporting with department expectations. Define foundational structure for BI dashboards using internal tools. Prepare documentation/templates for seamless transition post-handover.

6. Power BI Report Development

Prepare, clean, and transform datasets for Power BI. Design, enhance, and publish management-level dashboards and reports. Ensure interactivity, dynamic filtering, and real-time updates. Provide knowledge transfer and training to internal teams.

Qualifications and Key Requirements:

Bachelor's degree in Finance, Accounting, Business Analytics, or a related field.

Proven experience in financial modeling, reporting, and data consolidation.

Advanced Excel skills (Power Query, dynamic modeling, formula protection).

Proficiency in Power BI (DAX, Power Query, data modeling).

Familiarity with ERP/reporting systems (e.g., GRP, Splash BI) is a strong advantage.

Strong communication and documentation skills.

Ability to work independently and deliver high-quality, user-friendly outputs.

Job Types: Full-time, Contract

Pay: AED10,000.00 - AED12,000.00 per month

Application Question(s):

Can you join immediately?
Experience:

* Power BI, dynamic modelling: 4 years (Required)