Senior Software Developer, Data Warehousing and ETL, ...

DescriptionProvidence caregivers are not simply valued - they're invaluable. Join our team at Enterprise Information Services and thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and mutual respect. Your voice matters here, because we know that to inspire and retain the best people, we must empower them.Ready to build the systems that keep a whole organization running? As a Senior ERP Software Developer, you'll tackle some of the most challenging technical puzzles across HR & Payroll, Supply Chain, Finance, and clinical operations. You'll partner with analysts, vendors, and IS teams to turn big ideas into powerful solutions-designing, coding, and troubleshooting the applications thousands of caregivers rely on every day. In this role, you will leverage Oracle Data Integrator (ODI) to build robust data pipelines and integrate complex datasets across the enterprise. You will also harness Oracle Fusion Data Intelligence (FDI) to deliver deep, actionable insights and advanced analytics that drive smarter decision-making. From leading project teams and mentoring peers to optimizing business processes and driving innovation from concept to release, you'll be at the heart of creating resilient, data-driven systems. If you love solving complex problems and bringing stability to critical ERP technologies through technical mastery, this is where you make an impact.Providence offers hybrid work opportunities for candidates residing within a daily commuting radius-up to 65 miles-from any of our primary office locations listed below.Santa Rosa, CaliforniaLos Angeles, CaliforniaIrvine, CaliforniaSeattle, WashingtonRenton, WashingtonRedmond, WashingtonPortland, OregonRequired Qualifications:5 or more years of application design, development, implementation and/or maintenance of one or more of the following large scale Enterprise Resource Planning systems - Oracle Cloudsuite FSCM and HCM, Oracle EBS/EPM (Hyperion, etc.) Applications, PeopleSoft, Workday. .2 or more years of demonstrated ability to successfully execute medium to complex projects; methodologies related to application management such as system deployment, support, and life cycle.Preferred Qualifications:Bachelor's Degree in Computer Science, Business Management, Information Services, Engineering, Commerce -OR- a combination of equivalent education and work experience2 or more years of experience with implementation or support of Oracle Cloud Suite (HCM, Payroll, Supply Chain and/or Finance) is highly desired.2 or more years of experience with large scale business transformation and ERP system implementation projects with scope spanning multiple regions and/or geographies and business process areasTechnical Experience Requirements:Expertise in fact and dimension data modeling, including implementing Slowly Changing Dimensions (SCD Type 1 and Type 2) and designing partitioning strategies to support highvolume ETL workloadsProven ability to design, develop, and deploy ETL processes using Oracle Data Integrator (ODI)Strong proficiency building ODI Load Plans, Procedures, Packages, and integrations leveraging APIsHands-on experience developing and optimizing SQL and PL/SQL for complex data extraction, transformation, and loading scenariosAbility to monitor, troubleshoot, and tune ODI jobs, ETL performance, SQL queries, and PL/SQL proceduresSkilled at identifying data quality gaps, duplicate records, and performance bottlenecks within existing reports and data pipelinesExperience designing logical and physical data models that support reporting, analytics, and business intelligence requirementsPreferred experience with Oracle BI ApplicationsBackground working with large-scale, high-volume datasetsFusion Data Intelligence (

Created: 2026-02-24