Sr IT Solutions Analyst

Job Description:

Providing for loved ones, planning rewarding retirements, saving enough for whatever lies ahead - our policyholders count on us to be there when it matters most. It's a big ask, but it's one that we have the power to deliver when we work together. We collaborate and innovate - pushing one another to transform not just Pacific Life, but the entire industry for the better. Why? Because it's the right thing to do. Pacific Life is more than a job, it's a career with purpose. It's a career where you have the support, balance, and resources to make a positive impact on the future - including your own.

We're actively seeking a talented Sr IT Solutions Analyst to join our Actuarial Data Team in Newport Beach, CA.

* This role is on-site.

How you'll help move us forward:

• Gather, analyze, and document business requirements from actuarial and reinsurance stakeholders to develop effective data solutions
• Use SQL to analyze data, validate requirements, and support business reporting needs
• Lead requirement gathering sessions and ticket refinement meetings, translating business needs into clear technical requirements
• Develop comprehensive acceptance criteria and test plans to ensure quality deliverables
• Coordinate development requests through the testing phase and validate implementations against requirements
• Implement and monitor data quality checks within our data pipelines
• Create and maintain system documentation, user guides, and process documentation
• Collaborate with cross-functional teams to implement system enhancements and process improvements
• Identify opportunities to streamline workflows and increase operational efficiency through data analysis
• Serve as a liaison between technical teams and business users, translating requirements in both directions

The experience you bring:

• Bachelor's degree in Business, Information Systems, Computer Science, or related field with 3+ years of experience in business or systems analysis
• Strong SQL skills with experience writing complex queries
• Advanced Excel proficiency including pivot tables, complex formulas, macros, and data validation
• Experience with data analysis, reporting tools, and translating business requirements into technical specifications
• Experience writing detailed acceptance criteria and test plans for data implementations
• Knowledge of data quality concepts and implementation approaches
• Technical documentation experience for both technical and non-technical audiences
• Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders
• Strong problem-solving abilities and attention to detail

What makes you stand out:

• Knowledge of or experience in insurance, actuarial, or reinsurance domains
• Experience with Snowflake, DBT, AWS, and/or Control-M
• Python, R, or other programming language skills for data analysis and testing
• Experience with modern data pipeline architectures and ETL/ELT processes
• Agile methodology experience, particularly in refinement and sprint planning activities
• Project management experience or certification (PMP, Agile, Scrum)
• Experience with data modeling and database design principles
• Previous experience working with cloud-based data platforms

You can be who you are.

People come first here. We're committed to a an inclusive workforce. Learn more about how we create a welcoming work environment at www.pacificlife.com. What's life like at Pacific Life? Visit Instagram.com/lifeatpacificlife.

Benefits start Day 1.

Your wellbeing is important. We're committed to providing flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we've got you covered.

* Prioritization of your health and well-being including Medical, Dental, Vision, and a Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents
* Generous paid time off options including Paid Time Off, Holiday Schedules, and Financial Planning Time Off
* Paid Parental Leave as well as an Adoption Assistance Program
* Competitive 401k savings plan with company match and an additional contribution regardless of participation.

Base Pay Range:

The base pay range noted represents the company's good faith minimum and maximum range for this role at the time of posting. The actual compensation offered to a candidate will be dependent upon several factors, including but not limited to experience, qualifications and geographic location. Also, most employees are eligible for additional incentive pay.

Your Benefits Start Day 1

Your wellbeing is important to Pacific Life, and we're committed to providing you with flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we've got you covered.

• Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents

• Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off

• Paid Parental Leave as well as an Adoption Assistance Program

• Competitive 401k savings plan with company match and an additional contribution regardless of participation

EEO Statement:

Pacific Life Insurance Company is an Equal Opportunity /Affirmative Action Employer, M/F/D/V. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at Pacific Life Insurance Company.