OIP Insurtech

We are seeking a skilled SQL Developer to join our team. This role serves as a key bridge between insurance operations and technical solutions, ensuring business requirements are accurately translated into efficient system functionality. The SQL Developer will play a critical part in maintaining and enhancing underwriting software products and system integrations—helping deliver reliable, high-quality solutions to clients in the insurtech space.

The ideal candidate possesses strong SQL expertise, advanced data mapping capabilities, and hands-on experience working with APIs, JSON, XML, and other data exchange formats. Experience with insurance technology platforms, such as ConceptOne or similar underwriting systems, is preferred. In this role, you will regularly develop, maintain, and troubleshoot stored procedures and functions, perform data validation, support integration efforts across multiple systems, and configure insurance workflows. You will work closely with business analysts, underwriters, and technical teams to ensure smooth product updates and continuous improvement of system functionality.

What We’re Looking For:

• 5+ years of experience in a technical, insurance, or insurtech-focused role
• Strong proficiency in writing SQL, including complex queries, stored procedures, and performance tuning
• Expertise in data mapping, data validation, and reporting
• Experience working with APIs, JSON, XML, and system-to-system integrations
• Strong analytical and problem-solving skills with the ability to troubleshoot and optimize complex workflows
• Clear and effective communication skills, able to translate technical concepts for non-technical stakeholders
• Ability to work independently and manage multiple tasks in a fast-paced environment
• Keen attention to detail and commitment to delivering accurate, high-quality results
• 
  

Bonus:

• Hands-on experience with underwriting or policy administration systems (e.g., ConceptOne or similar platforms)
• Familiarity with core insurance processes, such as policy issuance, endorsements, raters, claims, and reporting
• Experience with the U.S. P&C (Property & Casualty) insurance

What You’ll Be Doing:

• Develop and optimize SQL stored procedures, functions, and triggers to support underwriting and compliance requirements
• Create and maintain reports, quote covers, and validations or map and configure forms, raters, and system workflows to ensure accurate data processes
• Set up, troubleshoot, and optimize underwriting platforms (ConceptOne/others) for performance and accuracy
• Manage integrations with APIs, JSON, and XML to connect external services and streamline data exchange
• Collaborate with BAs, QAs, and Developers to translate requirements, test outputs, and resolve issues
• Provide technical support and training to internal teams and clients to ensure effective system usage

We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.

Qualifications and Skills:

• Minimum 5 years of experience as a Data Engineer
• Hands-on experience with Azure cloud-based data solutions
• Expertise in database design and management, including SQL databases such as SQL Server
• Proficient in ETL (Extract, Transform, Load) design for data integration and processing
• Strong knowledge of data modeling principles and techniques
• Ability to analyze and translate data into actionable insights, reports, and visualizations
• Proficiency in Power BI for reporting and data visualization

Desirable Skills:

• Experience with Power BI Report Builder / Reporting Services
• Knowledge of statistical analysis or Data Science
• Experience within the UK Insurance industry is a plus
• Python or R coding skills

Responsibilities:

• Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
• Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
• Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
• Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
• Implement different methods of streaming data and create reconciliations for datasets
• Build analytical models to support reporting and analytics
• Collaborate with an agile delivery team to work on the backlog of specified work

We’re looking for a dynamic and driven Data Analyst to join our team of technology enthusiasts. This role is crucial in transforming data into insights that support strategic decision-making and innovation within the insurance technology (InsurTech) space. If you’re passionate about working with data, understanding systems, and delivering value through analytics, we’d love to hear from you.

What We’re Looking For

• Proven experience working as a Data Analyst or in a similar analytical role
• 5+ Years of experience in the field
• Strong command of SQL for querying and manipulating relational databases
• Experience with Power BI for building impactful dashboards and reports
• Familiarity with QlikView and Qlik Sense is a plus
• Ability to communicate findings clearly to technical and non-technical stakeholders
• Knowledge of Python or R for data manipulation is nice to have
• Bachelor’s degree in Computer Science, Statistics, Mathematics, Economics, or a related field
• Understanding of the insurance industry or InsurTech is a strong advantage

What You’ll Be Doing:

• Delivering timely and insightful reports to support strategic decision-making
• Working extensively with Policy Administration System (PAS) data to uncover patterns and trends
• Ensuring data accuracy and consistency across reports and systems
• Collaborating with clients, underwriters, and brokers to translate business needs into data solutions
• Organizing and structuring datasets, contributing to data engineering workflows and pipelines
• Producing analytics to support business development and market strategy

