Sr Data Engineer

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.

Essential Duties & 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.

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.
• Strong verbal communication skills.
• 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
• Medical, dental, vision & life insurance
• 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.