Data Integration Engineer II - Pipelines & Analytics

Americo Financial Life and Annuity; Kansas City (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Americo Financial Life and Annuity seeks a data engineer to design, build, and maintain reliable data pipelines that convert insurance and annuity data into trusted assets for reporting, analytics, and business operations.

You will translate business requirements into technically sound integration solutions, model data for dashboards, ensure data quality, and optimize workflows to improve performance in a production environment.

Qualifications

• Bachelor's degree or equivalent hands-on experience.
• Proficient in designing, implementing, and debugging ETL/ELT pipelines.
• Experience with data modeling for reporting and analytics.
• Knowledge of data quality and reconciliation concepts.

Responsibilities

• Design, build, and maintain batch and near-real-time data pipelines for insurance and annuity data.
• Translate business requirements into technical integration solutions with partners and analysts.
• Model and prepare data for dashboards and analytical use cases.
• Ensure data quality, perform validation, and investigate anomalies.
• Optimize data jobs, queries, and workflows for performance and scalability.
• Document data sources, transformations, and lineage for auditable assets.
• Support testing, deployment, and issue resolution in production environments.
• Contribute to team standards and peer reviews for data solutions.
• Implement data quality and data contract controls for owned assets.

Skills

SQL

ETL/ELT

Data Modeling

Data Quality

Data Observability

Documentation

Collaboration

Education

Bachelor's degree in computer science, data engineering, information systems, or related field

Tools

Informatica PowerCenter

ETL Tool

Job description

Americo Financial Life and Annuity seeks a data engineer to design, build, and maintain reliable data pipelines that convert insurance and annuity data into trusted assets for reporting, analytics, and business operations.

You will translate business requirements into technically sound integration solutions, model data for dashboards, ensure data quality, and optimize workflows to improve performance in a production environment.