Reporting Analyst

Are you a problem-solving Reporting Analyst looking for a new opportunity?

If you are open to a new opportunity and would like the chance to work within an organisation which can offer competitive benefits and career progression, then this is the role for you.

We are currently recruiting for a Reporting Analyst to join our dynamic, growing team in Uxbridge.

The Reporting analyst will be involved in the entire reporting development life cycle from the capture of requirements to the subsequent development, testing and delivery.

They will also be responsible for producing both periodic and ad-hoc reports for both internal and external clients in a timely and accurate manner.

They will be required to contribute to the automation of periodic reporting and to produce and maintain detailed process documentation and report specifications.

The areas of work will include (but not be limited to): Working with complex Excel spread sheets, development of STAR schema, ETL process, SSRS reports, cubes, T-SQL code (DDL and DML), requirement documents, report specifications and procedure/process documentation,ownership of standard reports, to improve the speed and efficiency of the reporting process and to continuously improve the controls around them.

**As a Reporting Analyst, your key responsibilities will include**:

- Production and publishing of periodic external and internal reporting packs and ad hoc projects
- Ensuring timely and accurate delivery of all reports
- Preparation and submission of regulatory reports
- Field ad-hoc report requests and data enquiries
- Gather and document reporting requirements from the business
- Documentation of internal production procedures
- Production of detailed report specifications
- Utilising advanced knowledge of Excel
- Development and amendment of reports using SSRS and SQL Server
- Development and maintenance of the data warehouse & ETL environment
- Continually automating and improving processes
- Work effectively in virtual, interdisciplinary teams
- Proactively and intelligently manage stakeholders at all levels
- Mentor and develop more junior staff within the team
- Establishing and maintaining appropriate internal control safeguards
- Interact with other managers to provide project management expertise

**Benefits**

Private Medical Insurance | Salary Sacrifice Pension matched up to 8% | 25 days holiday with Length of Service | Buy & Sell Holiday up to 5 days per year | Season Ticket Loan | Cycle to Work Scheme | EAP | Enhanced Maternity & Paternity | Wellbeing Days| Volunteering Days | Eye Care | Payroll Giving | Reward & Recognition Program | Relaxed Dress Code | Discounted RAC Vehicle Breakdown | Discounted Gym Membership | Life Assurance

**Additional Information**
- analyses problems, thinks creatively, and makes effective decisions
- has a thorough understanding of the analysis process and can collaborate with interdisciplinary teams and stakeholders to achieve consensus.
- strategic thinker with the ability to turn ill-defined opportunities and problems into clear strategic paths
- strong core in SQL database technology and surrounding complimentary systems with an advanced level of knowledge in Excel
- seeks opportunities for collaborating and sharing best practice to maximise the commercial potential
- contributes positively through clear communication personal impact and behavioural flexibility
- excellent analytical and abstract reasoning skills, plus excellent organisation skills
- is able to create a positive climate and influence others to get things done
- demonstrates leadership ability, team management, and interpersonal skills
- applies data analysis techniques, based upon a detailed understanding of business processes
- Independently validates information and specifies and applies appropriate analytical techniques to report results to users
- Assesses the integrity of data from various sources and applies a variety of analytical and presentational techniques

**Desirable Skills** In addition:

- Has a robust understanding of regulation and associated legislative policy and the impacts these have on the business
- Has a full appreciation and fully adheres of the company policies, procedures, and standards for this role.

**About Company** As one of the most successful third-party loan servicing companies in the UK, with just over £18 billion of assets under management, our experienced teams have the expertise to manage loan portfolios across a range of asset classes. Whether it's full end-to-endservicing through the complete lifecycle of loans or support with one element, we can help. Some of the services we can provide include Primary Servicing, Special Servicing, Master Servicing, Standby Servicing, and Asset Management. Standard & Poors GlobalRatings ranks us as one of the highest rated primary and special servicers of residential mortgages in the UK, and Mortgage Finance Gazette named us 'Best Loan Servicer 2021'.