Senior Data Engineer

Summary

Join F&G as a Senior Data Engineer and provide technical expertise and support for multiple concurrent data integration projects. Collaborate with technical and business 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. Lead and mentor team members, contributing to project estimates and continuous improvement initiatives. Develop and implement ETL workflows using various tools, ensuring smooth operation of data integration processes. Assist in managing technical aspects of data platforms and participate in data management processes.

Requirements

• Bachelor’s degree in computer science, MIS, or a related field (or equivalent combination of education and experience)
• 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
• Hands-on experience with MS SSRS, MS SSIS, Informatica PowerCenter, and Informatica Data Management Cloud
• 5+ years of experience designing, building, and supporting near real-time data pipelines and analytical solutions, preferably using Informatica
• 5+ years of experience in ETL support and production data operations, including file processing, data distribution, debugging, and Root Cause Analysis

Responsibilities

• Provide technical leadership, mentor, and guide select team members
• Collaborate with business in report development and automation opportunities
• 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
• 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
• Provide technical support, leadership, and mentorship to teams and contribute to managing data integration projects
• Collaborate with Analysts, Engineers, and Architects on designing solutions, ensuring successful project roadmaps and delivery
• 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
• 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 with database design/modeling tools such as Erwin
• Experience within a Financial Services/Insurer’s IT Organization
• 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