Sr IT Solutions Analyst

Pacific Life • Newport Beach, CA

12d • Onsite

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 Senior IT Solutions Analyst to join our Workforce Benefits Technology team. This role is on-site. You’ll work at our state-of-the-art Newport Beach headquarters / modern Omaha office. This position will be reporting to the Principal Data Engineer and will be responsible for the design and delivery of integrated data solutions that support the Workforce Benefits Division. The role focuses on creating and maintaining data marts, data models, and translation processes to enable secure, scalable, and efficient data integration from multiple internal and external sources. These solutions will provide trusted, unified data for Finance, Actuarial, Pricing, Underwriting, Claims, and other business functions. The Senior IT Solutions Analyst will collaborate across teams to define business and technical requirements, establish robust data processes, and develop solutions that ensure fast, reliable access to structured and semi-structured data assets for analytics and decision-making.

Requirements

• Bachelor’s degree in computer science, information systems, mathematics, analytics or related field.
• Strong SQL and Python scripting skills
• Experience with data modeling and database design principles
• Experience with modern data pipeline architectures and ETL/ELT processes
• Experience with data analysis, reporting tools, and translating business requirements into technical specifications
• Knowledge of data quality concepts and implementation approaches
• Experience in agile methodologies.
• Effective communication & facilitation; both verbal and written
• Team-Oriented: Collaborating effectively with team and stakeholders
• Analytical Skills: Strong problem-solving skills with ability to break down complex data solutions

Nice To Haves

• Experience working with Azure Dev Ops (ADO), Build and Release CI/CD pipelines and orchestration
• Experience working with AWS, Snowflake, DBT
• Experience with automation, scripting, and testing in data delivery environment
• Financial Services/Group Insurance domain knowledge
• Experience working with semi-structured data

Responsibilities

• Partner with data architects, analysts, engineers, and stakeholders to understand data requirements and deliver solutions
• Document technical requirements - serve as the liaison between the business and technology regarding new business solutions or enhancements to existing business solutions. Responsible for collaborating with all levels of business and technology teams
• Create low-level design artifacts, including mapping specifications
• Lead requirement gathering sessions and ticket refinement meetings, translating business needs into clear technical requirements
• Apply SQL and Python to perform data analysis, design efficient data views, and develop automated solutions to optimize workflows and reporting
• Participate in code reviews to ensure standards and best practices
• Use the Agile Framework to organize, manage and execute work
• Demonstrate adaptability, initiative and attention to detail through deliverables and ways of working

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
• Number of Employees: 1,001-5,000 employees