Data Analyst

Key Responsibilities:

·       Clean and prepare data by removing duplicates, resolving inconsistencies, and standardizing formats using Excel and/or Power Query

·       Deliver daily, weekly, and monthly MI reports for internal and external stakeholders, ensuring accuracy and timeliness

·       Consolidate and validate data from multiple sources to produce reliable and consistent reporting outputs

·       Design, maintain, and enhance reporting templates to support recurring business needs

·       Automate reporting processes using VBA and/or Power Query to improve efficiency and reduce manual effort

·       Build and maintain Excel dashboards (PivotTables, PivotCharts) and Power BI reports based on defined KPIs

·       Structure and model data in Power BI, including managing relationships between datasets

·       Create basic DAX measures and calculated fields to support reporting requirements

·       Perform data validation and ensure outputs align with source data and business logic

·       Document reporting processes, data sources, and calculation logic

·       Identify data or reporting issues, communicate them to relevant stakeholders, and support resolution

Qualifications:

·        Strong Excel skills (PivotTables, formulas such as XLOOKUP/INDEX-MATCH, data handling)

·        Experience with Power BI (data loading, basic modelling, building reports and dashboards)

·        Familiarity with Power Query and/or VBA for automation

·        Good understanding of data structures and data quality principles

·        High attention to detail and accuracy

·        Ability to manage multiple tasks and meet deadlines

·        Good communication skills and ability to work with stakeholders