Senior Software Developer, Data Warehousing and ETL, Hybrid

Description

Providence 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, California
• Los Angeles, California
• Irvine, California
• Seattle, Washington
• Renton, Washington
• Redmond, Washington
• Portland, Oregon

• 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 Cloud Suite FSCM and HCM, Oracle EBS/EPM (Hyperion, etc.) Applications, People Soft, 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.

• Bachelor's Degree in Computer Science, Business Management, Information Services, Engineering, Commerce – or a combination of equivalent education and work experience.
• 2 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 areas.

• Expertise in fact and dimension data modeling, including implementing Slowly Changing Dimensions (SCD Type 1 and Type
  2) and designing partitioning strategies to support high‑volume ETL workloads.
• Proven ability to design, develop, and deploy ETL processes using Oracle Data Integrator (ODI).
• Strong proficiency building ODI Load Plans, Procedures, Packages, and integrations leveraging APIs.
• Hands‑on experience developing and optimizing SQL and PL/SQL for complex data extraction, transformation, and loading scenarios.
• Ability to monitor, troubleshoot, and tune ODI jobs, ETL performance, SQL queries, and PL/SQL procedures.
• Skilled at identifying data quality gaps, duplicate records, and performance bottlenecks within existing reports and data pipelines.
• Experience designing logical and physical data models that support reporting, analytics, and business intelligence requirements.
• Preferred experience with Oracle BI Applications – background working with large-scale, high-volume datasets.

• Strong understanding of the FDI semantic model, including subject areas and their underlying structure.
• Knowledge of logical vs. physical layer mappings within FDI.
• Experience extending FDI models by adding custom facts and dimensions.
• Ability to extend FDI subject areas using custom ADW (Autonomous Data…