Data Engineer II

  • Cedar Rapids
  • United Fire E Casualty

UFG is currently seeking a Data Engineer II 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.
Responsibilities:

  • Build robust, fault-tolerant data pipelines that clean, transform, and aggregate data from across various sources.
  • Contribute to the design, construction, installation, testing and maintenance of highly scalable data warehouse solutions.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Create data tools for UFG team members that drive efficiencies and improved decision making.
  • Automate manual processes, optimize data delivery, and enhance infrastructure for greater scalability.
  • Troubleshoot and resolve issues in a timely manner.
  • Identify new projects and opportunities, and the associated data requirements.
  • Recommend and implement methods to improve data reliability, efficiency, and quality.
  • Evolving our processes and architecture by researching and implementing new technologies.
  • Research opportunities for data acquisition and new uses for existing data.
  • Provide data in a ready-to-use format to Enterprise Analytics team members.
  • Maintain codebase using version control tools such as Git, SVN, etc.
  • Collaborate with members across the organization on project goals.
Qualifications:
Education:
  • Bachelor's degree in computer science or related technical degree.
Certifications/Designations:
  • Employees are expected to participate in continuing education throughout their careers.
Experience:
  • Demonstrated experience in handling large datasets, structured and semi-structured data formats.
  • Advanced SQL knowledge and experience working with relational databases.
  • Programming experience with R and Python.
  • Experience in methodologies and processes for managing large scale databases.
  • Programming experience with ETL tool(s) (e.g. SSIS).
  • Experience scheduling and maintaining complex, cross system workflows.
  • P&C insurance experience preferred
  • 4+ years of working experience as a data engineer.
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.
  • Desire 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.