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. In California, dba IOA Insurance Services. (0E67768) For more information, visit www.ioausa.com. Job Description: Position Title: Senior Data Engineer Department: Enterprise Systems Reports To: Director, Data Analytics Supervises: N/A Classification: Full Time, Permanent JOB SUMMARY: The Senior Data Engineer 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 is delivered. ESSENTIAL FUNCTIONS: •Create and maintain optimal data pipeline architecture, and manage an Enterprise Datawarehouse •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, re-designing infrastructure for greater scalability, etc. •Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Microsoft Azure ‘big data’ technologies. •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. •Work as part of a Data and BI team to strive for greater functionality in our data systems. •Participate in code reviews, proactively identifying and mitigating potential issues and defects •Managing competing resources and priorities. •Other duties as assigned. NON-ESSENTIAL FUNCTIONS: •Lifting and carrying large equipment/boxes over 5lbs •Bending and stooping to utilize necessary office equipment •Participation in team building and other activities QUALIFICATIONS AND EXPERIENCE: •8 years’ experience in a data engineering 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 •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. https://www.ioausa.com/