Sr. Data Engineer, Investments
Share
Job Location:
Des Moines, IA - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Job Summary
The Sr. Data Engineer will implement data integration architecture and solutions and design and develop ETL logic using Informatica Data Management Cloud Snowflake and various Azure tools to support existing and future deployments. This role will work to independently solve problems and fix technical issues and be responsible for unit test construction and execution.
Duties and Responsibilities
- Implement data integration architecture and solutions for our Investments and Hedging delivery teams.
- Design and develop ETL logic using Informatica Informatica Data Management Cloud Snowflake and various Azure data tools to support existing and future deployments
- Design and execute technical aspects of data management functions including creating loading transforming cleansing processing analyzing and visualizing data
- Collaborate directly with teammates and business partners to build 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
- Interact cross-functionally with other technical teams both internally and externally to implement complete technology solutions
- Design and develop code to support existing and future deployments
- Independently solve problems and fix technical issues
- Responsible for unit test construction and execution
Experience and Education Requirements
- Associates/Bachelors Degree (preferred emphasis in technology engineering or math related field) or equivalent combination of education and experience
- 4-7 years of experience designing building and supporting real-time data pipelines and analytical solutions
- 2 years of experience in supporting ETL production data operations (File processing data distribution etc.) including debugging addressing production issues and performing Root Cause Analysis
- Strong ability to write SQL queries Python scripts and interpret data models
- Experience with Snowflake SQL Server and/or Oracle
- Experience building data structures solutions and products
- Experience writing automated unit integration and acceptance tests for data interfaces & data pipelines
- Understanding of object-oriented analysis and design
Preferred Requirements
- Experience with Investments systems (e.g. Aladdin FactSet Clearwater INTEX and Bloomberg) is a huge benefit.
- Exposure to key investment analytics (e.g. yield duration) and understanding how they influence the portfolio management cycle is a huge benefit.
- Experience with database modeling
- Preferred to have experience in supporting data transfers from / to external organizations and internal systems using EFT (Electronic File Transfer)
- Working knowledge of Informatica Cloud Data Integration Informatica Cloud Mass Ingestion Snowflake Azure data tools.
- Experience with database design/modeling tools such as Erwin
- Experience within a Financial Services/Insurers IT Organization
Knowledge Skills and Abilities
- Strong analytical critical-thinking and problem-solving skills
- 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
- Strong interpersonal communication skills written and verbal
Other Requirements
- Perform other functions duties and projects as assigned
- Regular and punctual attendance
- Minimal travel required (less than 10%)
#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 youll 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
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 lifes 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
2Des Moines Register Top Workplaces
Notice for all Applicants who are California residents under the California Privacy Rights Act. Please click here to review the policy.
Required Experience:
Senior IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
F&G offers life insurance and annuities to help you plan and protect your future. We value collaboration, authenticity, dynamics and empowerment.
