Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and optimisation of data platforms and pipelines.
- Company: Join IOA, a top insurance brokerage known for innovation and excellence.
- Benefits: Enjoy a full-time role with opportunities for growth and mentorship.
- Why this job: Be part of a dynamic team shaping the future of data in insurance.
- Qualifications: 3+ years in data engineering; strong SQL and Azure skills required.
- Other info: Diversity and inclusion are at our core; we welcome all applicants.
The predicted salary is between 43200 - 72000 £ per year.
Insurance Office of America (IOA) is the fourth largest privately held insurance brokerage in the United States. Founded in 1988, IOA is a recognized leader in providing property and casualty, employee benefits, and personal lines insurance and risk management solutions as well as insurtech innovation. Headquartered in Longwood, Florida, IOA has more than 1,300 associates located in over 60 offices in the U.S. and United Kingdom.
JOB SUMMARY: The Lead Data Engineer / Architect is responsible for managing, expanding, and optimizing our business data platforms, supporting and working with project teams, business stakeholders, and product owners to ensure optimal data delivery, consistent data architecture, and effective performance of data solutions.
ESSENTIAL FUNCTIONS:
- Leading and coordinating the engineering architecture
- Coordinating & debugging DevOps release deployments to test/production environments
- Assisting the cloud engineering team with the coordinating & debugging of Azure infrastructure buildouts, monitoring & maintenance
- Developing, maintaining & debugging ingestion/ETL pipelines in Azure Data Factory
- Developing, maintaining & debugging ingestion/ETL database objects in Azure SQL
- Azure SQL performance tuning/optimization
- Data Platform Design and Architecture: Leading the design and implementation of data platforms, including data lakes, data warehouses, and other data processing systems
- Data Pipeline Development: Designing, building, and maintaining robust data pipelines for data ingestion, transformation, and loading
- Assemble large, complex data sets that meet functional / non-functional business requirements
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and assisting in re-designing infrastructure for greater scalability
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
- Work with stakeholders including the IT operations, automation and development teams to assist with data-related technical issues and support their data infrastructure needs
- Participate in code reviews, proactively identifying and mitigating potential issues and defects
- Work with Director of Data and Analytics to manage competing resources and priorities and plan delivery schedule and execution of product roadmap
- Data Modelling and Database Design: Define or review and modify data models and database structures for optimal performance and data organization
- Data Quality and Governance: Support the Director of Data and Analytics in ensuring data accuracy, integrity, and compliance with data regulations and best practices
- Data Security: Work with the Information Security Cloud Engineering Team to review and make modifications where needed to support robust data security measures and access controls
- Team Leadership and Mentorship: Mentoring and guiding data engineers, fostering a collaborative and high-performing team
ESSENTIAL QUALIFICATIONS AND SKILLS:
- 3+ years' experience in a lead data engineering or lead data architecture role
- Bachelor's degree in computer science, statistics, informatics, information systems, or another quantitative field
- Advanced working SQL knowledge and experience working with relational databases, ETL pipelines, architectures, and data sets
- Experience with scripting languages such as R and Python
- Extensive experience with a cloud platform, Microsoft Azure preferred
- Experience in building and maintaining ML models
- Prior experience working in the financial services or insurance industry (desired)
- Demonstrated ability to be reliable and flexible
- A track record of following through on commitments
- Ability to grasp new concepts and technologies and adapt to changes and demands in a fast-paced, dynamic environment
- Displays intellectual curiosity, problem-solving skills and has a value-driven perspective to understanding business context and impact
- Exceptional analytical and conceptual thinking skills
- Excellent documentation skills
- Excellent planning, organizational, and time management skills
Insurance Office of America is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Lead Data Engineer/Architect | London, UK employer: Insurance Office of America
Contact Detail:
Insurance Office of America Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Data Engineer/Architect | London, UK
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, especially Azure Data Factory and Azure SQL. Having hands-on experience or projects that showcase your skills in these areas can set you apart from other candidates.
✨Tip Number 2
Network with professionals in the insurance and financial services sectors. Attend industry meetups or webinars to connect with potential colleagues or hiring managers at Insurance Office of America, which could give you an edge in understanding their culture and needs.
✨Tip Number 3
Prepare to discuss your leadership and mentoring experiences in data engineering. Highlight specific examples where you've led a team or project, as this role requires strong leadership skills to guide data engineers effectively.
✨Tip Number 4
Stay updated on the latest trends in data architecture and engineering, particularly in the context of insurtech. Being able to discuss recent innovations or case studies during your interview can demonstrate your passion and commitment to the field.
We think you need these skills to ace Lead Data Engineer/Architect | London, UK
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering and architecture. Focus on your skills with Azure, SQL, and ETL pipelines, as well as any leadership roles you've held.
Craft a Compelling Cover Letter: In your cover letter, explain why you're passionate about the role and how your background aligns with the responsibilities outlined in the job description. Mention specific projects or achievements that demonstrate your expertise.
Showcase Technical Skills: Include a section in your application that lists your technical skills, particularly those mentioned in the job description, such as experience with cloud platforms, scripting languages, and data modelling.
Highlight Leadership Experience: Since this is a lead position, emphasise any previous leadership or mentorship roles you've had. Discuss how you have guided teams or contributed to project success in your past positions.
How to prepare for a job interview at Insurance Office of America
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, ETL pipelines, and Azure. Highlight specific projects where you've successfully implemented data solutions, as this will demonstrate your technical expertise and problem-solving abilities.
✨Understand the Company’s Business Model
Research Insurance Office of America and understand their services and market position. Being able to relate your skills to their business needs will show that you are genuinely interested in the role and how you can contribute.
✨Prepare for Scenario-Based Questions
Expect questions that assess your ability to handle real-world challenges. Prepare examples from your past experiences where you led a project, resolved a technical issue, or improved a process, as these will illustrate your leadership and analytical skills.
✨Demonstrate Team Leadership and Mentorship
Since the role involves mentoring other data engineers, be ready to discuss your leadership style and any previous mentoring experiences. Share how you foster collaboration and support team members in achieving their goals.
