> Markdown version of [/jobs/ext/1701245-sr-software-engineer-data-integration](https://www.wearedevelopers.com/jobs/ext/1701245-sr-software-engineer-data-integration). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. Software Engineer- Data & Integration - **Company:** Pacific Life Insurance Company - **Location:** Newport Beach, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Cloud Computing, Cloud Engineering, Databases, Continuous Integration, Data Architecture, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, DevOps, Dimensional Modeling, Python (Programming Language), Oracle (Applications), Oracle SQL Developer, Performance Tuning, Software Engineering, PL-SQL, SQL Databases, Workflow Management Systems, Data Processing, Scripting, Cloud Platform System, Informatica Powercenter, Snowflake, Git, Infrastructure Automation Frameworks, Enterprise Integration, Data Management, Software Version Control, Data Pipelines, Atlassian Bamboo, Control M - **Published:** July 11, 2026 - **Apply:** https://pacificlife.wd1.myworkdayjobs.com/PacificLifeCareers/job/Newport-Beach-CA-700/Sr-Software-Engineer--Data---Integration_R17280 ## About the Role * Proficiency in SQL and hands-on experience with ETL/ELT tools (Informatica preferred). * Advanced knowledge of Oracle SQL and PL/SQL for data transformation, performance tuning, and data integration. * Experience with cloud-based data platforms such as Snowflake. * Understanding data warehousing concepts, dimensional modeling, and data integration patterns. * Experience designing data warehouse and dimensional models to support reporting and analytics. * Experience integrating data from APIs, files, databases, and cloud platforms. * Working knowledge of Python and experience developing data processing scripts and automation. * Exposure to version control and DevOps tools such as Git and Azure Pipelines. * Ability to work collaboratively in an agile, team-oriented environment. * Strong communication skills and a willingness to learn and grow. What Will Make You Stand Out * Experience implementing modern ELT frameworks such as DBT and Matillion within Snowflake environments. * Exposure to enterprise scheduling and orchestration tools such as Control-M. * Experience working with investment management platforms, investment accounting systems, or financial market data. * Knowledge of cloud-native architecture and data modernization initiatives. * A proactive mindset with a passion for continuous learning, automation, and technology transformation., * 8+ years of experience designing, developing, and supporting enterprise ETL/ELT and data integration solutions. * BS Degree: IT, CS, Data Science or Statistics or equivalent experience * Strong expertise in SQL, Oracle, and data integration development * Experience with ETL/ELT frameworks, data warehousing, and dimensional modeling. * Experience with Python for automation, scripting, and data processing preferred. * Experience supporting cloud-based data platforms such as Snowflake preferred. ## Description We're actively seeking a technically capable and motivated Senior Data Integration Engineer to join our growing Investment Technology team in Newport Beach. This role focuses on building and maintaining scalable ETL/ELT pipelines that support analytics and reporting across asset management, investment accounting, and investment operations domains. You'll work with technologies such as Oracle, Snowflake, Informatica, Python, Azure DevOps, and modern data integration platforms while partnering with business and technology teams to deliver scalable data solutions. This role supports critical investment capabilities including portfolio management, trading, investment accounting, security master data, pricing, positions, and regulatory reporting. How You Will Make an Impact * Design, develop, optimize, and support scalable ETL/ELT data pipelines using SQL, Informatica, Oracle, and cloud-based technologies. * Partner with developers, architects, analysts, and business stakeholders to define integration solutions and ensure data accuracy and usability. * Lead technical design discussions and provide guidance to junior team members on data integration best practices. * Contribute to data architecture and modernization initiatives, including migration of legacy solutions to cloud-based platforms, data warehouse design, and enterprise integration strategies. * Participate in the software development lifecycle, including CI/CD practices and infrastructure automation using Azure Pipeline. ## Related Videos - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)