MI Data Analyst

As a MI Data Analyst, you will be joining a project supporting the motor finance compensation scheme. This is an exciting opportunity to join a project at its infancy and contribute to the set up and ongoing development of MI data analytics though out the project lifecycle.

What you’ll be doing:

• Producing and maintaining regular operational, client and management reporting.
• Developing dashboards and visualisations in Power BI and other reporting tools.
• Gathering, validating and analysing data from multiple source systems.
• Investigating data quality issues and working with operational teams to resolve them.
• Performing trend, root cause and performance analysis to identify risks, opportunities and operational improvements.
• Supporting regulatory, client and internal reporting requirements.
• Working with stakeholders to understand reporting requirements and translate them into actionable MI solutions.
• Automating manual reporting processes where possible.
• Documenting KPI definitions, reporting logic and data processes.
• Supporting ad hoc data requests and business analysis activities.
• Supporting cloud-based reporting and data platforms hosted within Azure.
• Working with Azure Data Factory (ADF) pipelines for data ingestion, transformation and monitoring.
• Monitoring data interfaces and investigating failed loads, file transfers or data quality exceptions.
• Working with Azure Storage Accounts and file-based ingestion processes.
• Supporting data engineering and reporting teams with data pipeline development and platform enhancements

We are looking for a detailed MI Data Analyst with experience working within financial product consumer complaints., * 4 + Years’ working within Data Analytics ideally within financial services consumer complaints.

• 4 + years’ experience with SQL, writing procedures, designing tables and views.
• 4 + years’ experience with Excel
• Managing and troubleshooting data transfers via SFTP, APIs and other secure integration methods.