Senior Data Engineer: Scalable Analytics & Data Solutions

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 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