Jobs
>
London

    Finance Data Analyst - London, United Kingdom - Great Lakes Insurance SE

    Great Lakes Insurance SE
    Great Lakes Insurance SE London, United Kingdom

    1 week ago

    Default job background
    Description

    About Great Lakes Insurance SE:

    As specialty provider of primary insurance services in the UK, Great Lakes London Branch (" GLLB ") is a substantial part of Great Lakes Insurance SE in Munich. Our interlocked business model is to seize opportunities closely connected to the reinsurance core business and innovation opportunities, in our role as an integral part of the Munich Re Group. Great Lakes Insurance SE operates from its headquarters in Munich, and via branch offices in UK, Ireland, Switzerland, Italy and Australia.

    Great Lakes Insurance UK Limited (" GLLS "), regulated by Prudential Regulation Authority and the Financial Conduct Authority, is a fully owned subsidiary of Great Lakes Insurance SE and acts as the preferred facilitator of agency insurance business in the UK in the post-Brexit world.

    non-traditional insurances through 6 lines of business; namely, Property, Energy, Casualty, Engineering, Cyber and what we term Special Enterprise Risks. We overlay these underwriting activities with support from our Client Management and Claims & Operations units.

    Our clients are complex, diverse, and domiciled across the world. Therefore, we also need to be global, and we do this by positioning staff in strategic markets and locations as well as travelling to meet clients. Close contacts are very important.

    About the role:

  • As the Finance Data Analyst you will be responsible for gathering, transforming, loading, analyzing and reconciling the detailed claims/premiums/sum insured data (received from third parties) required for the Solvency II Reporting team to prepare the Solvency II Quantitative Reporting temples (QRT) on a quarterly/annual basis.
  • You will work closely with three teams internally (Reinsurance Accounting, the Data Team and the Solvency II Reporting Team) to follow up on outstanding data, cleanse received data) and ensure all data is loaded, reconciled on time for each reporting cycle within our key systems (FSRI, EDWH and DFEnS), with emphasis on data quality.
  • Work with the Solvency II Reporting team with special emphasis on supporting the production, validation and analysis of data to fulfil the Company and Branch's solo & group reporting obligations to both PRA (UK Regulator) & BAFIN (German regulator).

    • Key Responsibilities:

  • Own the data gathering process for insurance transactional data (claims, premiums and sum insured) received from third party agents
  • Control and track the monthly loading of insurance transactional data and reconcile to underlying summary system, investigating and correcting any variances in quality or format required to load
  • Ensure data is up to date and of good quality for Solvency II reporting requirements
  • Maintain data integrity in systems by running queries and analyzing data compared to prior periods for consistency
  • Develop and document guidelines and procedures for data gathering, format & transformations needed
  • Support best practices for system and process change management, documentation of system processes and business practices & the development of standards for processes
  • Identify & design process improvements in end to end data journey
  • Liaise with Reinsurance Accounting Agency Technicians to identify the causes of and reasons for reconciliation differences and data quality issues. This includes proposing solutions as well as escalating such differences and issues when necessary in a timely manner so they can be resolved
  • Prepare data for loading to the Company/Branch's data warehouse, including providing assistance to technician colleagues, developing source to target data mapping solutions using advanced Excel and MS Access functionality
  • Extract the data from the Company/Branch's data warehouse and reconcile it with the summary bookings made in the Company's technical accounting system, and where necessary, to the information provided by the Company/Branch's business partners.
  • Extract data from the Company/Branch's technical accounting system, validate its accuracy and completeness. Liaise with Munich and Australia based colleagues to load the data to central systems. Validate output from central systems against input provided. Report validation results, highlighting exceptions to be reported for resolution.
  • Monitor data submissions from the Company's business partners to ensure they are current, up to date, and of the required quality, liaising with them directly, or via Reinsurance Accounting Agency Technicians to further develop means by which data is provided on a quality assured basis.
  • Support Solvency II Reporting Team during the key year end period if needed

    • Competencies:

    Nimble learning (we think big) – you actively learn by tackling new problems and trying out new solutions, quickly learning from both successes and failures.

    Collaborates (we lead the 'we') – you work together with others in your team, the department and wider business (where relevant) to meet shared commitments.

    Optimises work processes (we grow with our clients) – you know the most effective and efficient processes to get things done and are constantly assessing how they can be improved.

    Resourcefulness (we care and dare) – you find a way to get things done with the best use of the resources available to you, knowing when to ask for support from others, but also offering your support to others where you feel your expertise, knowledge and skills can add value.

    Communicates effectively (we are clear and authentic) – you communicate clearly and appropriately with your audience. You also share ideas, learn from others and keep stakeholders informed about progress, problems, opportunities and solutions, soliciting feedback along the way.

    Key Skills & Experience:

  • Demonstrable data gathering, loading, transforming, accuracy and reconciling skills
  • Ability to analyse the processes and collect relevant data and information, to interrogate the data and identify problems.
  • Knowhow and experience in data requirements gathering and plausibility testing, as well as being able to identify and offer the business improvements in process and assess their feasibility.
  • A good knowledge of problem solving and investigation with unreconciled items.
  • Advanced Excel skills (VBA Macros, SUMIF, INDEX/MATCH, Pivots etc. to analyse, reformat & compare large data sets from different sources and prepare simulations of regulatory reporting outcomes. Power BI knowledge.
  • Strong communication skills with all different types of stakeholders.
  • Good overall business analysis skills
  • Ability to work cross departments (finance and IT) and be an excellent team player who is comfortable to also work independently
  • Motivated individual who will chase data & control data quality

    • Qualifications and Educational Requirements:

  • Graduate with extensive systems experience and/or operational experience
  • Excellent communication and stakeholder management skills

    • Thought Leaders:

    You will demonstrate inclusive behaviour and encourage your colleagues to play an active role in creating an inclusive culture as well.

    You will treat your colleagues and sales and business partners fairly and with respect.

    Regulatory & Conduct Requirements:

    In addition to the responsibilities set out above, the Regulatory Reporting Specialist role is also responsible for:

  • Satisfying all regulatory reporting requirements in collaboration with the reporting function
  • Liaising with all relevant regulatory bodies in the UK, creating a highly credible reputation and strong, collaborative relationship
  • Ensuring compliance with Munich Re's Code of Conduct and the FCA Conduct Rules

    • Benefits

    You will be rewarded with a great compensation package, on target bonus, 25 days annual leave with the option to purchase more along with private medical insurance and employers' contributory pension of 10%

    About us

    You will work in an environment where we think big: Change and culture are continuously role-modelled. We create and articulate a compelling and ambitious shared purpose, vision and direction. We pave the way towards success and see failure as learning

    You are going to experience that we care & dare: We are empathetic. We know when to lead and know when to let others lead. We attract, grow and coach future leaders

    We communicate in a clear & authentic way: We interact with a positive and humble spirit. We solicit feedback, ask and listen, learn and unlearn

    You will grow with your clients: Whatever our role, we support business, in an efficient and effective way, to create value for our clients. We embrace new ways of working using digitalisation to deliver solutions

    We lead the We: We have a passion for winning and growing as a team. We inspire people to be capable of joint performance. We create an inclusive environment where different thoughts, generations, cultures and experiences are valued and encouraged

    Re is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all our employees

  • Data Idols

    Data Analyst

    2 weeks ago

    Data Idols London, United Kingdom

    **Data Analyst** Data Idols are delighted to be working with a growing estate agency firm, who have thousands of excellent reviews and properties in which are sold hourly They are looking for a Data Analyst to join their existing data team. · **The Opportunity** Within this role ...

  • Harnham - Data & Analytics Recruitment

    Data Analyst

    3 weeks ago

    Harnham - Data & Analytics Recruitment London, United Kingdom

    DATA ANALYST · £40,000 - £50,000 · LONDON · An FMCG giant is looking to bring in a Data Analyst to join their growing analytics function · THE COMPANY · This company is a multinational FMCG giant, with many well-known brands loved by millions of customers. The company is incredib ...

  • Harnham

    Data Analyst

    2 weeks ago

    Harnham London, United Kingdom

    **DATA ANALYST - SQL, POWER BI, EXCEL** · **LONDON - HYBRID (3 DAYS A WEEK)** · **£40,000** · **THE COMPANY** · This company is one of the most successful UK estate agencies, covering 80% of Greater London, with data as a driver of its huge accomplishments. Reporting into the Dir ...

  • Harnham

    Data Analyst

    1 week ago

    Harnham London, United Kingdom

    If you're a Data Analyst seeking your next career move in Chelsea, Harnham has an excellent opportunity for you. We are recruiting a full-time Data Analyst for a welcoming and collaborative team, and the role comes with a salary of £40,000-45,000. · As a flexible Data Analyst, yo ...

  • Venn Group

    Data Analyst

    2 weeks ago

    Venn Group London, United Kingdom

    **Data Analyst** · **Agency Reference Number: J66463** · Venn Group is currently working with an NHS Trust based near West London to recruit a Data Analyst to join their dynamic and fast paced team. · **Rate: £ PAYE) or £ Umbrella) per day** · **Hours: 37.5, Mon - Fri** · **Days ...

  • Harnham

    Data Analyst

    1 week ago

    Harnham London, United Kingdom

    **DATA ANALYST - SQL, PYTHON, DBT, LOOKER** · **CENTRAL LONDON - HYBRID** · **£50,000** · **THE COMPANY** · A mortgage marketplace that works with different estate agents to understand the market and use data to find a customer's best match. · **THE ROLE AND RESPONSIBILITIES** · ...

  • Harnham

    Data Analyst

    1 week ago

    Harnham London, United Kingdom

    **DATA ANALYST - SQL, TABLEAU, BIGQUERY** · **LONDON - REMOTE/HYBRID** · **£35,000** · - Please note that this opportunity does not offer sponsorship now or in the future. _ · An exciting opportunity to build reports and expand the BI capabilities of a tech company offering educa ...

  • The Hyde Group

    Data Analyst

    3 weeks ago

    The Hyde Group London, United Kingdom

    Hyde is looking to recruit a Data Analyst. · At the Hyde Group, our vision is to provide a great home for everyone. Our values guide the way we operate as a business: we're customer driven, inclusive, collaborative and innovative. As a Data Analyst you will be working as part of ...

  • Data Idols

    Data Analyst

    1 week ago

    Data Idols London, United Kingdom

    **Data Analyst** Data Idols are proud to be working with a consumer research platform that partner with global brands. Their goal is to give clients a simple life by allowing them to run regular research and achieve structured, clear insights to reveal opportunities withconsumer ...

  • Avanti

    Data Analyst

    3 weeks ago

    Avanti London, United Kingdom

    Data Analyst - Fintech - Liverpool Street - Hybrid · Avanti Recruitment are currently working with an independent trading company who specialise in commodity derivates trading. The company are looking to take on Data Analyst to join their small existing team. The company are base ...

  • Akkodis

    Data Analyst

    1 week ago

    Akkodis London, United Kingdom

    **Data Analyst / Permanent / SQL / Tableau / Power BI / GDPR / London / Hybrid** · **Data Analyst** · **Hybrid (2-3 days a week)** · **Birmingham/London** · **Permanent** · **30-40k per annum** · **The Data Analyst will be working on**: · - Create and improve policies and procedu ...

  • Concept Resourcing

    Data Analyst

    2 weeks ago

    Concept Resourcing London, United Kingdom

    Data Analyst · London, Bristol OR Manchester (1 to 2 days per week on site) · Day rates: £ per day · 3 months with possible extension · **INSIDE IR35, · CURRENT SC CLEARANCE NEEDED** · Concept Resourcing are looking for a Data Analyst to join a Central Government client based in ...

  • Harnham - Data & Analytics Recruitment

    Data Analyst

    1 week ago

    Harnham - Data & Analytics Recruitment London, United Kingdom

    **DATA ANALYST** · **£30,000- £35,000, Pension, hybrid working, 25 days holiday** · **LONDON BASED** · I'm working with one of the largest research consultancies in the world on a Data Analyst position within their social team. This role presents the opportunity to work with a ra ...

  • Akkodis

    Data Analyst

    3 weeks ago

    Akkodis London, United Kingdom

    **Data Analyst / Data Management / Data Modelling / Synthesis / Stakeholders** · **Job title**:Data Analyst · **Location**:London (hybrid) · **Job type**:Contract · An exciting opportunity has arisen for a Data Analyst to join a well-known organization based in the region of Lond ...

  • Anson McCade Ltd - IT and Finance Recruitment

    Data Analyst

    1 week ago

    Anson McCade Ltd - IT and Finance Recruitment London, United Kingdom

    **Role: Data Analyst** · **Location: London** · **Salary: Up to £45,000 + package DOE** · **Need to be UK SC Clearable** · We are recruiting for additional experienced Data Analysts to working in for a Central Government customer. The programme of work is very high profile, and i ...

  • Anson McCade Ltd - IT and Finance Recruitment

    Data Analyst

    2 weeks ago

    Anson McCade Ltd - IT and Finance Recruitment London, United Kingdom

    **Data Analyst - Hybrid · London - Permanent** · We are currently recruiting for an exiting opportunity with an industry leader in cyber security consulting who are looking for a Data Analyst to work for a Central Government customer. · As a Data Analyst, you will be working on a ...

  • Oliver James

    Data Analyst

    3 weeks ago

    Oliver James London, United Kingdom

    Data Analyst - Asset Management - Asset Manager - Investment Management - Investment Manager · I am currently working with an A client who is looking for a Data Analyst to join their team. · This role is within our client's Investment Data Platform function who are responsible fo ...

  • eFinancialCareers

    Data Analyst

    2 weeks ago

    eFinancialCareers London, United Kingdom

    I am working with a mid-sized Fund Manager looking to bring on a Data Analyst with experience across Private Markets. · Ideally you will have a solid background across Asset Management and more specifically Private Markets (Real Estate, Private Credit or Private Equity). · Indivi ...

  • Australasian Recruitment Company

    Data Analyst

    3 weeks ago

    Australasian Recruitment Company London, United Kingdom

    Data Analyst · **Salary**: £28.00 per hour · This is a temporary opportunity to work as a Data Analyst for one of the world's leading tech companies. In the role as Data Analyst the successful applicant will be supporting across 21 countries in the EMEA region and is required to ...

  • Eames Consulting

    Data Analyst

    2 weeks ago

    Eames Consulting London, United Kingdom

    **Data Analyst** · The client is offering £200 inside IR35 for a 3 month initial contract that will potentially get extended to 6 months. · **Required Skills**: · - Excellent knowledge of Microsoft Dynamics · - Advanced Excel, data collection and data manipulation skills, to incl ...