Pacific Life is looking to innovate its business and create a superior customer experience by building and maintaining scalable ETL/ELT pipelines that support analytics and reporting across asset management and investment risk domains.
Requirements
- Proficiency in SQL and hands-on experience with ETL/ELT tools (Matillion preferred).
- Working knowledge of Snowflake for data warehousing and transformation.
- Familiarity with cloud platforms, especially AWS.
- Exposure to version control and DevOps tools such as Git, Azure Pipelines, and Terraform.
- Experience with DBT or similar transformation frameworks.
- Exposure to enterprise job schedulers like Control-M.
- Experience or interest in UI/API development for data access.
Responsibilities
- Assist in developing and optimizing data pipelines using SQL, Matillion, and Snowflake to support financial modeling and risk analytics.
- Support the integration and transformation of data related to Scenarios, Asset Cashflows, and Investment Risk Metrics.
- Collaborate with senior developers, analysts, and business stakeholders to ensure data accuracy and usability.
- Participate in the software development lifecycle, including CI/CD practices and infrastructure automation using Azure Pipelines and Terraform.
- Contribute to the development and maintenance of APIs and UI components for data access and visualization.
- Support data architecture and governance efforts in a cloud-first environment leveraging AWS and Snowflake.
Other
- Ability to work collaboratively in an agile, team-oriented environment.
- Strong communication skills and a willingness to learn and grow.
- Interest or background in financial services, particularly asset management or investment risk.
- Understanding of risk concepts such as stress testing and scenario modeling.
- A proactive mindset and enthusiasm for continuous learning.
