Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the development and management of our data warehouse and create impactful Power BI reports.
- Company: Oneglobal is revolutionising insurance broking with a focus on innovative risk management solutions.
- Benefits: Enjoy a hybrid working environment and be part of a growing international team.
- Why this job: Join us to shape the future of insurance broking while enhancing your data skills in a dynamic culture.
- Qualifications: Experience in data warehousing, SQL, and Power BI is essential; knowledge of the insurance industry is a plus.
- Other info: We value diversity and are committed to equal opportunities for all applicants.
The predicted salary is between 43200 - 72000 £ per year.
About Us
On a mission to reinvigorate broking. Oneglobal is a commercial insurance and reinsurance broker set up with the singular focus of improving the way in which businesses around the world manage risk via insurance.
We think broking needs a refresh, and that our approach builds that foundation. We have ambitious plans for the future and are looking to grow our talented team. If you would like to find out more about Oneglobal, please visit our website or our LinkedIn page.
Job Purpose
We have a fantastic opportunity for a data-driven individual who has a passion to develop and maintain the in-house data warehouse and deliver creative reporting solutions. The ideal candidate will have extensive hands-on experience in this area, with a solid understanding and previous exposure to the insurance industry.
Our Data & Analytics function is crucial in supporting the implementation of business strategy and international business growth by championing decision making and innovation through data-driven approaches.
The is a full-time permanent position based in our London office with the opportunity to work within a hybrid working environment. This is an exciting opportunity to be part of and shape Oneglobal’s growing international network of offices. The successful candidate will have excellent attention to detail, be proactive, be a strong communicator and keen to develop their skillset and technical knowledge.
Key Accountabilities
- Lead on developing, maintaining and managing the data warehouse
- Lead on sourcing, analysing and transforming the data from existing systems into the data warehouse
- Actively contribute to provision of Power BI reports and dashboards to internal and external partners
- Development, visualization, and distribution of Power BI reports
- Responsible for engaging and managing stakeholders across our international offices
- Researching and proposal technical solutions to solve business challenges
- Work alongside the data analytics lead to deliver strategic solutions to the business
Skills & Knowledge
Technical Skills – Data Warehouse
- Superior knowledge of data warehouse structure and function
- Manage and maintain data warehouse code
- Superior hands-on knowledge of implementing ETL processes
- Experience of integrating multiple systems in one data warehouse
- Design and document processes, data flows, lineage
- Planning and scheduling of data warehouse routines
Technical Skills – SQL Server Database
- Develop SQL server database solutions
- Advanced knowledge of writing SQL queries, stored procedures and functions using T-SQL
- Analyse existing SQL queries, debug issues and improve
- Performance optimization, indexing
- Experience using database mail (dbmail)
- SQL Server job agent
- Comfortable working with structured and semi-structured data files (CSV, Excel, XML, JSON).
Technical Skills – Power BI
- Prototype, design, develop and publish Power BI Reports
- Develop Power BI Data models and recommend best practices for report creation and visualisations
- Use different Power BI visuals, data transformation module, Power query and DAX
- Troubleshoot reporting issues and tune report performance
- Implement security in reports and dashboards in accordance with security and access requirements
Technical Skills – Data Projects & Development
- Experience managing data projects from discovery to delivery, balancing business value and technical feasibility.
- Foundational development knowledge including Python (data manipulation, automation scripts, API integration).
- Able to work with REST APIs to consume external data, such as risk models or compliance checks, and integrate into SQL or Power BI.
- Familiarity with version control systems (e.g., Git) and working within structured development environments.
- Use of Power Apps and Power Automate to build no-code/low-code solutions and workflows, including SharePoint list integration and form submissions
Technical Skills – Other
- Knowledge of Master Data Management
- Knowledge of data migration
- Knowledge of Sharepoint lists
- Awareness of SQL Server Integration Services
- Awareness of SQL Server Reporting Services
- Working with flat files and structured data load
Functional Skillset – Business
- Working knowledge of insurance domain (policies, transactions, premiums, claims) is essential
- Working knowledge of insurance broking (counterparties e.g., clients, underwriters, brokerage) and Lloyd’s market is highly desirable
- Knowledge of financial accounting (general ledger, financial statements e.g., balance sheet, P&L, trial balance, debit / credit concepts) is highly desirable
Soft Skillset
- Skills to engage with and manage stakeholders is essential
- Clearly communicate with business users on the issues, requirements and deliverables is essential
- Analytically minded with excellent problem-solving skills and attention to detail
- Ability to use own initiative and work autonomously or as part of a team.
Our goal
Our clients are at the forefront of everything we do. As an employee of Oneglobal your contributions matter and drive us towards our ambitious plans for the future. We believe our open working culture will see passionate and enthusiastic people join us to grow the business together and enable us to become an employer of choice.
Oneglobal is committed to being an equal opportunities employer, ensuring that all employees, prospective employees and clients are treated fairly and with respect and integrity. Please let us know if you require any reasonable adjustments at any point in the application or interview process.
#J-18808-Ljbffr
Data Solutions Lead (Insurance Broking) employer: Oneglobal Broking
Contact Detail:
Oneglobal Broking Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Solutions Lead (Insurance Broking)
✨Tip Number 1
Familiarise yourself with the insurance industry, especially the broking sector. Understanding key concepts like policies, transactions, and the Lloyd's market will help you speak confidently about how your skills can contribute to Oneglobal's mission.
✨Tip Number 2
Showcase your technical skills in data warehousing and Power BI during networking opportunities. Engage with professionals in the field on platforms like LinkedIn, and share insights or ask questions related to data solutions in insurance to demonstrate your passion and knowledge.
✨Tip Number 3
Prepare to discuss your experience with ETL processes and SQL Server in detail. Be ready to provide examples of how you've managed data projects from discovery to delivery, as this aligns closely with the responsibilities of the Data Solutions Lead role.
✨Tip Number 4
Highlight your soft skills, particularly your ability to engage with stakeholders and communicate effectively. Consider preparing anecdotes that illustrate your problem-solving skills and attention to detail, as these are crucial for the role at Oneglobal.
We think you need these skills to ace Data Solutions Lead (Insurance Broking)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data warehousing, SQL Server, and Power BI. Use specific examples from your past roles that demonstrate your skills in these areas, especially within the insurance industry.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data-driven solutions and how they can improve business processes. Mention your understanding of the insurance sector and how your skills align with Oneglobal's mission to refresh broking.
Showcase Technical Skills: Clearly outline your technical skills related to data management, ETL processes, and report creation in Power BI. Provide examples of projects where you successfully implemented these skills, particularly in a business context.
Highlight Soft Skills: Don't forget to mention your soft skills, such as communication and stakeholder management. These are crucial for the role, so provide examples of how you've effectively engaged with stakeholders in previous positions.
How to prepare for a job interview at Oneglobal Broking
✨Showcase Your Data Warehouse Expertise
Be prepared to discuss your hands-on experience with data warehouses. Highlight specific projects where you developed or maintained a data warehouse, and be ready to explain the ETL processes you implemented.
✨Demonstrate Your SQL Skills
Since advanced SQL knowledge is crucial for this role, come equipped with examples of complex queries you've written. Be ready to discuss how you've optimised performance and debugged issues in previous roles.
✨Familiarise Yourself with Power BI
As Power BI is a key tool for this position, ensure you can talk about your experience in developing reports and dashboards. Bring examples of your work and be prepared to discuss best practices for data visualisation.
✨Understand the Insurance Industry
Having a working knowledge of the insurance domain is essential. Brush up on key concepts related to policies, claims, and the Lloyd's market, and be ready to discuss how your background aligns with Oneglobal's mission.
