Data Engineer

Summary

Join F&G as a Data Engineer and provide technical expertise and support for data integration projects. Collaborate with technical teams to design and implement functional solutions, ensuring efficient data pipelines. Partner with stakeholders to understand business needs and translate them into scalable data architectures. Contribute to project estimates, support continuous improvement initiatives, and serve as a resource for data analysis and engineering tasks. Develop and implement ETL workflows using tools like Informatica, and assist in managing technical aspects of data platforms. Work with stakeholders to gather requirements and collaborate with senior engineers on designing solutions. Participate in data management processes, including data visualization.

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

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

Preferred Qualifications

• 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

In-office, hybrid and remote work arrangements