Data Analyst

The Data Analyst will support Advania UK's Finance team by transforming financial and operational data into trusted insight. You will build and maintain repeatable reporting and analytics solutions that improve visibility of performance (e.g., revenue, margin, cost, NRR, and forecasting KPIs), enable faster decision-making, and strengthen governance over finance data., Your day-to-day responsibilities will include:

• Partner with Finance stakeholders to understand reporting needs and translate them into clear requirements, metrics definitions, and deliverables.
• Develop and maintain Power BI semantic models and dashboards, including robust measures and drill-through analysis to support month-end and performance reporting.
• Write and optimise SQL queries to extract, join, and validate data from multiple sources; document assumptions and business logic.
• Build scalable data transformations and pipelines in Databricks using Python and PySpark to cleanse, standardise, and enrich finance datasets.
• Implement automated data quality checks (reconciliation, completeness, variance analysis) and investigate anomalies with Finance and system owners.
• Create efficient Excel-based analysis and templates for ad-hoc finance work (e.g., pivots, Power Query, modelling), reducing manual effort through automation where possible.
• Maintain clear documentation for datasets, calculations, and reporting outputs to ensure transparency and auditability.
• Support continuous improvement initiatives across Finance, including standardising KPIs and improving reporting cadence and self-service access.
• Build and maintain business-wide commercial reports and dashboards, providing insight across the full sales lifecycle (pipeline, bookings, revenue, margin, and performance KPIs).

• Python experience for analysis and automation.
• Familiarity with Pandas library.
• Hands-on experience with Databricks, including PySpark for large-scale transformation and processing.
• Strong SQL skills for data extraction, transformation, and validation.
• Power BI development experience (data modelling, DAX, Power Query, report design, and performance optimisation).

Desirable

• Experience with finance/ERP systems and data warehouses/lakehouses.
• Exposure to Azure data services and modern analytics platforms (e.g., Microsoft Fabric, Azure Data Lake, Synapse)

Past experience of working within a finance department would be desirable.

The budgeted salary for this role is between £45,000 - £50,000 a year, depending on experience.

We are the tech company with people at heart. At Advania, we believe in empowering people to create sustainable value through the clever use of technology. As one of Microsoft's leading partners in the UK, specialising in Azure, Security, Dynamics 365, and Microsoft 365, we have a proven track record of success in delivering transformational IT services. Our Selection Process: We are committed to ensuring an equitable experience for all candidates, regardless of race, religion or belief, ethnic or national origin, disability, age, citizenship, marital, domestic or civil partnership status, sexual orientation, gender identity, or any other basis as protected by applicable law. Please do let us know if you'll need any reasonable adjustments as part of the selection process by highlighting these on your application form. As part of our commitment to our clients we will need to carry out background checks, including a criminal record check, for all offers of employment. If you have any unspent criminal convictions or questions about the screening process, please notify your recruiter once the application has been submitted.