Data Engineer III

JOB DESCRIPTION

This role is on-site. You’ll work at our state-of-the-art Newport Beach headquarters, Omaha office or Charlotte office.

As a 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 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 cloud-based 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.

Must-Have / High Priority:

Snowflake (expert-level SQL)

Advanced SQL – heavy transformation logic

AWS (data environment exposure)

Informatica (used extensively today)

Data transformation development (not reporting-focused)

Nice to Have:

DBT (preferred over UI-based ETL tools)

Matillion or ADF or talend(currently used but UI limitations noted)

Control-M

Azure DevOps

Agile methodology experience

The experience you bring:

• Bachelor’s degree in computer science, Data Science or Statistics
• 5+ years of experience in analysis, design, development, and delivery of data
• 5+ 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
• 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 breakdown complex data solutions

What makes you stand out:

• Experience working with Azure Dev Ops (ADO), Build and Release CI/CD pipelines and orchestration
• Experience working with AWS
• Experience with automation, scripting, and testing in data delivery environment
• Understanding of data catalogs, glossary, data quality, and effective data governance
• Financial Services/Investments/Insurance domain knowledge
• Experience working in complex data systems
• Master Data Management/Reference Data experience

Technical Skills

• 1+ years of experience (not just POC) in using Git and Python
• 2+ years of experience with DevOps and CI/CD
• 5+ years of experience and proficiency in SQL, ETL, ELT, leading cloud data warehouse technologies, data transformation, and data management tools
• 5+ years of experience in analysis, design, development, and delivery of data

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.