Do you want to be part of a force for good, helping to make life better for customers & society in the moments that matter? At Hodge, we put people at the heart of our business and that means our customers, colleagues and communities. Hodge is a Welsh financial service provider that focus on real estate finance, and specialist residential mortgage markets.

The BI Reporting Consultant will support the implementation of the Data Strategy, ensuring a world class Data and Insight department to support the data needs of Hodge Stakeholders. It’s a pivotal role in ensuring data becomes a key part of the Hodge Fabric.

Essential Experience

  • Educated to degree level or relevant professional experience
  • Proven experience and a high level of proficiency in developing SQL/SSRS
  • Experience of working with Microsoft (MS) BI technologies (MS Power BI/SSRS/SSIS/SSAS/SSMS)
  • Previous experience in data reporting, design, development & automation
  • Experience in developing building data cubes for maximum report performance
  • Experience of using DAX language to manipulate data
  • Demonstrable knowledge of Power BI development (data modelling, DAX, publishing and deployment)

Key responsibilities will include:

  • Develop, maintain and evolve the group report automation and data visualisation service.
  • Implement best practice development and controls for our suite of automated reports and data extracts.
  • Provide expertise in using and developing SSRS data outputs and Power BI reports.
  • Understand the structure and content of the organisation’s data.
  • Translate business reporting requirements into reporting specifications.
  • Design, build and deploy SSRS and Power BI reporting solutions.
  • Conduct testing and troubleshooting.
  • Evaluate and improve existing BI systems.
  • Develop and update appropriate technical documentation.

BI Service:

  • Develop relationships with internal customers and be confident in working with stakeholders across the company.
  • Deliver first class customer service and promote the BI service.
  • Provide data analysis expertise and support on an ad-hoc basis.

General:

  • Comply with all company policies and procedures and legislative and regulatory requirements, including, but not exhaustively, those related to GDPR, Money Laundering, Health & Safety, PRA/FCA regulations, employment, and other legislative requirements (as applicable).
  • Undertake any other reasonable tasks as and when requested by senior management.
  • Develop and maintain an up-to-date knowledge of Compliance & Risk regulatory and legislative information related to products/services (e.g. PRA/FCA rules, Data Protection, Money Laundering, etc.), as advised by line management.
  • Support the risk culture of the organisation by taking personal responsibility for identifying and managing risks.

 

Please be aware that should we pursue your application, all our Financial Services employees will be expected to complete background checks to assess suitability for employment, these include; a criminal record, identity, sanctions, adverse finance, fraud prevention and reference checks to comply with our regulatory requirements.

Hodge is an advocate of being an equal opportunities employer, We believe in promoting equality and diversity which is central to our lives today. We welcome applications from all sections of the community and recognises the value a diverse workforce brings to an organisation.

ESG and sustainability are at the heart of everything we do and serves as a reminder of the responsibility we have to our stakeholders, customers, colleagues and the communities we operate in to use our position wisely. We’re currently exploring different certifications available and have done an initial review of how we think we’d fare, as we see this as a real opportunity for Hodge given our social purpose.

Apply today to become part of Hodge’s mission to make life better for customers and society in the moments that matter.

Latest Jobs

Closing date

03 Aug 2025

Salary

Competitive

Contract

Full Time

Hours

35

Apply now