Data Engineer
Summary
Remote data engineer at a life insurance and annuity company who sources, transforms, and ingests data and builds automated ETL workflows using Informatica (IDMC), Control-M, Snowflake, and SQL to support current and future data deployments.
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 talentacquisition@fglife.com.
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.
Skills
As published by greenhouse · 12 questions · 2 written answers
Basics
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter, Location
Short answers (5)
- Are you FINRA registered? If so, please list the registration you hold and the expiration date.
- Have you ever held a position with this company or any of its subsidiaries?
- How were you referred for this position? If referred by a current F&G employee, please list name.
- What are your salary expectations for this role?
- If yes to having relatives employed at Fidelity Guaranty Life, please list the name of F&G current employee AND family relationship.
Pick from a list (5)
- Are you legally authorized to work in the United States?
- Are you subject to a non-competition agreement or other agreement which would preclude or restrict your employment at F&G or any F&G subsidiary or affiliate?
- Will you need F&G to sponsor you for a visa to work legally in the United States in the future?
- Do you have any relatives employed at Fidelity Guaranty Life?
- Will you need F&G to sponsor you for a visa to work legally in the United States now?
Written answers (2)
- Do you have any relatives employed by the Iowa Insurance Division, IRS, or New York Department of Financial Services? If yes, please provide details.
- Why are you looking for a new opportunity and why do you feel this position would be a good fit for you?