Data Integration Engineer II — Pipelines & Analytics

Americo Financial Life and Annuity; Missouri; On-site; USD 75,000 - 110,000; Full time

Job summary

Americo Financial Life and Annuity in Missouri seeks a Data Integration Developer II to design, build, and maintain reliable data pipelines and analytical datasets for reporting and business operations across Americo.

This role translates business requirements into technically sound integration solutions, collaborating with partners to map sources, ensure data quality, and optimize performance while documenting lineage and data contracts.

Qualifications

• Bachelor's degree or equivalent hands-on experience in a related field.
• 3 years of professional experience building and maintaining batch or near real-time data pipelines.
• Proficient in SQL with complex joins, aggregations and performance optimization.

Responsibilities

• Design, build, and maintain batch and near real-time data pipelines in ETL tools and SQL.
• Translate business data needs into technical integration solutions across underwriting, policy administration, claims and finance.
• Document data sources, transformation rules and lineage; ensure data quality and integrity through validation checks.
• Collaborate with business partners to map sources to business concepts and validate outputs.
• Support testing, deployment, and issue resolution to minimize production impact.

Skills

SQL

Data pipelines

Data modeling

Data quality

Documentation

Problem solving

Education

Bachelor's degree in computer science or related field

Tools

Informatica PowerCenter

Job description

Americo Financial Life and Annuity in Missouri seeks a Data Integration Developer II to design, build, and maintain reliable data pipelines and analytical datasets for reporting and business operations across Americo.

This role translates business requirements into technically sound integration solutions, collaborating with partners to map sources, ensure data quality, and optimize performance while documenting lineage and data contracts.