MI Analyst

MI Analyst / Brighton / Finance / Excel

Client Details

A well respected organisation based in the Brighton area are seeking a MI Analyst on a permanent basis.

Description

As MI Analyst you will be responsible for:

• Maintaining existing suite of reports using SSIS, SSRS and SQL, making amends, updates & additions based on stakeholder requirements
• Creating new reports from existing data within the database, joining multiple tables and/or data sources, publishing these reports using SSRS to the reporting self-service portal
• Integrating new data into existing data tables from external sources such as new telephony platforms, newly implemented QA tools and/or email clients
• Automating extraction, transfer & loading processes, pulling data from multiple sources into the MI database
• Troubleshooting errors and investigating MI inaccuracies, validating data and reconciling data sets
• Working with IT to deliver the migration of the existing MI database onto a new server hosted externally, ensuring no loss of service to the business through rigorous UAT testing
• Using SQL to extract raw data from the database, joining multiple tables from which to deep dive into the data, visualise the data and create ad hoc reporting

Profile

• Proven track record in carrying out detailed data analysis and MI reporting in a customer facing commercial environment, with a strong focus on customer insight
• SQL / T-SQL / SSIS - Advanced, essential
• Excel/Access/VBA - Advanced, essential
• Tableau (or other BI Tools) - advantageous
• Able to disseminate large amounts of information to provide clear and commercially sound recommendations to managers.
• Highly numerical
• Excellent interpersonal, communication and influencing skills are required with emphasis on achieving results and successful outcomes
• Strong stakeholder management knowledge, with the ability to build and strengthen relationships within the business and externally at all levels

Job Offer

£34,000 - £38,000 DOE + benefits