Data Analyst / Report Analyst

Endeavour Recruitment Solutions; Greater London; On-site; GBP 35,000 - 50,000; Full time

Job summary

A leading company in South London seeks a Data Analyst / Report Writer to generate and enhance reports using Excel and Power BI. The role demands advanced technical skills in data handling and client collaboration, with a focus on delivering high-quality support and project work.

Qualifications

• Self-motivated, proactive, and able to work under pressure.
• Experience in social housing finance or development preferred.

Responsibilities

• Creating and maintaining reports in Excel and Power BI.
• Providing technical support to clients and internal teams.
• Testing new reports for compatibility.

Skills

Advanced Excel

SQL querying

Power BI

VBA

Analytical problem solving

Education

Degree-level education

Job description

Our client, based in South London / Surrey, has an exciting permanent role for a Data Analyst / Report Writer.

The reporting analyst will meet our client's complex reporting requirements using Excel, Power BI, and other reporting platforms. You will be part of a crucial business team, assisting users and colleagues with daily support tasks as well as project-related work.

The role will include:

1. Creating reports requested by clients and consultants in Excel and Power BI from SQL databases.
2. Providing support to existing clients, working with them to enhance and update reports.
3. Liaising with clients and consultants to identify and understand reporting requirements.
4. Checking data maps for accuracy during data imports and exports, and validating data.
5. Testing new reports for compatibility with software versions before release.
6. Assisting with the maintenance of complex appraisal spreadsheets.
7. Supporting system releases, including testing and documentation, providing support to clients and colleagues.

Responsibilities

Report Writing

1. Collaborate with clients and consultants to understand reporting needs.
2. Create reports in Excel and from SQL databases.
3. Support and enhance existing reports for clients.
4. Validate data imports and exports periodically.
5. Test reports for compatibility before release.
6. Maintain version control for reports.
7. Assist in maintaining the main financial model.
8. Support system releases, including testing and documentation.
9. Respond to report requests, understanding client briefs.
10. Log improvements and changes in data structures using Monday.com.
11. Maintain the standard suite of reports.

Support

1. Provide technical support to clients and internal teams.
2. Assist in testing new software releases.

Skills/Experience

Advanced knowledge of Microsoft Excel, including:

• Complex formulas
• Connecting to SQL databases via ODBC
• Creating and maintaining macros in VBA
• Developing user-friendly solutions

Experience with querying SQL databases, Power BI report creation, and SQL server management is required. The candidate should be self-motivated, proactive, curious, an analytical problem solver, and able to work under pressure both independently and as part of a team. A degree-level education is required, along with experience in social housing finance or development.