Senior Data Engineer

Job Description:

Pacific Life is investing in bright, agile and diverse talent to contribute to our mission of innovating our business and creating a superior customer experience. Were actively seeking a talented Senior Data Engineer to join our Workforce Benefits Technology team in Newport Beach, CA. This role can be on-site, hybrid or 100% remote.

This position will be responsible for the requirement gathering, design and delivery of integrated data marts, data translations, and data models in the newly formed Workforce Benefits Division. These data solutions will capture, manage, store and utilize structured and unstructured data from internal and external sources and provide integrated data for Sales, Actuarial, Pricing, Underwriting, Operations, Claims and other functions. The role will establish and build processes and structures based on business and technical requirements to channel data from multiple inputs, apply appropriate security, and create data products. The position will work with functional data stewards to implement data governance and data management principles across Workforce Benefits, and may work with solution providers to ensure the integrity and automated flow of data to PL. This role will serve as a valued partner across Workforce Benefits functions to create a single-source of trusted data with fast, scalable access to data assets, to satisfy the analytical data needs of the division.

How you will make an impact:

• Become a domain expert in WBD data by understanding complex data relationship between internal and external data sources, user interface source data and event data.
• Act as a key liaison to Workforce Benefits Division stakeholders on data needs by translating business requirements to design, and develop efficient and reliable data products for business analytics.
• Document requirements, link requirements to integrate common data elements, expand the WBD data model with new data elements, and create source to target mappings for destination tables.
• Identify the appropriate microservice events from the policy admin system to capture required data, and transform source data into an operational data store by building third normal form tables.
• Develop Workforce Benefits division integrated data layer by constructing data schemas for functional business analysis and reporting. Recommend best practices for data-driven reporting and analytics.
• Build data products that are used to drive business growth, operational effectiveness, customer success, and manage expenses, like prospect and sales, pricing, enrollment, onboarding, and claims data schemas.
• Build data management solutions to feed real-time data back to customer portals and vendor data exchanges.
• Conduct proof-of-concepts, ideate options, and embrace new technologies to support business goals and align with division strategies.
• Working with the Data Governance team, contribute to data governance standards, profiling, and glossaries using a data catalog and working with business data stewards. Utilize and maintain metadata related to Workforce Benefits data domains.

The experience you will bring:

• 6+ years of experience using T-SQL, PL/SQL, or Hive to analyze and manipulate large volumes of data
• 6+ years of experience in analysis, design, development, and delivery of relational databases, data marts, data load processes and data wrangling in support of business analytics
• 5+ years using dbt to transform source data into operational data stores and data warehouse layers
• 5+ years working with a microservices event data infrastructure, including Kafka, Amazon Kinesis, or other event orchestration tools
• 5+ years of experience building data warehouses using Snowflake, Redshift or comparable tools
• Strong ability to build relationships across the organization and communicate and manage stakeholders at all levels
• Ability to work with ambiguity, and drive efforts forward without fully complete information. Strong execution focused mindset.
• Bachelors degree in Computer Science, Mathematics, Analytics or related field. Masters degree preferred.

What will make you stand out:

• Knowledge of EIS administration system, including events and data structures
• 5+ years of experience designing and building data products in Group Benefits insurance data domains, including Sales, Actuarial, Operations, and Claims
• Experience with cloud technologies such as AWS
• Hands on experience using ETL/ELT tools like dbt or Matillion and analytics tools like Dataiku and Alteryx

You belong at Pacific Life

At Pacific Life we are committed to a culture of belonging, a space where all employees areempowered to be authentic. One way we cultivate an inclusive culture is through our employee connection groups. The purpose of these employee-led groups is to offer a place to build community, connection, camaraderie, and a sense of belonging.Each group can be active in education, advocacy, recruitment, and community building throughout our organization. Learn more about our employee connection groups at www.pacificlife.com.

Want to learn more about life at Pacific Life? Take an inside look at our company culture: Instagram.com/lifeatpacificlife.

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.

$131,040.00 - $160,160.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

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.