About the role
Sr. Data Engineer – Reinsurance Administration System & Financial Reporting
Summary
This role is a hybrid software and data engineer who assists in the development of our reinsurance administration system and the financial reporting layer that relies upon it. The work centers on building pipelines, writing production code, modeling data, and working with business stakeholders to turn their needs into reliable, well-tested solutions.
The engineer works closely with actuaries, accountants, architects, and data professionals. They conform to shared patterns and standards and extend the existing approach where necessary, rather than building one-off solutions.
Insurance and reinsurance industry experience is preferred.
Responsibilities
Requirements, Specifications & Data Design (45%)
- Deliver on large and complex reinsurance and financial reporting data needs by leading requirements and technical specifications that drive resulting data designs.
- Partner daily with actuaries and accountants to translate actuarial requirements, treaty terms, accounting rules, and business rules into technical specifications and working code, including ceded premium, claims, reserves, and treaty and cession logic. Take direction from the technical actuary.
- Work with architects to align data designs, integration approaches, and data management systems with solution and enterprise architecture.
- Design and build the financial reporting layer, including curated, reconciled datasets and models that support ceded and assumed reinsurance accounting, financial close, and management, regulatory, and reinsurer reporting.
- Develop the logic that maps reinsurance transactions and balances to general ledger accounts and produces GL-ready journal entries and feeds, in coordination with accounting partners.
- Participate in data design, requirements, walkthroughs, and reviews; design and document system integration and configuration as required.
- Participate in and approve code reviews with other engineers and data professionals; merge production-ready code for deployment.
- Lead root cause analysis for production issues, including data discrepancies in reinsurance calculations, financial reporting, and GL reconciliations.
Data Models, Integration & CI/CD (10%)
- Implement and advance data models and configurations that integrate data from source systems and environments, including upstream and downstream reinsurance, actuarial, and GL systems, using dbt and Snowflake.
- Build, schedule, and monitor data pipelines using Dagster, including asset definitions, dependencies, sensors, and alerting for period-end and recurring processing.
- Design, configure, and support automated builds and deployments using ADO pipelines, promoting CI/CD and meeting team automated build standards.
- Apply caching and CQRS-style patterns where they improve reporting performance and reliability.
- Define and perform unit testing and data quality testing (e.g., dbt tests); support functional, regression, and integration/interface testing, including reconciliations, balance checks, and sub-ledger-to-GL tie-outs with accounting partners.
Research & Innovation (5%)
- Research and recommend improvements to the reinsurance and financial data platform, such as pipeline automation, reconciliation, data quality, and developer tooling, and implement them in line with team standards.
Tools, Frameworks, APIs & Dashboards (20%)
- Build production-quality application code, tools, frameworks, APIs, and dashboards in AWS (e.g., services, automation, and data movement) to support telemetry, monitoring, and reporting.
- Focus on improving data security, accessibility, reliability, scalability, efficiency, and quality.
- Analyze performance metrics, identify inefficiencies, and optimize code, pipeline, query, and model performance, including Snowflake compute, dbt model efficiency, and Dagster run performance.
Data Governance (20%)
- Lead data governance and guide all data schema and configuration changes for the reinsurance and financial reporting platform, in partnership with architects and other data professionals.
- Implement information security, disaster recovery, performance, and capacity standards, with attention to the controls, auditability, data lineage, and period-end processing expected of financial and actuarial systems.
- Provide technical guidance and mentoring to less-experienced engineers.
Required Technical Experience
- Hands-on experience with AWS, Azure DevOps (ADO), dbt, Snowflake, and Dagster (or a comparable orchestration tool with the ability to ramp up quickly).
- Strong SQL and a modern programming language (e.g., Python), with the ability to write production-quality application code as well as data transformations.
- Experience building layered data models (e.g., staging, intermediate, and reporting layers) for analytical or financial reporting.
- Experience with data pipeline orchestration, data quality testing, and performance tuning in a cloud data warehouse.
- Solid software engineering fundamentals: CI/CD, version control, code review, and automated testing practices.
- Ability to collaborate effectively with actuaries, accountants, architects, and data professionals, and to take direction from a technical actuary in a business-driven, requirements-heavy environment.
Preferred Experience
- Insurance and reinsurance industry experience, ideally in reinsurance administration, ceded and assumed reinsurance accounting, or actuarial systems.
- Understanding of general ledger systems, including chart of accounts, journal entries, sub-ledger to GL relationships, and period-end close processes.
- Familiarity with treaty structures (e.g., coinsurance, YRT, modco) and bordereaux or reinsurer reporting.
- Experience working with actuaries, accountants, or finance teams on calculation, valuation, reconciliation, or financial reporting systems.
Specialty Education Required
College degree or equivalent work experience.
Designations and/or Certifications Required
Professional certifications or designations appropriate and relevant for this role (e.g., AWS, Snowflake, or dbt certifications).
Licensing Required
None.
Typical Years of Experience
8–10 years of cumulative, relevant experience.
Impact
Decisions have significant impact to the department or organization. May be responsible for reviewing the work product of others. Accountable to the department and organization; may have significant financial impact to the organization given the role of reinsurance calculations and financial reporting in the general ledger and external reporting. Extensive latitude for independent judgment.
Job Complexity
Performs complex and varied work that requires extensive experience and knowledge of particular specialties or areas of expertise within the department. Develops integrated solutions to resolve highly complex technical and business issues across both data and software domains.
Skills and Knowledge
Experienced professional with considerable and extensive skills and knowledge for the role. Possesses a wide range of experience and uses professional practices to resolve complex issues in creative and effective ways. Is a recognized expert within the department or division. Work requires in-depth knowledge of the field as well as the ability to evaluate external factors and their impact on strategic goals.
Reporting Structure
Works independently with guidance in only the most complex situations. Works closely with actuaries, accountants, architects, and data professionals, and takes technical and business direction from a technical actuary on reinsurance requirements. Assists less-experienced peers and provides technical guidance. May have some mentor and lead responsibilities.
Contact with Others
Works closely and regularly with actuaries, accountants, architects, and data professionals. Inside contact with IT leadership and management, IT staff, finance partners, business executives, and process owners. Has outside contact with consultants, service providers, vendors, reinsurers, and industry peers. Models an inclusive team culture and Symetra Core Values.