Data Integration Developer II

Data Integration Developer II Job Summary 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 Key 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 Experience and Qualifications Bachelors 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 ETLELT tool; experience with Americos data integration environment preferred Experience with data modeling concepts and curated dataset development for reporting and analytical use cases Technical Competencies ETLELT 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 Decision Making Authority 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 quality issues independently within approved boundaries Participates in decisions about coding standards and data handling practices; proposes enhancements but requires senior review before implementing changes that affect shared production environments Americo Values in Practice Accountability Owns the full delivery lifecycle for assigned pipelines from requirements through testing and production monitoring without requiring close oversight Excellence Produces well documented well tested integration solutions that downstream analytics teams can rely on without manual reconciliation or workarounds Continuous Improvement Proactively identifies performance issues or recurring data quality patterns in owned pipelines and implements improvements that reduce incidents or processing time Leveling Signals Independently translates a moderately complex business requirement into a reliable well documented pipeline solution without requiring senior engineer involvement in the design phase Consistently produces pipeline outputs that pass validation checks and are adopted into recurring reporting without material data quality follow up from analysts or business stakeholders Identifies a recurring performance or quality issue in owned work proposes a solution independently and implements the fix with standard review rather than waiting for the issue to escape #J-18808-Ljbffr Americo Financial Life and Annuity