Senior Data Engineer

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

Our Company

Explore how you can contribute at AmeriLife. For over 50 years, AmeriLife has been a leader in the development, marketing and distribution of annuity, life and health insurance solutions for those planning for and living in retirement. Associates get satisfaction from knowing they provide agents, marketers and carrier partners the support needed to succeed in a rapidly evolving industry.

Job Summary

Leads the design, development, and maintenance of internal data systems that automate the accounting department's commission processing, accounts payable, and payroll reconciliation workflows. Transforms manual, spreadsheet-driven operations into reliable digital pipelines — improving data accuracy, reducing turnaround time, and establishing scalable infrastructure for the organization's financial operations.

Job Description

Key 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

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
• Experience designing systems for large, multi-source financial datasets requiring normalization, validation, and audit compliance

What AmeriLife Offers

• A comprehensive benefits package that includes PTO, medical, dental, vision, retirement savings, disability insurance, and life insurance.

Equal Employment Opportunity Statement

We are an Equal Opportunity Employer and value diversity at all levels of the organization. All employment decisions are made without regard to race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), sexual orientation, gender identity or expression, age, national origin, ancestry, disability, genetic information, marital status, veteran or military status, or any other protected characteristic under applicable federal, state, or local law. We are committed to providing an inclusive, equitable, and respectful workplace where all employees can thrive.

Americans with Disabilities Act (ADA) Statement

We are committed to full compliance with the Americans with Disabilities Act (ADA) and all applicable state and local disability laws. Reasonable accommodations are available to qualified applicants and employees with disabilities throughout the application and employment process. Requests for accommodation will be handled confidentially. If you require assistance or accommodation during the application process, please contact us at [e-mail].

Pay Transparency Statement

We are committed to pay transparency and equity, in accordance with applicable federal, state, and local laws. Compensation for this role will be determined based on skills, qualifications, experience, and market factors. Where required by law, the pay range for this position will be disclosed in the job posting or provided upon request. Additional compensation information, such as benefits, bonuses, and commissions, will be provided as required by law. We do not discriminate or retaliate against employees or applicants for inquiring about, discussing, or disclosing their pay or the pay of another employee or applicant, as protected under applicable law. Pay ranges are available upon request.

Background Screening Statement

Employment offers are contingent upon the successful completion of a background screening, which may include employment verification, education verification, criminal history check, and other job-related inquiries, as permitted by law. All screenings are conducted in accordance with applicable federal, state, and local laws, and information collected will be kept confidential. If any adverse decision is made based on the results, applicants will be notified and given an opportunity to respond.

About Us

Since 1971, AmeriLife has served the needs of its clients. Today, we are a national leader in the development, marketing and distribution of annuity, life and health insurance solutions, with more than 1,000 associates across the country. AmeriLife partners with leading carriers to support consumers’ financial-wellness goals.

Our Mission

AmeriLife offers insurance and retirement solutions to provide peace of mind and help people live longer, healthier lives.

Our Values

• Honesty – We deal truthfully with all of our clients
• Integrity – We always do what is right for our clients
• Accountability – We put our clients’ needs first by taking take ownership of our actions
• Excellence – We do more than our jobs by going the extra mile for our clients
• Courage – We stand up for what is right