Financial Data Analyst

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)