Support the design and build next-generation data solutions for ILI FAC using AWS Redshift
Collaborate across teams to integrate financial, investment, pricing, and assumptions data into AWS Redshift, and connect this data to Power BI and Anaplan to automate reporting and analytics
Develop and maintain data pipelines and quality controls within PowerBI and AWS Redshift
Document technical designs, workflows, user guides, and maintain a comprehensive data dictionary to support sustainable operations
Stay up-to-date with cloud and data technology trends and promote best practices in finance and actuarial data management

Requirements

Bachelor’s degree in Actuarial Science, Finance, Mathematics, Statistics, Computer Science, or related field
Hands-on experience managing large finance or actuarial datasets, with proficiency in AWS Redshift
Ability to translate business requirements into robust, scalable data solutions
Strong analytical and problem-solving skills, with attention to data quality and controls
Excellent collaboration and communication skills; comfort working with cross-functional teams in a dynamic environment
Growth mindset and curiosity about emerging data technologies and business innovation
Advanced experience with AWS services (Redshift, S3, Glue) and integrating data with other platforms is a plus
Experience building Power BI dashboards or developing Anaplan models for business or actuarial applications is a plus
Involvement in data architecture, automation, or analytics projects spanning finance and actuarial domains is a plus

Benefits

Medical, dental, vision, life insurance, disability insurance
Paid Time Off (PTO)
401(k) plan with company match (up to 4%)
Company-funded pension plan
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs
Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs
Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service
Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

AWS Redshiftdata pipelinesdata quality controlsPower BIAnaplandata solutionsdata architectureautomationanalyticsdata management

Soft Skills

analytical skillsproblem-solving skillsattention to detailcollaborationcommunication skillsgrowth mindsetcuriositytranslating business requirements