Arun Phogat
Newcastle upon Tyne,Tyne and Wear
Summary
Accomplished data professional with expertise across SQL (SQL Server, Oracle, SAS), Qlik Sense (Certified Data Architect), Power BI, Python, and modern cloud architecture including Microsoft Azure, Fabric, and Databricks. Experienced in building automated data pipelines, designing scalable dashboards, and delivering operational, HR, and pricing insights that strengthen performance and decision-making. Strong background in ETL workflows, data modelling, forecasting, performance MI, and root cause analytics. Adept at insight storytelling, cross-functional collaboration, and leading automation initiatives that enhance data quality and reporting efficiency. Committed to driving high-impact analytical solutions that enable strategic clarity and measurable business improvement.
Overview
9
9
years of professional experience
Work history
Pricing Data Analyst
RSA Insurance Group
Hybrid
05.2025 - 12.2025
- Review pricing performance processes to identify opportunities for enhanced analytics, automated insight generation, and workflow optimisation.
- Design and deliver interim analytical and reporting solutions aligned with the transition to EDP and future-state reporting tools.
- Automate previously manual pricing performance reporting, enabling scalable and consistent insight delivery across pricing teams.
- Streamline data workflows to reduce development time for pricing insight reports, accelerating delivery of robust analytics to stakeholders.
- Evaluate and recommend tooling, data processes, and analytical approaches that support long-term pricing strategy and operational performance.
People Data & Insight Analyst (Lead Analyst)
RSA Insurance Group
Hybrid
09.2024 - 05.2025
- Led the transformation of legacy HR reporting by replacing manual, multi-system processes with an automated end-to-end interim reporting solution can be easily aligned to future new HR system.
- Developed scalable data workflows and dashboards that improved reporting accuracy, reduced turnaround times, and strengthened workforce insight delivery.
- Collaborated with HR and technology teams to ensure compatibility with future systems.
- Supported & coached peers on automation techniques and analytical methods to elevate team capabilities.
Data & Insight Analyst (Operations)
RSA Insurance Group
10.2022 - 09.2024
- Developed and implemented end-to-end automated operational dashboards using Qlik Sense for Commercial & Personal lines, improving data visibility.
- Delivered automated Mid-Market reporting via SQL, Qlik Sense, and CRM, increasing SLA achievement from low 50s to high 80s.
- Conducted comprehensive root cause analysis to identify performance inhibitors and generate actionable recommendations.
- Analysed operational datasets to uncover new insight opportunities, enhancing long-term efficiency and performance.
- Served as key data subject matter expert, collaborating with stakeholders to enhance data accessibility and quality.
- Facilitated agile delivery cycles by providing timely insights aligned with business objectives.
Customer Manager
RSA Group: More Than Home
Sunderland
04.2022 - 10.2022
- Driving better customer experience, seeking first contact resolutions where possible, navigating customer interactions in a friendly, empathetic, efficient manner.
- Dealing with inbound interactions with clients with your underwriting license and operational service agreements.
- Contributing to creating a culture of performance and pace within your team, focused on improving customer experience and delivering financial results.
Manager
Mac Repair Newcastle
Newcastle upon Tyne
07.2021 - 04.2022
- Consistently surpassed productivity targets by enhancing individual and team performance.
- Communicated daily expectations to high-volume teams, motivating to achieve key performance indicators.
- Assessed employee performance through monitoring and development, boosting sales and customer service.
- Analysed existing practices to identify opportunities for growth in performance and profit.
Assistant Manager / IT Technician
Mac Repair Newcastle
Newcastle upon Tyne
11.2019 - 07.2021
- Supported management in implementing strategies that enhanced profit growth and brand reputation.
- Resolved customer issues promptly, ensuring satisfaction and professional communication.
- Conducted trend analysis to anticipate seasonal demands and align with customer needs.
Cultural Secretary
Delhi University Student’s Union
New Delhi, Delhi
10.2016 - 05.2017
- Established partnerships with relevant organisations to enhance support for critical issues.
- Educated young individuals on strategies for engaging in discussions promoting social change.
- Organised Union meetings, developed Student Welfare agendas, and distributed minutes to improve communication transparency.
Education
Masters - Information Science (Data Analytics)
Northumbria University
01.2019 - 1 2021
Bachelor of Science - Physics (Hons.)
University of Delhi
New Delhi 01.2016 - 1 2019
A-Levels - Non-Medical
R.E.D Senior Secondary School
Jhajjar 01.2014 - 1 2016
Skills
Technical & Data Tools
- SQL (SQL Server, Oracle, SAS)
- Qlik Sense (Certified Data Architect)
- Power BI
- Python
- Microsoft Azure & Fabric infrastructure
- Databricks infrastructure
- CRM systems
- Data modelling & ETL fundamentals
Analytics & Methods
- Operational data analysis
- Performance MI & reporting automation
- Trend forecasting
- Root cause analysis
- Statistical insight generation
Professional Skills
- Data storytelling & presentation
- Cross-functional collaboration
- Problem solving & critical thinking
- Agile delivery & project management
- Adaptability & stakeholder engagement
Timeline
Pricing Data Analyst
RSA Insurance Group
05.2025 - 12.2025
People Data & Insight Analyst (Lead Analyst)
RSA Insurance Group
09.2024 - 05.2025
Data & Insight Analyst (Operations)
RSA Insurance Group
10.2022 - 09.2024
Customer Manager
RSA Group: More Than Home
04.2022 - 10.2022
Manager
Mac Repair Newcastle
07.2021 - 04.2022
Assistant Manager / IT Technician
Mac Repair Newcastle
11.2019 - 07.2021
Masters - Information Science (Data Analytics)
Northumbria University
01.2019 - 1 2021
Cultural Secretary
Delhi University Student’s Union
10.2016 - 05.2017
Bachelor of Science - Physics (Hons.)
University of Delhi
01.2016 - 1 2019
A-Levels - Non-Medical
R.E.D Senior Secondary School
01.2014 - 1 2016