Reporting Consultant – EXPIRED

Reporting Consultant

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 commercial lending, and specialist residential mortgage markets. The company is unique in that it is 79% owned by the Hodge Foundation, a charity established in 1962 that awards grants to registered charities and is funded by the profits from Hodge. The purpose of this role is to ensure that our customers are provided the high level of service which Hodge is known for and is a key element of our DNA and offering.

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

Key Responsibilities

• Develop, maintain and evolve the group report automation and data visualisation service.
• Implementing 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.

What we need from you:

• Educated to degree level or relevant professional experience
• Proven experience as a SQL/SSRS developer.
• Experience with MS BI technologies (MS Power BI/SSRS/SSIS/SSAS/SSMS)
• Background in data report design, development & automation.
• Experience in developing building data cubes for maximum report performance.
• Experience of working in an Agile environment.
• Experience of using DAX language to manipulate data.

• High level of proficiency in SQL, MS Excel and SSRS.
• Knowledge of Power BI development (data modelling, DAX, publishing and deployment).
• Analytical with the ability to understand and articulate complex situations.
• Self-motivated with the ability to prioritise work effectively to meet deadlines
• Excellent written and verbal communication skills
• Confident and effective communicator
• Impartial & inquisitive with strong attention to detail
• Strong interpersonal skills with ability to work independently and within a team
• Detail oriented and comfortable working with large data sets
• Strong MS Office skills

At Hodge we operate a hybrid working policy where our colleagues work at least 40% of their time in the office, anyone on a remote contract we require to come into the office once a month.

In return we offer:

• Based in Cardiff City Centre operating in a highly flexible Hybrid workspace.
• 28 days Holiday with the option to buy more.
• Private Medical & Health Insurance
• Company pension contribution up to 15%
• Subsidised Gym Membership.
• Extensive learning and development programme

• Generous, personalised benefits package
• 4 days on top of annual leave for community and charity work
• Flexible working options

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.