Lead Analytics Engineer: Finance & Actuarial Data

Symetra; United States; Hybrid; USD 129,000 - 215,000; Full time

Benefits offered by this job

Flexible full-time or hybrid telecommu

401(k) plan with company matching up 6

Paid time away including vacation and1

Company matching philanthropic giving

Symetra Benefits Overview

Job summary

Symetra seeks a Lead Analytics Engineer to model data and deliver clean, well-documented datasets for Finance, Investment Management, and Actuarial stakeholders. You will lead migration to a modern cloud data platform, mentor junior engineers, and shape data products across the analytics community.

You will design scalable data models and ETL/ELT pipelines, collaborating with Finance, IT, and Analytics to translate complex requirements into robust data solutions.

Qualifications

• Experience designing data models, warehouses, and cloud data platforms for financial datasets.
• Strong SQL and Python with data governance and quality focus.
• Ability to mentor junior engineers and influence technical direction.

Responsibilities

• Design, build, and maintain scalable data models, curated datasets, and data marts that deliver trusted, business-ready data for Finance, Investment Management, and Actuarial teams.
• Serve as the subject matter expert for investment and actuarial data domains, including holdings, transactions, security master data, valuations, performance, and attribution data.
• Lead the migration and transformation of investment data from legacy platforms to a modern cloud-based data ecosystem, ensuring data quality, consistency, and accessibility.
• Develop and optimize cloud-native data architectures that enable efficient storage, integration, governance, and analysis of critical financial and investment data assets.
• Build robust ETL/ELT pipelines that integrate structured and unstructured data from multiple internal and external sources while ensuring scalability, reliability, and performance.
• Partner closely with Finance, Investment Management, Actuarial, IT, and Analytics teams to understand business requirements and translate them into scalable data solutions.
• Identify opportunities to create new data products, analytical capabilities, and reporting solutions that improve business decision-making and support strategic objectives.
• Apply advanced SQL and Python skills to design data transformations, automate processes, improve data quality, and optimize analytics workflows.
• Establish and promote data engineering best practices, including data modeling standards, testing frameworks, documentation, version control, lineage tracking, and governance processes.
• Mentor and support analytics engineers by providing technical guidance, code reviews, architectural recommendations, and development coaching.
• Optimize data warehouse performance, schema design, access controls, and pipeline orchestration across modern cloud platforms such as Snowflake, Databricks, Redshift, or BigQuery.
• Stay current on emerging technologies, tools, and industry trends in data engineering, cloud platforms, investment analytics, and insurance data management.

Skills

SQL

Python

Data modeling

ETL/ELT

Cloud data architecture

Mentoring

Stakeholder collaboration

Education

Bachelor’s degree in Computer Science, Mathematics, Statistics, or related field

Tools

Snowflake

Databricks

Redshift

BigQuery

dbt

SQLMesh

Coalesce

Dataform

Dagster

Airflow

Prefect

Azure Data Factory

Job description

Symetra seeks a Lead Analytics Engineer to model data and deliver clean, well-documented datasets for Finance, Investment Management, and Actuarial stakeholders. You will lead migration to a modern cloud data platform, mentor junior engineers, and shape data products across the analytics community.

You will design scalable data models and ETL/ELT pipelines, collaborating with Finance, IT, and Analytics to translate complex requirements into robust data solutions.