← Back to jobsJob ID col-cmv8g5mxc077roz01cjbz7a07

Americo Financial Life and AnnuityPosted 30+ days ago

Data Integration Developer II

Full-time
On-site
3+ years
Competitive
Posted 30+ days ago

Americo Financial Life and Annuity is hiring a Data Integration Developer II to design, build, and maintain data pipelines and analytical datasets using insurance and annuity data. The role translates business requirements into reliable integration solutions and supports data quality, performance, documentation, testing, and production operations.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Develop reliable data pipelines: Design, build, and maintain batch and near-real-time data pipelines in ETL Tool and SQL that ingest, transform, and deliver insurance and annuity data accurately and efficiently for reporting, analytics, and downstream applications
  • Translate business data needs into technical solutions: Work directly with business partners and analysts to clarify requirements, map source data to business concepts, and implement integration solutions that support underwriting, policy administration, claims, finance, and in-force management
  • Model and prepare data for analysis: Create and maintain curated datasets, data models, and transformation logic that improve data usability, consistency, and performance for dashboards, operational reporting, and analytical use cases
  • Ensure data quality and integrity: Implement validation checks, reconcile outputs, investigate anomalies, and resolve data issues to ensure trusted data assets and accurate information across key insurance business processes
  • Optimize data processes for performance: Identify and implement improvements to data jobs, queries, and workflows to reduce processing time, improve reliability, and support scalable delivery of data products
  • Document technical solutions: Produce and maintain clear documentation for data sources, transformation rules, job schedules, and business definitions so solutions are auditable, supportable, and understandable by peers
  • Support testing, deployment, and issue resolution: Execute unit and integration testing, monitor production processes, and troubleshoot moderately complex data defects to minimize disruption to business operations
  • Contribute to team standards: Apply established development practices, participate in peer reviews, and recommend practical improvements to tools, processes, and data management approaches
  • Implement data quality and contract controls: Implement schema validation, business rule validation, data quality controls, and approved data contract requirements for assigned data assets

Qualifications

  • Bachelor's degree in computer science, data engineering, information systems, or a related field, or equivalent hands-on experience
  • 3+ years of professional experience developing and maintaining batch or near-real-time data pipelines, including production implementation of transformations, validations, and error resolution
  • Proficient in SQL, including complex joins, aggregation, and query performance optimization
  • Proficient in Informatica PowerCenter or equivalent ETL/ELT tool
  • Experience with data modeling concepts and curated dataset development for reporting and analytical use cases
  • ETL/ELT pipeline engineering: Proficiently designs, builds, and maintains batch and near-real-time ETL Tool workflows including complex transformations, error handling, restartability, and scheduling; independently resolves moderately complex pipeline issues
  • SQL and data modeling: Writes and optimizes SQL for complex data transformations and analytical use cases; builds and maintains dimensional and relational data models that serve reporting and analytics across insurance domains
  • Data quality and reconciliation: Implements validation rules, reconciliation checks, and monitoring logic for pipeline outputs; investigates and documents anomalies affecting financial, actuarial, and operational data
  • Documentation and lineage: Maintains complete source-to-target mappings, transformation logic, and lineage documentation for owned assets; applies team standards consistently across all deliverables
  • Data observability: understand pipeline monitoring, operational alerting, data reconciliation, schema validation, and basic observability practices used to maintain production data assets

Preferred

  • experience with Americo's data integration environment
  • Americo Data Integration Experience

Required skills

SQLInformatica PowerCenterETL/ELT Pipeline EngineeringData ModelingData ObservabilitySchema ValidationInsurance Data

Full job description

Americo Financial Life and Annuity is hiring a Data Integration Developer II to design, build, and maintain data pipelines and analytical datasets using insurance and annuity data. The role translates business requirements into reliable integration solutions and supports data quality, performance, documentation, testing, and production operations.

