Axis CLC is a national property maintenance and compliance partner, backed by over 110 years of combined experience. We employ more than 2,500 people and support over 400 clients across the UK, delivering essential repairs, refurbishment and building safety services that keep homes and public buildings operating at their best. Each year we complete over 400,000 repairs, helping to keep tenants safe, properties performing and owners fully compliant. An exciting opportunity has arisen for a Reporting & Data Analyst to join the Finance team at the Head Office in Stratford, East London, on a fixed-term contract. The successful candidate will play a key role in supporting data migration, validation and reconciliation activities, ensuring the delivery of accurate and reliable financial and operational reporting. Working closely with Finance, IT and operational stakeholders, the role will help maintain data integrity, enhance reporting capabilities and provide valuable insights to support business performance and informed decision-making across the Group. Reporting to the Finance Systems Reporting Lead, this role sits at the intersection of finance, data and systems. The Reporting & Data Analyst will play a vital role in ensuring data integrity during system transitions, managing data migration pipelines, and executing robust financial reconciliations. It will also be responsible for extracting, transforming and analysing data from Dynamics 365 Finance & Operations (D365 F&O), frontline operational systems and a range of Excel sheets, legacy, and unstructured sources, translating complex datasets into clear, actionable insight for finance and operational stakeholders. What You’ll Do * Extract financial and operational data from D365 Finance & Operations, Excel-based applications, and core operational systems using appropriate tools and methods, including DMF, OData, and BYOD * Support data migration activities by mapping, validating, and transferring legacy financial and operational datasets into D365 F&O * Perform comprehensive data reconciliation across systems to ensure complete data integrity, identifying, investigating, and resolving any variances between legacy records, core operational platforms, and target environments * Transform and structure data from unstructured sources such as spreadsheets or CSV files using Power Query * Develop, maintain and improve Excel-based reporting, including PivotTables, Power Pivot models and advanced formulas * Perform data validation and cleansing activities, identifying root causes of data quality issues and implementing sustainable solutions * Work closely with finance, IT and operational stakeholders to map out data lineage, document migration business rules, and deliver trusted financial reporting. About You * Proven experience in data migration, data mapping, validation and reconciliation across multiple systems. * Strong understanding of financial data structures, reporting requirements and reconciliation controls. * Experience working with Microsoft Dynamics 365 Finance & Operations (D365 F&O), including DMF, OData and BYOD. * Advanced Microsoft Excel skills, including PivotTables, Power Pivot, Power Query, complex formulas and data modelling. * Strong data analysis skills with the ability to extract meaningful insights from large and complex datasets. * Experience transforming and cleansing data from legacy systems, spreadsheets, CSV files and other unstructured data sources. * Excellent attention to detail with a focus on data accuracy, integrity and quality assurance. * Ability to identify, investigate and resolve data discrepancies and reconciliation issues. * Understanding of data governance, data lineage and data quality management principles. * Strong problem-solving skills with the ability to analyse root causes and implement sustainable improvements. * Experience producing clear, concise and meaningful financial and operational reports for a range of stakeholders. * Ability to communicate complex technical and data-related information to non-technical audiences. * Strong stakeholder management skills with experience collaborating across Finance, IT and operational teams. * Knowledge of reporting and business intelligence tools would be advantageous. What We Offer * Salary up to £70,000 depending on experience * Pension, medical scheme options and life assurance * 25 days’ holiday (Pro Rata) + bank holidays * Perkbox benefits worth up to £350 per year, including discounts, perks and wellbeing support * 24/7 GP referral and wellbeing support service * 1 paid volunteer day * £2,000 refer-a-friend bonus after the referee passes probation * Opportunities for development and progression across Axis CLC Why Axis CLC Joining Axis CLC means being part of a national team delivering essential services across housing, education, healthcare, defence and commercial property. We value reliability, quality and social impact, and offer meaningful work with real opportunities to grow. Our Commitment to Inclusion Many faces, one Axis CLC. We value diversity and are proud to be an equal-opportunity employer. If you need any adjustments during the hiring process, please let us know
Reporting & Data Analyst in Stratford employer: Axis CLC
Axis CLC is an exceptional employer, offering a dynamic work environment where your contributions directly impact vital sectors such as healthcare and education. With a strong commitment to employee growth, we provide comprehensive training opportunities, competitive salaries, and a supportive culture that values diversity and inclusion. Located across the UK, our teams benefit from a collaborative atmosphere and unique perks like volunteer days and long-service awards, making Axis CLC a rewarding place to advance your career.
StudySmarter Expert Advice🤫
We think this is how you could land Reporting & Data Analyst in Stratford
✨Join Construction Networks
Get yourself involved in local construction networks or industry events. They often have job boards, and networking can lead to unadvertised positions. Plus, it’s a great way to meet potential future colleagues!
✨Show Off Your Skills on Site
If you’ve done any hands-on work, whether it's through internships or personal projects, make sure you can showcase it. Consider volunteering for local construction projects or getting involved in community build days; it’s a solid way to demonstrate your skills and build connections.
✨Utilise Construction Job Sites
Don't just rely on the big job boards. Look at niche construction job sites—many companies prioritise these for full-time roles. Apply through these sites, but don’t forget to reach out directly to companies you admire, like Axis CLC, to express your interest!
✨Tailor Your Application for Full-Time Roles
Make your application stand out by tailoring it specifically for full-time positions. Highlight how your previous projects align with the company's work. At StudySmarter, we encourage you to demonstrate your commitment and long-term interest in the industry when applying for roles like Reporting & Data Analyst at Axis CLC.
Some tips for your application 🫡
Showcase Your Relevant Experience:In the construction industry, it's essential to highlight any hands-on experience you have. Whether it’s past projects you've worked on or specific roles you've held, make sure your CV emphasises your practical skills and contributions to construction sites.
Include Certifications and Qualifications:Don’t forget to list any certifications relevant to construction, like CSCS cards or other safety qualifications. These can really set you apart from other candidates and show that you’re serious about health and safety on-site.
Tailor Your Cover Letter to Construction:When writing your cover letter for a construction role, focus on your problem-solving capabilities and teamwork. Construction relies heavily on collaboration, so mention how you’ve worked successfully with others to complete projects on time and within budget.
Adapt Your CV Format to the Field:Ensure your CV is clear and easy to read, with sections dedicated to skills such as project management, technical abilities, and site supervision. Construction roles often require a blend of technical know-how and soft skills, so make sure both are highlighted effectively.
How to prepare for a job interview at Axis CLC
✨Brush Up on Technical Knowledge
For a construction role, it's crucial we have a solid grasp of industry standards, safety protocols, and specific tools used on-site. Make sure you're familiar with relevant regulations and can talk confidently about them, as these often come up in interviews.
✨Showcase Your Projects
Since this is a full-time position, be ready to discuss any previous construction projects you've worked on. Bring a portfolio or have detailed descriptions that highlight your role, the challenges you faced, and how you overcame them—this’ll show you’re not just book-smart but also practically savvy.
✨Understand the Team Dynamics
Construction is all about teamwork, so prepare to discuss how you interact with different stakeholders like architects, engineers, and contractors. Maybe think of examples from past experiences to illustrate your ability to communicate and collaborate effectively.
✨Prepare for On-the-Spot Problem Solving
Be ready for some practical questions or scenarios where you'll need to demonstrate your problem-solving skills. Interviewers might present you with a hypothetical construction issue to solve, so practice articulating your thought process clearly and logically—this could really set you apart!
