Senior Data Modeling Engineer

A-CAP; New York (NY); On-site; USD 100,000 - 200,000; Full time

Benefits offered by this job

Employer-sponsored medical, dental, and vision insurance

Paid Life & AD&D Insurance

Safe Harbor 401(k) plan with employer match

Paid Vacation and Sick Leave

Job summary

A-CAP is looking for a highly motivated Senior Data Modeling Engineer in New York City. This role supports the analysis and management of complex financial data from various sources, ensuring data accuracy and completeness.

The ideal candidate will have at least 5 years of experience, proficiency in SQL, and knowledge of data ingestion processes. The position also offers competitive compensation and a comprehensive benefits package.

Qualifications

• 5+ years of experience in data engineering, analytics, or financial data management.
• Proven ability to collaborate effectively across teams.
• Strong analytical and investigative skills.

Responsibilities

• Manage and validate data files from various external partners.
• Identify and resolve data anomalies and reconciliation issues.
• Collaborate with cross-functional teams to translate business needs into data solutions.

Skills

Data ingestion & analysis

SQL proficiency

ETL processes

Analytical skills

Financial data management

Education

Bachelor's degree in Finance, Accounting, Information Systems, Mathematics

Tools

Python

SSIS

Alteryx

Snowflake

AWS

Azure

Job description

Senior Data Modeling Engineer

Employer: A-CAP Services LLC

Department: Financial Technology

Reports To: Chief Technology Officer

Location: Onsite in New York City

About the Company

A-CAP is a leading provider of capital and third-party asset management solutions. Through our synergistic platform of insurance carriers, reinsurers, and asset management businesses, A-CAP delivers tailored capital solutions to individuals, insurance companies, and small‑to‑medium‑sized businesses.

Backed by a leadership team and operational experts with deep expertise across insurance, reinsurance, and asset management sectors, A-CAP is committed to delivering meaningful results and adding value to our clients and capital partners. This commitment is demonstrated through the industry‑leading risk‑adjusted returns we achieve, and the innovative capital solutions we provide to meet the needs of a diverse range of partners.

• Capital Solutions
• Commercial Real Estate
• Third‑party Asset Management
• Private Credit
• Primary Insurance Carriers
• Accredited Reinsurers

About the Role

We are seeking a highly motivated and analytically driven Senior Data Modeling Engineer to join our team at the intersection of accounting, actuarial science, and technology. This role is critical to our data ecosystem, supporting the ingestion, validation, and analysis of complex financial and annuity data received from third‑party administrators (TPAs), banks, custodians, and other financial counterparties. The ideal candidate brings a rare blend of financial acumen, investigative curiosity, and technical skill—someone who can bridge the gap between business stakeholders and data systems.

What You Will Do

• Data Ingestion & Management – Receive, process, and manage data files from TPAs, banks, custodians, and other external financial partners, ensuring accuracy, completeness, and timeliness.
• Annuity & Accounting File Processing – Work extensively with annuity administration data and accounting files; understand their structure, content, and downstream implications.
• Data Investigation & Root Cause Analysis – Apply strong investigative skills to identify data anomalies, reconciliation breaks, and discrepancies; trace issues to their source and drive resolution.
• Cross‑Functional Collaboration – Serve as a key liaison between Accounting, Actuarial, and Technology teams, translating business requirements into data solutions and vice versa.
• SQL Querying & Analysis – Write and maintain SQL queries to extract, transform, and validate data; support ad hoc analysis requests from finance and actuarial teams.
• Data Quality & Controls – Establish and monitor data quality checks and controls; document data lineage and transformation logic.
• Reporting Support – Assist in the preparation of data feeds and summaries supporting financial statements, actuarial valuations, and regulatory reporting.
• Process Improvement – Identify opportunities to automate or streamline data workflows, reducing manual effort and error risk.

What You Will Need

• Bachelor's degree in Finance, Accounting, Information Systems, Mathematics, or a related field.
• Proven ability to collaborate effectively across cross‑functional teams, including Finance, Actuarial, Operations, and Technology.
• Strong analytical and investigative skills with the ability to identify data issues, determine root causes, and drive resolution.
• Experience with ETL processes, data pipelines, workflow automation tools, and cloud‑based data platforms (e.g., Python, SSIS, Alteryx, dbt, Snowflake, AWS, Azure).
• Experience managing and validating structured financial data from internal and external sources, including TPAs, custodians, banks, and other third‑party providers.
• Proficiency in SQL, including writing and optimizing queries using joins, aggregations, and data transformations.
• Familiarity with actuarial and insurance data concepts, including reserves, policy liabilities, and valuation data.
• Working knowledge of accounting principles, general ledger concepts, financial statements, and insurance regulatory reporting requirements (GAAP, Statutory, and NAIC).
• Experience within the insurance or financial services industry, including hands‑on exposure to annuity products, annuity administration data, and related business processes.
• 5+ years of experience in data engineering, data analytics, financial data management, or a related role.

Salary Transparency New York

Our salary ranges are determined by role, level, and location. For individuals hired to work in New York State, A-CAP is required by law to include a reasonable estimate of the compensation range for this role. A reasonable estimate of the current salary range is $100,000.00 – $200,000.00 USD annually.

Benefits

• Competitive compensation programs
• Employer‑sponsored medical, dental, and vision insurance
• Paid Life & AD&D Insurance (for employees and families)
• Paid Disability Insurance (STD + LTD)
• Paid Parental Leave
• Paid Vacation and Sick Leave
• Paid Holidays
• Voluntary Supplemental Insurance
• Safe Harbor 401(k) plan with employer match
• And other benefits and perks!

Position Type and Expected Hours of Work

This is a full‑time position. Days and hours of work are Monday through Friday, 9:00 a.m. to 6:00 p.m., 40 hours weekly, or as otherwise arranged with the manager of the department.

US Work Authorization Is Required

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.

EEO Statement

A-CAP is an Equal Opportunity Employer and does not discriminate in recruiting, hiring, promotion or any other personnel action based on the basis of race, ethnicity, national origin, color, sex, gender, gender identity or expression, sexual orientation, religion, age, disability, veteran status, or any other basis covered by appropriate law. We comply with the laws and regulations set forth in the Know Your Rights poster. All employment is decided on the basis of qualifications, merit, and business need. To request an accommodation, contact [e-mail] and we will make every effort to respond to your request within 48 business hours to work towards a positive solution.

Disclaimer

The above is intended to describe the general content of and requirements for the performance of this job. It should not be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.