MI Analyst at Resource Solutions

The analyst will be aligned to a number of clients and will support those accounts with the timely delivery of an MI 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.

Key Responsibilities

Analytics

• Building and maintaining tools, reporting and dashboards in both Excel and Power BI, which are in line with design and development standards
• Provide both proactive and requested reporting and analysis to provide insight for business reviews, governance and delivery against SLAs and KPIs
• Maintain and monitor reporting products delivered to account teams, the client and Resource Solutions
• Extract, validate and cleanse data from source systems and produce/deliver agreed reporting and dashboards to relevant stakeholders
• Produce weekly/monthly system reconciliation reports and data integrity toolkits/scorecards to promote data quality as well as enhancements to metric updates
• Drive remedial action and continuous improvement of data quality in client recruitment systems by maintaining regular communication with recruiters, administrators and coordinators
• Conduct analytical reviews of our client recruitment data to identify any trends, business opportunities or insights for the account teams and client and provide commentary and context as outputs
• Contribute to benchmark reporting across the global client base by working closely with other Analysts and the MI Consultants
• Provide information statistics around site specific financial data, to include pricing and recruitment costs/savings
• Respond to ad-hoc and change requests and update the change and ad-hoc request tracker to monitor time and cost spent on such activities
• Provision of account analysis and account reconciliation information to Financial Administrators that relates to billing activities of Resource Solutions
• Use reports and exploratory analysis to identify potentially problematic data, make corrections, and eliminate root cause for a range of complex data problems
• Maintenance and production of current BAU reporting schedules

Skills and Experience:

Skills

• Working knowledge of Microsoft's business intelligence platform Power BI
• High proficient with Microsoft Office, particularly Excel, with the ability to understand and apply formulas (nested, logical and conditional), nested statement (boo lean logic)
• Data transformation & Data Modelling using Power Query
• A confident and professional attitude to written and verbal communication
• Problem-solving and organisational skills, having the ability to work to multiple deadlines and deliverables
• Well organised, with the ability to prioritise workload 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 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, understand contracts and SLAs
• Experience of working in a client/customer and service delivery focused environment highly desirable

Experience

• Previous experience working in an MI/analytics, business reporting, client-focused environment
• Interpreting & Analysing SLA's, KPI's, OLA's
• Design, Implementation and deployment of performance metrics insights that led to key business decision making
• Proficiency in dynamic dashboard report builds in Excel and Power BI
• Utilising Power query to shape, transform and model data for further analysis
• An understanding of data warehousing and data modeling concepts
• A degree in IT, Computer or Information Science or a Business discipline is preferable
• An understanding of ATS/VMS/CRM platforms and how the front-end configuration and data flows work is desirable