At a Glance
- Tasks: Investigate complex insurance data systems and provide insights for transformation projects.
- Company: Join a leading insurance organisation driving major data transformation.
- Benefits: Hybrid work model, competitive pay, and opportunities for professional growth.
- Other info: Ideal for curious problem solvers eager to dive into complex data.
- Why this job: Be at the forefront of data innovation in the insurance industry.
- Qualifications: Strong SQL skills and experience in technical data analysis required.
The predicted salary is between 43362 - 52998 £ per year.
We are supporting a major insurance organisation through a large-scale data transformation and legacy re-platforming programme. At the heart of the programme is the creation of a standardised enterprise data model designed to provide a consistent view of insurance data across areas including policy, claims, reinsurance and other core insurance domains. These systems vary significantly in structure, terminology, documentation and data quality. The architecture follows a broadly Medallion-style approach, with data moving from legacy source systems through raw/bronze layers and into a standardised, conformed enterprise model.
The programme initially operated with a single delivery squad while the architecture, data model and ways of working were established. We are looking for a highly analytical and technically capable Source System Analyst/Technical Business Analyst to join the programme. This is not a conventional Business Analyst position. The role sits somewhere between a Technical Business Analyst, Data Analyst and Source System SME, with a strong emphasis on hands-on investigation of data.
You will be responsible for understanding unfamiliar insurance source systems and identifying where the data required by the target model actually sits, how it behaves and how different entities relate to one another. Some source systems may contain hundreds or even thousands of tables, with limited documentation and limited retained knowledge within the business. Your role is to carry out the initial investigation and provide the downstream Data Designers with enough understanding to move into detailed mapping and solution design.
- Investigate unfamiliar insurance source systems and databases.
- Use SQL to interrogate complex and potentially poorly documented data estates.
- Identify where key insurance entities and business concepts are represented within source systems.
- Understand how data entities relate to one another.
- Analyse how data behaves over time, including history, overwrites, effective dates and record lifecycle.
- Work with business SMEs and system owners to understand the purpose and behaviour of source data.
- Read and interpret target data models.
- Carry out source-to-target analysis.
- Produce SQL queries to support and evidence findings.
- Provide Data Designers with sufficient analysis to begin detailed solution design.
- Work closely with Data Designers and Data Engineers throughout delivery.
Insurance Domain Experience - You should have a strong understanding of insurance data and common insurance concepts.
Strong SQL - You must be comfortable working directly with data using SQL. You should be able to use SQL to profile data, understand table structures, identify relationships, validate assumptions, investigate data behaviour etc.
Technical Data Analysis - You should have strong experience analysing complex data environments and working through unfamiliar systems.
Technical Business Analysis - You should be able to work effectively with business stakeholders and SMEs, understand requirements and translate those conversations into technical data investigations.
Data Modelling Awareness
The ideal person is naturally curious, technically capable and comfortable solving problems where the answer isn't immediately available. If documentation doesn't provide the answer and the SME doesn't know, you need to be the type of person who gets into the data and works it out. If you enjoy getting into complex data, understanding how systems really work and translating that knowledge into something a delivery team can act on, click apply now.
BI Analyst / Technical Business Analyst in City of London employer: Primus Connect
Primus Connect is an excellent employer for those seeking to advance their careers in data engineering within a dynamic and innovative environment. With a strong focus on employee growth, the company offers opportunities for professional development and collaboration with experienced engineers, all while working remotely. The supportive work culture fosters creativity and teamwork, making it an ideal place for individuals passionate about modern data platforms and AI solutions.
StudySmarter Expert Advice🤫
We think this is how you could land BI Analyst / Technical Business Analyst in City of London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Primus Connect!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like BI Analyst / Technical Business Analyst at Primus Connect.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Primus Connect.
✨Apply Directly through Our Website
When you find a suitable opening like BI Analyst / Technical Business Analyst at Primus Connect, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace BI Analyst / Technical Business Analyst in City of London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Primus Connect, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Primus Connect. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Primus Connect
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Primus Connect!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
