Senior Software Developer, Data Warehousing and ETL, Hybrid

Job 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

Required 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 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

Technical 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 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

Fusion Data Intelligence (FDI / FAW) & Oracle Analytics Cloud (OAC) Requirements:

• 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 Warehouse) tables or views
• Understanding of the FDI security model, role-based access control, and authorization patterns
• Experience configuring row-level security and semantic-layer data filters

Salary Range by Location:

• Washington: Seattle, Renton, Redmond: Min: $54.40, Max: $85.88
• Oregon: Portland: Min: $52.19, Max: $82.39
• California: Santa Rosa: Min: $61.04, Max: $96.35
• California: Los Angeles, Irvine: Min: $54.40, Max: $85.88

Why Join Providence?

Our best-in-class benefits are uniquely designed to support you and your family in staying well, growing professionally, and achieving financial security. We take care of you, so you can focus on delivering our Mission of caring for everyone, especially the most vulnerable in our communities.

About Us

At Providence, our strength lies in Our Promise of "Know me, care for me, ease my way." Working at our family of organizations means that regardless of your role, we'll walk alongside you in your career, supporting you so you can support others. We provide best-in-class benefits and we foster an inclusive workplace where diversity is valued, and everyone is essential, heard and respected. Together, our 120,000 caregivers (all employees) serve in over 50 hospitals, over 1,000 clinics and a full range of health and social services across Alaska, California, Montana, New Mexico, Oregon, Texas and Washington. As a comprehensive health care organization, we are serving more people, advancing best practices and continuing our more than 100-year tradition of serving the poor and vulnerable.

Posted are the minimum and the maximum wage rates on the wage range for this position. The successful candidate's placement on the wage range for this position will be determined based upon relevant job experience and other applicable factors. These amounts are the base pay range; additional compensation may be available for this role, such as shift differentials, standby/on-call, overtime, premiums, extra shift incentives, or bonus opportunities.

Providence offers a comprehensive benefits package including a retirement 401(k) Savings Plan with employer matching, health care benefits (medical, dental, vision), life insurance, disability insurance, time off benefits (paid parental leave, vacations, holidays, health issues), voluntary benefits, well-being resources and much more. Learn more at providence.jobs/benefits.

Applicants in the Unincorporated County of Los Angeles: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Unincorporated Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

About the Team

Providence Shared Services is a service line within Providence that provides a variety of functional and system support services for our family of organizations across Alaska, California, Montana, New Mexico, Oregon, Texas and Washington. We are focused on supporting our Mission by delivering a robust foundation of services and sharing of specialized expertise.

Providence is proud to be an Equal Opportunity Employer. We are committed to the principle that every workforce member has the right to work in surroundings that are free from all forms of unlawful discrimination and harassment on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, sexual identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law. We believe diversity makes us stronger, so we are dedicated to shaping an inclusive workforce, learning from each other, and creating equal opportunities for advancement.