Senior Data Modeling Engineer
Job Location:
Monthly Salary:
Posted on:
Vacancies:
Job Summary
EMPLOYER: A-CAP Services LLC
DEPARTMENT: Financial Technology
REPORTS TO: Chief Technology Officer
LOCATION: Onsite in Miami (Brickell)
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-CAPs Core Business Includes:
- Capital Solutions
- Commercial Real Estate
- Third-party Asset Management
- Private Credit
- Primary Insurance Carriers
- Accredited Reinsurers
We areseekinga highly motivated and analytically driven Senior DataModelingEngineer 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 technicalskill 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 toidentifydata anomalies reconciliation breaks and discrepancies; trace issues to their source and drive resolution
Cross-Functional Collaboration Serve as a key liaison betweenAccounting Actuarial andTechnologyteams translating business requirements into data solutions and vice versa
SQL Querying & Analysis Write andmaintainSQL queries to extract transform andvalidatedata; 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
- Bachelors degree in Finance Accounting Information Systems Mathematics ora relatedfield.
- Proven ability to collaborate effectively across cross-functional teams including Finance Actuarial Operations and Technology.
- Strong analytical and investigative skills with the ability toidentifydata issuesdetermineroot causes and drive resolution.
- Experience with ETL processes data pipelines workflow automation tools and cloud-based data platforms (e.g. Python SSIS Alteryxdbt Snowflake AWS Azure).
- Experience managing andvalidatingstructured financial data from internal and external sources including TPAs custodians banks and other third-party providers.
- Proficiencyin SQL including writing andoptimizingqueries 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.
WHO WE ARE:
BENEFITS:
A-CAP works hard to create a positive and supportive environment. Thats why we offer great benefits to safeguard the health and well-being of our employees. Our comprehensive benefits package includes:
- 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 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 managements 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.
Required Experience:
Senior IC