Are you passionate about leveraging data to drive strategic decisions? Join us at OIP Insurtech, where you'll play a pivotal role in analyzing market trends, optimizing operational processes, and transforming customer experiences. Bring your analytical prowess and business acumen to collaborate with a dynamic team dedicated to shaping the future of insurance technology. Apply now and be part of revolutionizing the industry with cutting-edge insights and solutions.

Requirements:

• 3-5 years of experience 
• Capable of independently conducting various aspects of business analysis, including requirements gathering, process analysis, and documentation. 
• Proactive in identifying and prioritizing issues within their domain and taking the initiative to work with the team to resolve them.
• Strong background in accounting and/or financial controlling 
• Demonstrates a high level of skill and independence
• Understands the full business analysis lifecycle and is proficient in handling various business problems and custom cases.
• Good knowledge of English
• Experience in accounting and business analysis in the IT industry is highly desirable 
• Working knowledge of software development concepts, technologies, practices, and principles, and the ability to use them in different situations independently
• Good understanding of the software development lifecycle

Duties and responsibilities:

• Works closely with the development team and other stakeholders to investigate model business functions, business processes, information flows, and data structures
• Investigate operational issues, problems, and new opportunities; seek effective business solutions through improvements in aspects of business areas or systems of interest
• Assists in the analysis of underlying issues and their root causes, and identifies available options
• Communicates with clients and other stakeholders and assists in presenting issues and solutions both verbally and in writing
• Specifies data, data objects, and information flows that align with the needs of the business
• Produces business analysis deliverables using relevant documentation styles in line with company standards
• Facilitates stakeholder meetings and workshops, and presents findings and actions both verbally and in writing to the business
• Able to translate business requirements into a structured form
• Able to create structure within projects and project teams following Agile principles
• Understands the domain (Insurance Industry) and how it functions, after spending 6M in the company
• Understands the entire Policy Lifecycle, after spending 6M in the company
• Experience in using tools like Jira, Confluence, LucidChart, or other software for requirements management, documentation, and process modeling
• Experience with Agile frameworks
• Experience with testing methodologies, test planning, and quality assurance processes to ensure reliable and robust systems

Are you passionate about leveraging data to drive strategic decisions? Join us at OIP Insurtech, where you'll play a pivotal role in analyzing market trends, optimizing operational processes, and transforming customer experiences. Bring your analytical prowess and business acumen to collaborate with a dynamic team dedicated to shaping the future of insurance technology. Apply now and be part of revolutionizing the industry with cutting-edge insights and solutions.

Requirements:

• 3-5 years of experience 
• Capable of independently conducting various aspects of business analysis, including requirements gathering, process analysis, and documentation. 
• Proactive in identifying and prioritizing issues within their domain and taking the initiative to work with the team to resolve them.
• Strong background in accounting and/or financial controlling 
• Demonstrates a high level of skill and independence
• Understands the full business analysis lifecycle and is proficient in handling various business problems and custom cases.
• Good knowledge of English
• Experience in accounting business analysis in the IT industry is highly desirable 
• Working knowledge of software development concepts, technologies, practices, and principles, and the ability to use them in different situations independently
• Good understanding of the software development lifecycle

Duties and responsibilities:

• Works closely with the development team and other stakeholders to investigate model business functions, business processes, information flows, and data structures
• Investigate operational issues, problems, and new opportunities; seek effective business solutions through improvements in aspects of business areas or systems of interest
• Assists in the analysis of underlying issues and their root causes, and identifies available options
• Communicates with clients and other stakeholders and assists in presenting issues and solutions both verbally and in writing
• Specifies data, data objects, and information flows that align with the needs of the business
• Produces business analysis deliverables using relevant documentation styles in line with company standards
• Facilitates stakeholder meetings and workshops, and presents findings and actions both verbally and in writing to the business
• Able to translate business requirements into a structured form
• Able to create structure within projects and project teams following Agile principles
• Understands the domain (Insurance Industry) and how it functions, after spending 6M in the company
• Understands the entire Policy Lifecycle, after spending 6M in the company
• Experience in using tools like Jira, Confluence, LucidChart, or other software for requirements management, documentation, and process modeling
• Experience with Agile frameworks
• Experience with testing methodologies, test planning, and quality assurance processes to ensure reliable and robust systems