Data Engineer

Summary

F&G is an insurance and retirement products company seeking a Data Engineer to support data sourcing, transformation, ingestion, analysis, and ETL development. The role focuses on building automated workflows and scalable data solutions using Informatica Data Management Cloud, Control-M, Snowflake, SQL, and related technologies.

Responsibilities

• Leverage Control-M to develop automated workflows that triggers processes, moves files, and ingests data in conjunction with other tools
• Develop robust data products and processes within Snowflake
• Support the sourcing, transformation, and analysis of data
• Develop ETL logic utilizing Informatica Data Management Cloud to support existing and future deployments
• Execute technical aspects of data management functions including creating, loading, transforming, cleansing, processing, analyzing, and visualizing data
• Assist teammates and business partners with building technical solutions that solve problems, are reusable, scalable, fast, and maintainable through large datasets, both clean and un-clean
• Work with multiple development technologies including SQL
• Learn new and existing tools, resources, and processes
• Assist in the implementation of architecture and solutions
• Develop and deliver code to support existing and future deployments
• Perform other functions, duties and projects as assigned
• Regular and punctual attendance

Skills

• • Strong analytical, critical-thinking, and problem-solving skills
• • Strong interpersonal communication skills, written and verbal
• • Fast, adaptive learner
• • Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• • Ability to manage multiple tasks and deadlines simultaneously
• • Exhibits flexibility and tolerance for ambiguity with the ability to thrive in a rapidly changing business environment
• • Results-oriented & Dedicated work ethic
• • Basic understanding of object-oriented analysis and design
• • Bachelors Degree with emphasis in technology, engineering, or math
• • Combination of education and experience considered in lieu of degree
• • 2+ years of relevant professional experience
• • Experience working with data structures and ETL tools (e.g., Informatica, Informatica Data Management Cloud)
• • Experience with SQL Server, Oracle, and/or Snowflake
• • Experience writing SQL queries and interpreting data models
• • Experience with database modeling
• • Experience in financial services or insurance industry
• • This position primarily involves sedentary work, requiring long periods of sitting, regular use of a computer, and occasional standing or walking, with reasonable accommodations available
• Ability to travel up to: 10% of the time

Qualifications

Must Haves

• • Strong analytical, critical-thinking, and problem-solving skills
• • Strong interpersonal communication skills, written and verbal
• • Fast, adaptive learner
• • Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• • Ability to manage multiple tasks and deadlines simultaneously
• • Exhibits flexibility and tolerance for ambiguity with the ability to thrive in a rapidly changing business environment
• • Results-oriented & Dedicated work ethic
• • Basic understanding of object-oriented analysis and design
• • Bachelors Degree with emphasis in technology, engineering, or math
• • Combination of education and experience considered in lieu of degree
• • 2+ years of relevant professional experience
• • Experience working with data structures and ETL tools (e.g., Informatica, Informatica Data Management Cloud)
• • Experience with SQL Server, Oracle, and/or Snowflake
• • Experience writing SQL queries and interpreting data models
• • Experience with database modeling
• • Experience in financial services or insurance industry
• • This position primarily involves sedentary work, requiring long periods of sitting, regular use of a computer, and occasional standing or walking, with reasonable accommodations available
• Ability to travel up to: 10% of the time

Benefits

• Ability to work in-office, hybrid, or remote arrangements, determined with the leader based on what works best for the role.