MI Analyst
Hiscox
Date: 2 days ago
City: York
Contract type: Full time
Job Type
Permanent
Build a brilliant future with Hiscox
The Data Analyst will play a crucial role in the MI team, focusing on writing complex SQL queries to interrogate both a conformed reporting database as well as raw source databases. This role is essential for providing accurate and timely data analysis to identify and support system and process defects, ensuring both the business and customers are well-supported.
Key Responsibilities
Permanent
Build a brilliant future with Hiscox
The Data Analyst will play a crucial role in the MI team, focusing on writing complex SQL queries to interrogate both a conformed reporting database as well as raw source databases. This role is essential for providing accurate and timely data analysis to identify and support system and process defects, ensuring both the business and customers are well-supported.
Key Responsibilities
- Develop and maintain complex SQL queries to extract and analyse data from various databases.
- Interrogate reporting databases and source databases to identify and impact assess system and process defects.
- Provide insights and data-driven recommendations to support process improvements.
- Compile daily, weekly, and monthly reports highlighting system and process defects for operational leaders.
- Develop accurate data models to aid in defect analysis and resolution.
- Identify and analyse trends and patterns in defects to help with business planning and risk mitigation.
- Work closely with IT and other business partners to design and provide reports from new systems.
- Develop strong relationships and work closely with teams across the business.
- Present findings to both technical and non-technical audiences, emphasising the impact of defects on business and customer support.
- Proficiency in writing complex SQL queries.
- Intermediate Excel knowledge (vlookup, sumifs, tables, pivot tables, etc.).
- Experience in creating reports and documents to support multiple people/processes.
- A passion for building a career in data.
- Willingness and ability to learn technical disciplines in both traditional and practical settings.
- Experience with data visualization tools such as Power BI.
- Knowledge of database management and data warehousing concepts.
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Digital Content Executive
Portakabin,
York
£30,000
-
£36,000
per year
21 hours ago
Role: Digital Content ExecutiveSalary: £30,000 - £36,000Location: York We are seeking a Digital Content Executive to join our skilled marketing team in York. The Digital Content Executive is responsible for planning, creating, and managing high-quality, engaging content across digital platforms, including social media, websites, and third-party channels. This role ensures brand consistency and messaging alignment across all touchpoints, contributing directly...
Chef De Partie
Frasers Hospitality,
York
2 days ago
Job title: Chef de Partie, MalmaisonContract TypeRate of pay / Hours:Location: Excellent Rates of Pay, Service Charge and Great Company Benefits.Why not get paid for doing what you love, get loads of perks and benefits, learn something new and make a career for Life with MalmaisonMalmaison is looking for Chef De Parties with Immediate Starts available.Get a taste for our...
Retail Store Manager | Smiggle |York Outlet - NEW OPENING!
Smiggle UK & ROI,
York
4 weeks ago
Store Manager | York Outlet - NEW OPENING | Competitive Salary + BenefitsReady to lead, inspire, and ignite creativity?Join us at our York Outlet Smiggle Store as a Store Manager! Maximise store performance, boost sales, and lead your team in a fast-paced, hands-on environment; all while playing with the products - approaching every day with an attitude of fun!Store Manager...
