Learn Data Skills
Beta
Sophie Scott

Sophie Scott

Data Analyst

Inigo Insurance

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Insights curator, carefully selecting and presenting the most valuable knowledge.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Inigo | Apr 2023 - Present

MI & Data Analyst

I produce the MI for the full Insurance Underwriting team at Inigo, working for the two heads of pricing across both first and third party teams. Using and merging both internal and external datasets, I work closely with the actuaries to bring to life their pricing model information, and with the underwriters to enable them to make better pricing decisions. I work closely with the claims team to match publicly available claims datasets with our current policy data to help track claim progress, as well as look at actual vs expected frequencies and severities across the classes of business. I have modelled different attachment point scenarios, as well as portfolio adequacy, the insights of which help the underwriters to spot the most profitable accounts to work on, as well as to drop insufficient industries or other points of analysis.
Show More

La Fosse Associates | Mar 2021 - Apr 2023

Data Analyst

As the Company’s only full-time Data Analyst, I moved La Fosse from a manual Excel reporting model to a Power BI reporting suite and created a robust, real-time semantic layer using SQL (SSMS views), with numerous dashboards for each function in the business. Stakeholder reports were provided through Power BI, giving senior management real-time visibility of the business. Recruitment managers had access to sales funnel tracking, sales forecasting including conversion analysis, amongst plenty of other trackers. This vastly improved access to data entirely shifted the business to data-led decision making. My wider role at La Fosse encompassed all aspects of user interaction analysis, technical data-build, as well as on-going discussions with Commercial Business Partners to manage dashboard requirements and to discuss the most effective business analysis. I tracked all the consultant incentives, and worked with the CRM team to make sure that all decisions are made with reporting in mind. I worked tirelessly to define business logic and have built data glossaries and assisted with defining and simplifying logic. I am also responsible for producing the weekly Board Report which is shared directly with the CEO and Founder.

SAS (Self Employed) | Jun 2017 - Jan 2022

Business Owner

I am the Founder and Director of SAS, an innovative fashion brand that had an annual turnover above £50,000 every year since founding and a 34% repeat customer rate. SAS filled a key gap in the market, offering consumers custom-made ethical fashion. I ran every aspect of this business, from marketing and photography to designing patterns, to accounting and liaising with the manufacturer.

S4labour | Jun 2019 - Mar 2021

Data Analyst

As a Data Analyst at S4labour (a hospitality software company), I taught myself SQL and Power BI and used the tools to extract and interpret market trends. I developed S4labour’s external reporting system through their customer database using SQL views - this reporting system kick-started the development of a new data subscription product. I used the hospitality sector data of the company’s system to analyse dynamics during COVID-19, the results of which were quoted in The Financial Times and The Guardian.

*Research | Sep 2016 - Jun 2017

Business Analyst

Worked as a Business Analyst for *Research, a news and funding opportunities publication. I produced Google Analytics reports for the news team and implemented the company’s CRM.

UHNW Family Office | Jul 2015 - Sep 2015

Office Assistant

I was responsible for posting transactions to Quickbooks, for dealing with suppliers and customers and for dealing with general office admin.

AXA Investment Managers | Jul 2014 - Jul 2014

Work experience

Assisted in research for the emerging markets team, producing evaluative reports for the analyst to prepare for meetings.

Morgan Stanley | Jun 2011 - Jun 2011

Work Experience

I worked alongside a leisure analyst during the demerger of Spirit Pub Company from Punch Taverns. I was responsible for research.

My Education

Take a look at my formal education

Bachelor’s Degree, Economics and ManagementUniversity of Bristol | 2016
High School, Maths, Further Maths, Economics, ArtOundle School | 2012

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free