Job Description:
What You'll Do
•Design, build, and maintain scalable data pipelines and integration solutions using Snowflake, DBT, Matillion, AWS, SQL, Python, and modern ETL/ELT technologies.
•Develop, optimize, and support enterprise data products that enable analytics, reporting, AI, and business intelligence initiatives.
•Design and maintain Power BI semantic models, datasets, dashboards, and reporting solutions that support critical business and investment decisions.
•Translate business and technical requirements into data models, mapping specifications, solution designs, and implementation plans.
•Partner with business stakeholders, product owners, architects, and engineers to deliver scalable, reliable, and high-performing data solutions.
•Implement data quality, governance, reconciliation, monitoring, and validation frameworks to ensure accuracy, reliability, and compliance.
•Contribute production-quality code and participate in code reviews, testing, CI/CD automation, and operational support.
•Leverage AI-assisted development tools such as GitHub Copilot, ChatGPT, Claude, and similar technologies to accelerate solution design, development, testing, troubleshooting, and documentation.
•Troubleshoot production issues, perform root cause analysis, and ensure platform reliability and performance.
•Drive continuous improvement through automation, simplification, reusability, and reduction of technical debt.
•Mentor team members and contribute to a collaborative, high-performing engineering culture.
•Communicate effectively with technical and non-technical stakeholders and provide timely updates on progress, risks, and dependencies.
What You'll Bring
Required Qualifications
•Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related discipline.
•6 years of experience designing, developing, and delivering enterprise-scale data solutions.
•Strong hands-on experience with Snowflake, DBT, Matillion, SQL, AWS, Python, and modern data integration technologies.
•Experience building and optimizing cloud-based data pipelines, data warehouses, and analytical solutions.
•Experience developing and supporting Power BI semantic models, datasets, dashboards, and enterprise reporting solutions.
•Strong understanding of data architecture, data modeling, governance, security, and software engineering best practices.
•Experience working within Agile delivery teams and collaborating with business and technology stakeholders.
•Excellent problem-solving skills with the ability to balance strategic thinking and hands-on execution.
•Strong communication skills with the ability to explain complex technical concepts in practical business terms.
•Demonstrated ability to be a self-starter, take ownership of initiatives, and drive work forward with minimal supervision.
•Comfortable operating in a dynamic environment and wearing multiple hats across engineering, analytics, solution design, production support, and stakeholder engagement.
•Proven ability to prioritize competing demands, manage deadlines, and proactively identify and escalate risks.
Investments Domain Expertise
•3 years of experience supporting Investment Management, Asset Management, Capital Markets, Investment Accounting, or Financial Services data platforms.
•Strong understanding of one or more investment domains, including:
•Commercial Mortgage Loans
•Fixed Income Securities
•Private Placements
•Structured Products
•Equities
•Real Estate Investments
•Alternative Investments
•Investment Performance and Attribution
•Experience building solutions that support investment operations, portfolio management, investment accounting, risk management, compliance, treasury, or investment reporting functions.
•Understanding of investment data concepts.
•Ability to translate complex investment business processes and requirements into scalable data models, reporting solutions, and analytics platforms.
•Experience partnering directly with investment professionals and business stakeholders to understand challenges, define requirements, and deliver business value.
Preferred Qualifications
•Experience with DBT, Matillion, Control-M, and modern data orchestration platforms.
•Experience supporting enterprise Power BI environments, including governance, performance optimization, and semantic model design.
•Experience integrating data from investment platforms such as Aladdin, Bloomberg, Clearwater, Eagle, Geneva, PAM, or similar investment management systems.
•Experience leveraging AI-augmented engineering practices to improve software development productivity, quality, and delivery outcomes.
What Sets You Apart
The ideal candidate combines deep technical expertise with strong investment domain knowledge. You understand that delivering great data solutions is about more than moving data between systems. You understand how portfolio managers, investment operations teams, accountants, analysts, and business leaders rely on trusted data to make critical decisions.
You are a naturally curious engineer who challenges the status quo, embraces change, and continuously looks for opportunities to improve platforms, processes, and outcomes. You are comfortable working through ambiguity, taking ownership without waiting for direction, and balancing both strategic initiatives and day-to-day operational needs.
You thrive in a collaborative environment, communicate effectively with both technical and business audiences, and consistently deliver high-quality solutions that create measurable business value.
Base Pay Range:
The base pay range noted represents the company’s 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.
$137,610.00 - $168,190.00
Your Benefits Start Day 1
Your wellbeing is important to Pacific Life, and we’re 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, we’ve 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
You Can Be Who You Are
We are committed to a culture of diversity and inclusion that embraces the authenticity of all employees, partners and communities. We support all employees to thrive and achieve their fullest potential.
What’s life like at Pacific Life? Visit Instagram.com/lifeatpacificlife
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.