Data Integration Developer II

Exists to design, build, and maintain reliable data pipelines and analytical datasets that transform insurance and annuity data into trusted assets for reporting, analytics, and business operations across Americo. This role operates with growing independence, translating business requirements into technically sound integration solutions.

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.

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 Power Center or equivalent ETL/ELT tool; experience with Americo's data integration environment preferred.

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

Selects implementation approach and data modeling strategy for assigned pipelines and datasets; escalates architectural design questions to a senior engineer or Data Architect.

Signs off on assigned pipeline and dataset outputs before releasing to downstream consumers; resolves routine data…