Do you have experience of creating reports using MI data?
Do you have excellent Excel knowledge and the ability to do pivot tables and v-look up?The Opportunity
This is a once in a career opportunity for an exceptional data & information specialist to join our rapidly expanding Client Experience Team at an industry leading EAP and OH provider. With an unrivalled track record of incredibly strong year on year growth of its subscription model business, the business supports over 100,000 organisations and 15 million lives across the UK & Ireland. Part of a global group, with 14 operating companies and a group turnover of circa £500m, there is substantial financial backing for further expansion, including acquisition and international development. This represents an unparalleled career advancement opportunity for the exceptional individual.
The Role
MI Coordinators produce reports for clients on a weekly, monthly and quarterly basis to show clients, employee engagement with the service, return on investment and the impact to their business. This is an integral role to keeping clients informed, creating a positive client experience, helping with retention and contract renewal. You will have experience of reading and understanding MI data, creating reports, excellent Excel skills - V-Look up, Pivot tables etc. and the ability to work in a fast paced environment and use your own initiative to streamline reporting, build automation and developing efficient ways of working.
day to day responsibilities
Preparation of monthly and quarterly client reports, ensuring SLAs of 5, 10 and 15 working days have been adhered to.
Preparation of bespoke client reports as required, such as, benchmarking, utilisation reports and relationship management reports.
Work with the Senior Planning and Reporting Manager to identify and articulate key opportunities for analytics driven improvement across the business.
Building, testing, and implementing new reporting systems, to better support management and the wider business to enable them to make sound business decisions.
Providing operational analysis, reports, and recommendations to the business with a purpose to optimise operational resources against demand in all areas across the business.
Identifying opportunities for process improvement to increase automation and reduce the risk of human error.
Monitor and audit data quality, ensuring the correct tasks are set within the CRM.
Support and answer queries in the MI mailbox within SLA.
What you bring to the team
Microsoft Office software experience including a high standard of Excel including reporting creation, VLOOKUPs and pivot tables, Word and Powerpoint.
Customer service focused: committed to providing exceptional service across all channels - written, and face to face wheren appropriate.
Attention to detail: excellent attention to detail and written skills when communicating with others, both internally and externally
Teamwork: willingness to assist and support others as required across various departments.
Excellent attention to detail, problem analys
Experience of creating dashboards, graph and alternative visualtion reports.
Benefits
25 days' holiday, plus bank holidays
Day off on your birthday
Cash plan for you (and your children, if any)
Holidays increase after 2-and 5- years' service
Contractual sick pay
Private medical insurance after 5 years' service
Pension Plan and Life Insurance
Pension plan contributions increase after 5- and 7-years' service
Holiday season bonus after 3 years' service
Profit share scheme
Season ticket loan scheme
Cycle to work scheme
Access to Employee Assistance Programme
Company incentives, access to discount schemes
Social sessions on the last Friday of the month with free food and drink - we call this Fab Friday!
Free 24/7 onsite gym
INDMANJ
51046LF
Portfolio Payroll Ltd is acting as an Employment Agency in relation to this vacancy