Sr Data Engineer

UFG Insurance; United States; On-site; USD 103,000 - 136,000; Full time

Benefits offered by this job

Annual incentive compensation

Retirement plans

Generous time-off

Job summary

UFG Insurance is seeking a Sr. Data Engineer to lead analytics data initiatives and enable enterprise data democratization. You will collaborate with Data Analysts, Data Scientists, Actuaries, and business teams to build scalable data solutions, ensuring data quality and consistent definitions across the enterprise.

Strong SQL, ETL, and data warehousing experience are essential. The role focuses on developing fault-tolerant data pipelines, delivering ready-to-use data, and mentoring junior

Qualifications

• Advanced SQL knowledge and experience with relational databases.
• Experience managing large scale databases and data warehouses.
• Programming with ETL tools such as SSIS.
• Experience handling large datasets, structured and semi-structured data.
• P&C insurance experience preferred.
• 7+ years of work experience as a data engineer or equivalent.

Responsibilities

• Build robust, fault-tolerant data pipelines that clean, transform, and aggregate data into databases.
• Provide data in a ready-to-use format to Enterprise Analytics team members.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Automate manual processes, optimize data delivery, and enhance infrastructure for greater scalability.
• Contribute to the design, construction, installation, testing and maintenance of highly scalable data warehouse solutions.
• Create data tools for UFG team members that drive efficiencies and improved decision making.
• Identify new projects and opportunities, and the associated data requirements.
• Research opportunities for data acquisition and new uses for existing data.
• Recommend and implement methods to improve data reliability, efficiency, and quality.
• Evolving our processes and architecture by researching and implementing new technologies.
• Maintain codebase using version control tools such as Git, SVN, etc.
• Troubleshoot and resolve issues in a timely manner.
• Educate, train, and serve as a mentor to newer Data Engineers.
• Collaborate with members across the organization on project goals.
• Design, build, and implement analytics solutions for users across the organization.
• Identify complex business problems and architect potential solutions.
• Enable team growth by mentoring peers.

Skills

Advanced SQL

ETL tools

Data modeling

Agile development

Communication skills

Mentoring

Education

Bachelor’s degree in computer science

Tools

SSIS

Tableau

Job description

UFG is currently hiring for a Sr. Data Engineer who will facilitate the development of Analytics solutions in support of UFG’s strategic plan. This individual will work closely with Data Analysts, Data Scientists, Actuaries, and the broader UFG team to develop and implement data strategies that support the democratization, integration, and standardization of data at an enterprise level, ensuring consistency of business definitions and data quality. The ideal candidate will possess strong technical, analytical and communication skills, as well as proven experience in data management, information management, and the insurance industry in general.

• Build robust, fault-tolerant data pipelines that clean, transform, and aggregate data into databases.
• Provide data in a ready-to-use format to Enterprise Analytics team members.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Automate manual processes, optimize data delivery, and enhance infrastructure for greater scalability.
• Contribute to the design, construction, installation, testing and maintenance of highly scalable data warehouse solutions.
• Create data tools for UFG team members that drive efficiencies and improved decision making.
• Identify new projects and opportunities, and the associated data requirements.
• Research opportunities for data acquisition and new uses for existing data.
• Recommend and implement methods to improve data reliability, efficiency, and quality.
• Evolving our processes and architecture by researching and implementing new technologies.
• Maintain codebase using version control tools such as Git, SVN, etc.
• Troubleshoot and resolve issues in a timely manner.
• Educate, train, and serve as a mentor to newer Data Engineers.
• Collaborate with members across the organization on project goals.
• Design, build, and implement analytics solutions for users across the organization.
• Identify complex business problems and architect potential solutions.
• Enable team growth by mentoring peers.

Job Specifications:

Education:

• Bachelor’s degree in computer science or related technical degree.

Certifications/Designations:

• Employees are encouraged to participate in continuing education throughout their careers.

Experience:

• Advanced SQL knowledge and experience working with relational databases.
• Experience in methodologies and processes for managing large scale databases.
• Programming experience with ETL tool(s) (e.g. SSIS)
• Demonstrated experience in handling large datasets, structured and semi-structured data formats.
• P&C insurance experience preferred
• 7+ years of work experience as a data engineer or equivalent experience.

Working Conditions:

• General office environment.

Skills & Knowledge:

Skills:

• Strong analytical skills with attention to detail and accuracy.
• Ability to analyze existing tools and databases; and provide recommendations.
• Ability to deliver incremental value via an Agile Development Methodology.
• Adept at queries, report writing, and presenting findings.
• Ability to translate business requirements into non-technical, lay terms.
• Ability to take ownership and collaborate across the organization.

Knowledge:

• Understanding of star/snowflake schemas as general data warehousing methodologies (i.e. Kimball).
• Working knowledge of and experience with Tableau or similar BI tool preferred.

Pay Transparency Statement:

UFG Insurance is committed to fair and equitable compensation practices. The base salary range for this position is $103,221 - $136,105 annually, which represents the typical range for new hires in this role. Individual pay within this range will be determined based on a variety of factors, including relevant experience, education, certifications, skills, internal equity, geography and market data.

In addition to base salary, UFG Insurance offers a comprehensive total rewards package that includes:

• Annual incentive compensation
• Accident, critical Illness & short-term disability insurance
• Retirement plans with employer contributions
• Generous time-off program
• Programs designed to support the employee well-being and financial security.

This pay range disclosure is provided in accordance with applicable state and local pay transparency laws.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.