Lead Data Engineer/Architect

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, part of the greater Orlando community, 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.