Management Reporting Analyst (FTC) at Resource Solutions

• Resource Solutions is seeking an MR (Management Reporting) Analyst (Fixed Term Contract) who will be aligned with a number of clients and will support those accounts with the timely delivery of a reporting suite including regular reporting, data analysis, performance tools, and other meaningful insights to support the performance and service delivery of our client accounts.
• The analyst will also assist in the validation and regular extraction, transformation, and loading of all incoming data, including both internal originating and external third-party recruitment data from clients or market data providers.

What you will be doing:

• Responsible for building and maintaining tools, reporting, and dashboards in both Excel and Power BI, which are in line with design and development standards, that are accurate, effective, and understood by the business.
• Maintain and monitor a multiple client reporting schedule across various clients to ensure timely and regular provision to deadlines.
• Extract, validate, and cleanse source data from core recruitment systems and deliver agreed reporting in the form of PBI/Excel dashboards to the relevant stakeholders.
• Produce weekly and monthly system reconciliation reports and drive data integrity and continuous improvement to promote a lean methodology with robust data insights.
• Identify data integrity concerns and offer remedial actions and realistic solutions to drive data quality in client recruitment systems. This will require regular communication with recruiters, administrators and coordinators responsible for system inputs and establishing positive working relationships at all levels across the accounts.
• Work under the guidance of the EMEA Business Partners to provide both proactive and requested reporting and analysis to generate insight for business reviews, governance and delivery against SLAs and KPIs.
• Conduct analytical reviews of our client recruitment data to identify any trends, business opportunities or insights for the account teams and client and provide direction on how to work towards Data Informed decisions.
• Provide information statistics around site specific financial data, to include pricing and recruitment costs / savings.
• Respond to ad-hoc and change requests that originate from either onsite account management, the client or EMEA Business Partners.
• Use reports and exploratory analysis to identify potentially problematic data, make corrections, and eliminate root causes for a range of complex data problems i.e. input errors or inadequate field edits, and recommend possible solutions.

Are you who we are looking for?

• Working knowledge of Microsoft’s business intelligence platform Power BI, including Power Query.
• Highly proficient with Microsoft Office, particularly Excel, with the ability to understand and apply formulas (nested, logical and conditional), nested statements (Boolean logic)
• Data transformation & Data Modelling using Power Query and a good understanding of VBA would be advantageous.
• A confident and professional attitude with excellent written and verbal communication.
• Problem-solving and organisational skills, having the ability to work to multiple deadlines and deliverables.
• Well organised, with excellent time management and prioritization skills and the ability to with some autonomy.
• A passion for analytics and data, demonstratable through staying up to date with the latest technology and trends in the field.
• An excellent team player who is willing to contribute and work in a collaborative team. Must be people orientated.
• Strong analysis skills with the ability to translate data into a business story with an appreciation for the target audience.
• Good attention to detail and placing a high value on data integrity, information governance, and adherence to process.
• Interested in business issues and commercially aware, able to interpret commercials, and understand contracts and SLAs.
• Experience of working in a client/customer and service delivery-focused environment is highly desirable.

Experience:

• Previous experience working in an MI/analytics, business reporting, client-focused environment
• Interpreting & Analysing SLA's, KPI's, OLA's, with excellent relationship-building experience.
• Design, Implementation, and deployment of performance metrics insights that assist in key business decision making
• Proficiency in dynamic dashboard report builds in both Excel and Power BI
• Uilising Power query to shape, transform, and model data for further analysis
• An understanding of data warehousing and data modeling concepts.
• An understanding of ATS/VMS/CRM platforms and how the front-end configuration and data flow work is desirable.