Data Analyst / Report Analyst
Our client, based in South London / Surrey has an exciting permanent role for a Data Analyst / Report Writer.
The reporting analyst will meet our clients complex reporting requirements in excel, Power BI and other reporting platforms. You will be part of a business crucial team aiding users and colleagues with day-to-day support tasks as well as project related work.
The role will include;
- creating reports requested by clients and consultants in excel and Power BI from SQL databases
- Providing support to existing clients, working with them to enhance and update existing reports
- liaise with clients and consultants to identify and fully understand reporting requirements.
- checking data maps correctly from data imports and exports and validate
- ensuring any new reports are tested and checked for compatibilitythe relevant software versions before issuing
- managing version controls for standard reports
- assisting with the maintain of complex appraisal spreadsheets
- assisting with system releases, including testing and documentation as required providing support to our clients and colleagues
Responsibilities
Report Writing
- Collaborate with clients and consultants to identify and fully understand reporting requirements.
- Create reports requested by clients and consultants in Excel and from SQL databases.
- Support existing clients, working with them to enhance and update their reports.
- Periodic validation of data imports and exports.
- Testing new reports and checking for compatibility with the relevant software versions before release.
- Maintaining a robust version control framework consistently for standard reports.
- Assist with the maintenance of the main financial model.
- Assist with system releases, including testing and documentation as required providing support to our clients and colleagues.
- Respond to client report requests, agreeing and understanding the brief.
- Identify improvements and changes to data structures and log them in the user request system Monday.com.
- Maintaining the standard suite of reports issued with the software.
Support
- provide support to our clients, technical team and answer client queries.
- assist in testing new releases.
Skills/Experience
Essential
Experience and advanced knowledge of Microsoft Excel for:
- Complex formulae
- Pivot tables
- Linking to SQL Databases via ODBC
- Macros maintained and created directly in VBA.
- User-friendly solutions
Experience and detailed knowledge of querying SQL databases
Self-motivated, proactive, and naturally curious.
Analytical problem solver.
Ability to work under pressure, independently and organise work efficiently, understanding and delivering to competing demands.
Desirable
Experience in using Power BI to create reports.
Educated to degree level.
Experience in social housing finance or development.
Experience in SQL server, database design and administration.