About this Data Engineer role at Fidelity & Guaranty Life Insurance Company
Job Summary
The Data Engineer will support the sourcing, transformation, ingestion, and analysis of data and develop ETL logic utilizing Informatica (IDMC), Control-M, and Snowflake to support existing and future deployments.
Duties & 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
Supervisory Responsibilities: This role does not have formal people leadership responsibilities but may provide guidance, mentorship, or subject matter expertise to others.
Knowledge, Skills & Abilities
- 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
Minimum Qualifications
- 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
Other Requirements
- 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.
- Perform other functions, duties and projects as assigned
- Regular and punctual attendance
Ability to travel up to: 10% of the time
#LI-JB1 #LI-Remote
Additional Information
Work Environments
F&G believes in an employee-centric flexible environment, which is why we offer the ability for in-office, hybrid and remote work arrangements. During the hiring process, you'll work with your leader to decide what works best for your role.
F&G complies with federal and state disability laws and makes reasonable accommodations for applicants and candidates with disabilities, unless such accommodation would cause an undue hardship for F&G. If reasonable accommodation is needed to participate in the job application or interview process, please contact [email protected].
Join our employee-centric hybrid work environment: F&G Careers
About F&G
Since 1959, Fidelity & Guaranty Life Insurance Company (F&G) has offered annuity and life insurance products to those who are seeking security in retirement and protection during life’s unexpected events.
As a national Top Workplace1, an Iowa Top Workplace2 and a proud equal opportunity employer, F&G team members are empowered, collaborative, dynamic and authentic. We believe that by embracing these values, we will continue to build and strengthen the company while continuing to be a great place to work.
1Top Workplaces USA 2022 – 2023
2Des Moines Register Top Workplaces 2018 – 2022
Notice for all Applicants who are California residents under the California Privacy Rights Act. Please click here to review the policy.
