Senior Data Engineer: Financial Data Pipelines & Automation

Amerilife Group, LLC; Philadelphia (Philadelphia County); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Benefits package

Job summary

AmeriLife is seeking a skilled Data Engineer to design and automate its internal data systems handling commission processing, AP workflows, and payroll reconciliation. You will transform spreadsheet-driven tasks into scalable digital pipelines, ensuring data accuracy and faster turnaround times across multiple carriers and formats.

Ideal candidates will have strong Python and SQL skills, Excel proficiency, and experience with cloud infrastructure (GCP).

Qualifications

• Proficiency in data engineering and automation (Python, SQL, Excel).
• Web application development and cloud infrastructure management (GCP).
• Deep knowledge of insurance commission structures, AP workflows, and payroll reconciliation.

Responsibilities

• Design and maintain automated systems for ingesting, validating, and processing carrier commission statements across multiple carriers and formats.
• Build and manage tools for generating, formatting, and encrypting agency payment files for distribution.
• Develop reconciliation systems that compare commission, payroll, and agency payment data to flag discrepancies before payment.
• Create and maintain configurable data mappings between carrier formats and internal standards.
• Manage agent and agency master data including NPN records, carrier IDs, and organizational hierarchies.
• Build secure, role-based tools for agent self-service access to compensation data.
• Architect and maintain cloud-hosted data infrastructure with automated backup, archival, and recovery.
• Identify operational bottlenecks and implement systematic, automated solutions.

Skills

Data engineering

Automation

Python

SQL

Excel

GCP

Education

Bachelor's degree in Computer Science or related field

Tools

GCP

Job description

AmeriLife is seeking a skilled Data Engineer to design and automate its internal data systems handling commission processing, AP workflows, and payroll reconciliation. You will transform spreadsheet-driven tasks into scalable digital pipelines, ensuring data accuracy and faster turnaround times across multiple carriers and formats.

Ideal candidates will have strong Python and SQL skills, Excel proficiency, and experience with cloud infrastructure (GCP).