Lead Data Engineer- Investments

Pacific Life • Charlotte, NC

3d • $138,150 - $168,850 • 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. Unlock the Power of Data at Pacific Life. We’re seeking talented Lead Data Engineer to join our Pacific Life Investments Data Team onsite in Charlotte, North Carolina. This is not a remote position. We are looking for self-starters to help shape the future of data engineering and drive data-driven success. As a Lead Data Engineer you’ll move Pacific Life, and your career, forward by accelerating our data initiatives by bringing modern technical solutioning forward. You will fill a new role that sits on the Investments data team in the technology organization. Your colleagues will include scrum masters and data analyst and fellow Data, AI, Governance, and QA professionals. Join our highly collaborative, innovative team. How you’ll help move us forward: Partner with data architects, analysts, engineers, and stakeholders to understand data requirements and deliver solutions. Help build scalable products with robust security, quality and governance protocols. Create low-level design artifacts, including mapping specifications. Build scalable and reliable data pipelines to support data ingestions (batch and /or streaming) and transformation from multiple data sources using SQL, AWS, Snowflake, and data integration technologies. Create unit/integration tests and implement automated build and deployment. Participate in code reviews to ensure standards and best practices. Deploy, monitor, and maintain production systems. Use the Agile Framework to organize, manage and execute work. Demonstrate adaptability, initiative and attention to detail through deliverables and ways of working.

Requirements

• Bachelor’s degree in Computer Science, Data Science or Statistics
• 7+ years of experience in analysis, design, development, and delivery of data
• 7+ years of experience and proficiency in SQL, ETL, ELT, leading cloud data warehouse technologies, data transformation, and data management tools
• Understanding of data engineering best practices and data integration patterns
• 2+ years of experience with DevOps and CI/CD
• 1+ years of experience (not just POC) in using Git and Python
• Agile Scrum work experience
• Effective communication & facilitation; both verbal and written
• Team-Oriented: Collaborating effectively with team and stakeholders
• Analytical Skills: Strong problem-solving skills with ability to breakdown complex data solutions

Nice To Haves

• Investments or FINTECH domain knowledge preferred
• Strong Data analysis skills and /or data mining experience
• Experience with one or more Integration tools (Matillion, Informatica, SQL SSIS, DBT)
• Experience with Snowflake and DBT
• Works independently with minimal guidance.

Responsibilities

• Partner with data architects, analysts, engineers, and stakeholders to understand data requirements and deliver solutions.
• Help build scalable products with robust security, quality and governance protocols.
• Create low-level design artifacts, including mapping specifications.
• Build scalable and reliable data pipelines to support data ingestions (batch and /or streaming) and transformation from multiple data sources using SQL, AWS, Snowflake, and data integration technologies.
• Create unit/integration tests and implement automated build and deployment.
• Participate in code reviews to ensure standards and best practices.
• Deploy, monitor, and maintain production systems.
• 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 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: 501-1,000 employees