Lead Analytics Engineer — Actuarial, Finance & Investments
Summary
Lead Analytics Engineer designing and maintaining scalable data models, curated datasets, and cloud-native ETL/ELT pipelines on Snowflake/Databricks/Redshift/BigQuery to support Finance, Investment Management, and Actuarial teams at an insurance/financial-services company.
About the role
What you will do
- 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.
Who You Are
- You are a strategic data professional who combines deep technical expertise with strong business acumen to deliver scalable analytics solutions that drive meaningful business outcomes.
- You have extensive experience designing data models, data warehouses, and cloud-based data platforms that support complex financial, investment, and actuarial reporting needs.
- You are a collaborative partner who excels at working across technical and business teams, translating complex requirements into practical, high-quality data solutions.
- You are a technical leader and mentor who enjoys developing others, establishing best practices, and elevating the capabilities of the broader analytics and engineering community.
- You are a curious problem solver who thrives in complex environments, proactively identifying opportunities to improve data quality, streamline processes, and unlock new analytical insights.
Nice to Haves
- Bachelor’s degree in computer science, Data Analytics, Information Systems, Mathematics, Finance, Actuarial Science, or a related field, or equivalent experience.
- 8-10 years of experience in analytics engineering, data engineering, business intelligence, or related data-focused roles.
- Advanced expertise in SQL, Python, data modeling, ETL/ELT development, and cloud data architecture.
- Experience with modern cloud data platforms such as Snowflake, Databricks, BigQuery, or Amazon Redshift.
- Proficiency with analytics engineering and transformation tools such as dbt, SQLMesh, Coalesce, or Dataform.
- Experience with workflow orchestration and pipeline management tools such as Dagster, Airflow, Prefect, or Azure Data Factory.
- Strong understanding of investment management, investment accounting, insurance asset data, performance measurement, and actuarial analytics.
- Demonstrated success leading complex data initiatives, influencing technical direction, and delivering enterprise-scale analytics solutions.
Why Work at Symetra
What we offer you
Benefits and Perks
- Flexible full-time or hybrid telecommuting arrangements
- Plan for your future with our 401(k) plan and take advantage of immediate vesting and company matching up to 6%
- Paid time away including vacation and sick time, flex days and ten paid holidays
- Give back to your community and double your impact through our company matching
- Want more details? Check out our Symetra Benefits Overview
Compensation
- Minimum Internet Speed: 100 Mbps download and 20 Mbps upload, in alignment with the FCC's definition of "broadband."
- Internet Type: Fiber, Cable (e.g., Comcast, Spectrum), or DSL.
- Not Permissible: Satellite (e.g., Starlink), cellular broadband (hotspot or otherwise), any other wireless technology, or wired dial-up.
Identity Verification
- Disqualification from the recruitment process
- Withdrawal of a job offer
- Termination of employment and other criminal and/or civil remedies, if fraud is discovered