Senior Data Engineer

Summary

Join Fidelity & Guaranty Life Insurance Company (F&G) as a Senior Data Engineer and provide technical expertise and support for multiple 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. Provide technical leadership and mentorship to team members. Contribute to project estimates and support continuous improvement initiatives. Develop and implement ETL workflows using various tools. This role requires strong collaboration and communication skills, both written and verbal, with technical and business teams. F&G offers a flexible work environment with in-office, hybrid, and remote work arrangements.

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)
• Flexible and able to navigate ambiguity in dynamic environments
• Excellent analytical, critical-thinking, and problem-solving abilities
• Strong work ethic with the ability to manage multiple tasks and deadlines
• Knowledge of data architecture, integration strategies, and best practices
• Fast, adaptive learner who thrives in a rapidly changing business environment
• Proven experience in data engineering, data pipelines, and integration tools (e.g., ETL, Informatica)
• Strong collaboration and communication skills, both written and verbal, with technical and business teams
• Ability to collect, organize, analyze, and disseminate large amounts of information with attention to detail and accuracy

Benefits

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