Sr IT Solution 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. Its a big ask, but its 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 its the right thing to do. Pacific Life is more than a job, its a career with purpose. Its a career where you have the support, balance, and resources to make a positive impact on the future including your own. Were actively seeking a talented Sr IT Solutions Analyst to join our Actuarial Data Team in our Newport Beach office. How youll 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. Were committed to a diverse, equitable and inclusive workforce. Learn more about how we create a welcoming work environment through Diversity, Equity, and Inclusion at www.pacificlife.com. Whats life like at Pacific Life? Visit Instagram.com/lifeatpacificlife. Benefits start Day 1. Your wellbeing is important. Were 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, weve 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 companys 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. $113,490.00 - $138,710.00 Your Benefits Start Day 1 Your wellbeing is important to Pacific Life, and were 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, weve 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 You Can Be Who You Are We are committed to a culture of diversity and inclusion that embraces the authenticity of all employees, partners and communities. We support all employees to thrive and achieve their fullest potential. Whats life like at Pacific Life? Visit Instagram.com/lifeatpacificlife 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. Were over 150 years old, but theres more to us than heritage. Were ambitious. Were committed to building a better future for our organization, our employees, our customers, and our communities and we have the experience, resources, and financial strength to make it happen. Were investing in innovation. Were honing our expertise. Were empowering our people: growing digital skills and fostering the disruptive thinking we need to give us the edge in an increasingly competitive global marketplace. Have ambitions of your own? Lets achieve them together. At Pacific Life, we believe that success comes down to our people. Thats why were committed to embracing a flexible, diverse, and inclusive workplace where you can be your best self and do your best work. Our people-first culture creates a sense of belonging and prioritizes employee wellbeing, empowering you to achieve your full potential through our holistic health benefits, flexible working options, and a vibrant community of people working towards a shared purpose. You can connect with colleagues through employee connections groups, sharing your passions, interests, and ideas. Learn more about our Life at Pacific Life. Don't see the dream job you are looking for? Click "Get Started" below to drop off your contact information and resume and we will reach out to you if we find a match.