Sr IT Solution Analyst

Pacific Life • Newport Beach, CA

1d

About The Position

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 our Newport Beach office. 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

Requirements

• 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

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level