Apply for this job now

Business Intelligence Developer

Liverpool, Merseyside
Remote Working
Remote Working
Job Type
21 Jul 2022
Do you have previous experience in a financial or data analysis role?The purpose of Business Intelligence Developer is to lead in the preparation and development of key business intelligence to enable efficient, effective and commercially focussed performance reporting within the business. The role will also ensure the data requirements of claims processing activity are met to ensure the business submits its claims in a timely and efficient manner.Location: Liverpool (home based with monthly visits to office)Salary: £27k - £35k per annum The Business Intelligence Developer is responsible for researching reporting requirements for a variety of stakeholders for current and newly awarded contracts, including designing robust to ensure the accuracy of the data presented.The role will work closely with other departments to ensure business reporting requirements are delivered in an efficient and cost-effective manner and will ensure usage of the BI tool is maximised.Business Intelligence Developer - Key Responsibilities:The ongoing production of daily, weekly, periodic and annual performance analysis as required including, but not limited to;
  1. Contract KPI analysis
  2. Customer contract reporting
  3. Volume reporting on key metrics at CPA, provider and branch level
  4. Conversion rate and sustainment reporting
  5. Caseload analysis
  6. Monetary Flash reporting
  7. PRaP accuracy and efficiency reporting
  • To oversee the preparation of the company s daily Flash reports, ensuring the data is both accurate and complete and pre-empting future changes as business needs evolve
  • Implement newly awarded contracts working with key stakeholders across the business
  • Use SQL and Power BI to create dashboard MI
  • The development of BI tool generated reports to facilitate ad-hoc reporting requests
  • To provide daily BI as required to support PRaP processing, claims reconciliation and subcontractor claims analysis
  • The preparation of commercially focussed KPI analysis for senior Operational managers, BI Manager and Head of BI to drive performance improvement
  • To research the internal and external reporting requirements of existing and newly awarded contracts by proactively determining the information needs of key stakeholders including Operations and Supply Chain Management.
  • To design and develop, accurate, timely and user-friendly Business Intelligence, ensuring robust controls are in place to ensure the accuracy of the data published
  • To ensure reporting processes and procedures are fully documented and constantly reviewed in line with changing business and customer requirements
  • To provide input from a finance perspective into future developments of the BI Tool and other MI reporting tools used in the business including writing business cases specifications for new reporting requirements
  • Develop and maintain strong professional working relationships with Operations colleagues by maintaining an approachable presence
Other duties
  • Perform data manipulation and transformation in Power BI
  • Understand and use code within Power BI
  • To provide cover for other roles in the Business Intelligence Team in times of annual leave / absence or workload fluctuations
  • The assist in the daily preparation of the Performance Flash and other ad-hoc reports as required
  • Ongoing development and maintenance of the processes utilising the iMacros software
  • To coach operational and commercial management in understanding the data presented to aid performance improvement
Essential skills & experience
  • Previous experience in a financial or data analysis role
  • Demonstrable advanced Visual Basic skills
  • Demonstrable advanced excel spreadsheet skills with pivots, macros and look-ups
  • Previous experience of using Business Intelligence / Data warehousing products
  • Demonstrable advanced analytical skills with the ability to produce accurate, interactive and user friendly Business Intelligence for varying levels in the organisation
  • Demonstrable experience in dealing with high volumes of data with excellent attention to detail
  • Experience of developing informative Business Intelligence that meets the needs of its target audience
  • Ability to present complex Business Intelligence to all levels in the organisation
  • Ability to quickly understand and follow complex systems and procedures
  • A proactive and flexible, can do attitude
  • Be able to work under pressure and work to strict reporting deadlines
Desirable Criteria
  • Able to understand and process changing requirements in a fast-moving environment
  • Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership
  • Experience of training staff on how to interpret financial or performance reporting
Disability Confident CommitmentWe aim to ensure that no candidate or employee receives less favourable treatment on the grounds of gender, race, disability, sexual orientation, religion or belief, age, gender reassignment, marital or civil partnership status, pregnancy or maternity. We offer an interview to disabled candidates who meet the minimum criteria
Apply for this job now


  • Job Reference: 663269257-2
  • Date Posted: 21 July 2022
  • Recruiter: Reed In Partnership
    Reed In Partnership
  • Location: Liverpool, Merseyside
  • Remote Working: Some remote working possible
  • Salary: On Application
  • Sector: I.T. & Communications
  • Job Type: Permanent