Data Engineer

Fidelity And Guaranty Life Insurance Company - Des Moines, IA

Full-time - Entry Level

Remote - Des Moines, IA

Insurance Carriers and Related Activities

About the position

F&G is seeking a Data Engineer to provide technical expertise and support for multiple data integration projects. This role involves collaborating with technical teams to design and implement solutions that ensure efficient execution of data pipelines and integration processes. The Data Engineer will work closely with business and technology stakeholders to translate evolving business needs into scalable data architectures that align with the organization's goals.

Responsibilities

• Work with IT teams and Lines of Business on multi-domain integration initiatives.
• Support the delivery of business-facing data solutions that drive key business outcomes.
• Provide technical support to teams and contribute to managing data integration projects.
• Contribute to project and maintenance effort estimates in partnership with management.
• Support continuous improvement initiatives in data management and integration processes.
• Serve as a resource for data analysis and data engineering tasks, supporting ongoing projects.
• Develop and implement ETL workflows using tools such as Informatica, scripting, and load utilities.
• Collaborate with technical teams to develop functional solutions that meet data and business requirements.
• Ensure the smooth operation of data integration processes, focusing on performance, reliability, and scalability.
• Contribute to the design and implementation of data pipelines and integration solutions across multiple projects.
• Assist with managing the technical aspects of data platforms, including SaaS, third-party, and custom applications.
• Identify and address inefficiencies in third-party software, focusing on data integrity, security, performance, and manageability.
• Work with business and technology stakeholders to gather requirements and translate them into scalable, efficient data architectures.
• Collaborate with Senior Data Engineers and Architects on designing solutions, ensuring successful project roadmaps and delivery.
• Participate in data management processes such as creating, loading, transforming, cleansing, processing, analyzing, and visualizing data.

Requirements

• Bachelor's degree in Computer Science, MIS, or a related field (or equivalent combination of education and experience).
• 2+ years of experience designing, building, and supporting near real-time data pipelines and analytical solutions, preferably using Informatica.
• 2+ years of experience in ETL support and production data operations, including file processing, data distribution, debugging, and Root Cause Analysis.
• Hands-on experience with MS SSIS, Informatica PowerCenter, and Informatica Data Management Cloud.
• Proficiency in SQL Server with strong T-SQL query writing and data model interpretation skills.
• Extensive experience writing automated unit, integration, and acceptance tests for data interfaces and pipelines.

Nice-to-haves

• Exposure to Snowflake.
• Experience working with Azure Cloud.
• Exposure working with Data Security teams.
• Understanding of object-oriented analysis and design.
• Experience within a Financial Services/Insurer's IT Organization.
• Experience with database design/modeling tools such as Erwin.
• Experience building data pipelines and interfaces with object-oriented languages (.Net, Java, Python).
• Preferred experience in supporting data transfers from/to external organizations and internal systems using GlobalScape Enhanced File Transfer (EFT).

Benefits

• Flexible work arrangements (in-office, hybrid, remote)
• Reasonable accommodations for applicants and candidates with disabilities
• Employee-centric work environment
• Opportunities for professional development and growth