Design, ingest, validate, and manage complex financial and annuity data from external partners. Build and maintain ETL pipelines, SQL queries, and data quality controls; investigate data anomalies; collaborate with Accounting, Actuarial, and Technology; support reporting and process automation to improve financial and regulatory workflows.
JOB TITLE: 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.
A-CAP's Core Business Includes:
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:
We know our people are our number one asset and we put a premium on hiring and retaining the best talent. For that reason, we reward our employees with a competitive compensation package.
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. This range is specific to the locations listed above and considers the wide range of factors considered in making compensation decisions, such as job-related skills, experience, and relevant education or training. A reasonable estimate of the current salary range is $100,000.00 - $200,000.00 USD annually.
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.
A-CAP's Core Business Includes:
- Capital Solutions
- Commercial Real Estate
- Third-party Asset Management
- Private Credit
- Primary Insurance Carriers
- Accredited Reinsurers
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
- 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.
We know our people are our number one asset and we put a premium on hiring and retaining the best talent. For that reason, we reward our employees with a competitive compensation package.
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. This range is specific to the locations listed above and considers the wide range of factors considered in making compensation decisions, such as job-related skills, experience, and relevant education or training. A reasonable estimate of the current salary range is $100,000.00 - $200,000.00 USD annually.
Similar Jobs
Artificial Intelligence • Software
Lead the unification of large heterogeneous datasets for generative audio models by creating robust systems for data ingestion, deduplication, and reconciliation. Collaborate with ML researchers and develop scalable entity-resolution solutions while tracking data quality metrics.
Top Skills:
Apache BeamBigQueryFlinkGoogle DataflowPythonRaySparkTfrecords
13 Minutes Ago
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
As a Senior Associate in Cyber Strategy, Risk & Compliance, you will analyze complex cybersecurity problems, mentor junior team members, and develop AI-driven cybersecurity solutions while collaborating with clients and stakeholders.
Top Skills:
Ai/Ml FrameworksAWSCi/CdDockerGCPKubernetesPython
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Provide strategic guidance to clients by analyzing market trends and business performance, developing and implementing operational improvement plans, leveraging data analytics and performance management, collaborating with cross-functional teams, and building client relationships to drive growth and efficiency.
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
