Pacific Life-posted 3 months ago
$121,770 - $148,830/Yr
Full-time • Mid Level
1,001-5,000 employees

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.

  • 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
  • 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
  • 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
  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service