Sr IT Solution Analyst

Pacific Life • Newport Beach, CA

8h

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