Responsibilities

  • Develop reliable data pipelines: Design, build, and maintain batch and near-real-time data pipelines in ETL Tool and SQL that ingest, transform, and deliver insurance and annuity data accurately and efficiently for reporting, analytics, and downstream applications
  • Translate business data needs into technical solutions: Work directly with business partners and analysts to clarify requirements, map source data to business concepts, and implement integration solutions that support underwriting, policy administration, claims, finance, and in-force management
  • Model and prepare data for analysis: Create and maintain curated datasets, data models, and transformation logic that improve data usability, consistency, and performance for dashboards, operational reporting, and analytical use cases
  • Ensure data quality and integrity: Implement validation checks, reconcile outputs, investigate anomalies, and resolve data issues to ensure trusted data assets and accurate information across key insurance business processes
  • Optimize data processes for performance: Identify and implement improvements to data jobs, queries, and workflows to reduce processing time, improve reliability, and support scalable delivery of data products
  • Document technical solutions: Produce and maintain clear documentation for data sources, transformation rules, job schedules, and business definitions so solutions are auditable, supportable, and understandable by peers
  • Support testing, deployment, and issue resolution: Execute unit and integration testing, monitor production processes, and troubleshoot moderately complex data defects to minimize disruption to business operations
  • Contribute to team standards: Apply established development practices, participate in peer reviews, and recommend practical improvements to tools, processes, and data management approaches
  • Implement data quality and contract controls: Implement schema validation, business rule validation, data quality controls, and approved data contract requirements for assigned data assets

Preferred

  • experience with Americo's data integration environment
  • Americo Data Integration Experience

Company

  • Life insurance and annuity products
  • Kansas City, Missouri, USA
  • http://americo.com/
  • Founded in 1946
  • 201-500 employees

Qualifications

  • Bachelor's degree in computer science, data engineering, information systems, or a related field, or equivalent hands-on experience
  • 3+ years of professional experience developing and maintaining batch or near-real-time data pipelines, including production implementation of transformations, validations, and error resolution
  • Proficient in SQL, including complex joins, aggregation, and query performance optimization
  • Proficient in Informatica PowerCenter or equivalent ETL/ELT tool
  • Experience with data modeling concepts and curated dataset development for reporting and analytical use cases
  • ETL/ELT pipeline engineering: Proficiently designs, builds, and maintains batch and near-real-time ETL Tool workflows including complex transformations, error handling, restartability, and scheduling; independently resolves moderately complex pipeline issues
  • SQL and data modeling: Writes and optimizes SQL for complex data transformations and analytical use cases; builds and maintains dimensional and relational data models that serve reporting and analytics across insurance domains
  • Data quality and reconciliation: Implements validation rules, reconciliation checks, and monitoring logic for pipeline outputs; investigates and documents anomalies affecting financial, actuarial, and operational data
  • Documentation and lineage: Maintains complete source-to-target mappings, transformation logic, and lineage documentation for owned assets; applies team standards consistently across all deliverables
  • Data observability: understand pipeline monitoring, operational alerting, data reconciliation, schema validation, and basic observability practices used to maintain production data assets
  • Experience with Americo's data integration environment
  • 3+ years of professional experience developing and maintaining batch or near-real-time data pipelines, including production implementation of transformations, validations, and error resolution.

Required skills

  • SQL, Informatica PowerCenter, ETL/ELT Pipeline Engineering, Data Modeling, Data Quality Validation and Reconciliation, Data Observability, Schema Validation, Insurance Data

Preferred skills

  • experience with Americo's data integration environment

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 14, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Americo Financial Life and Annuity

Information Technology & AI

Life insurance and annuity products

  • Kansas City, Missouri, USA
  • Information Technology & AI
  • 201-500 employees
  • Founded 1946
  • americo.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Kansas City

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData ModelingRemote

Coinbase

1d ago

New

Senior Software Engineer - Data Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer to build and operate systems that centralize internal and third-party data.

Why similarSame roleData ObservabilityRemote

The Walt Disney Company

1d ago

New

Data Engineer I

Full-timeOn-siteSanta Monica, CA$89K – $119K/yr

Disney Entertainment & Sports LLC is hiring a Data Engineer I for its Commerce Data Solutions team. The role designs and builds data pipelines to measure subscriber movements and metrics, supporting analytics, data science, and operations through real-time…

Why similarSame roleData ModelingSQL

Get new Data Engineer jobs in Kansas City by email

Create job alert

Data Integration Developer II

Americo Financial Life and Annuity · Competitive

Apply via Ethic Leaf