Senior Software Developer, Data Warehousing and ETL, Hybrid
Providence St. Joseph Health
Seattle, WA
JOB DETAILS
JOB TYPE
Full-time, Employee
SKILLS
Access Authorization, Access Control, Application Programming Interface (API), Best Practices, Business Intelligence, Business Processes, Business Transformation, Channel Strategies, Cloud Computing, Computer Science, Customer Support/Service, Data Fusion, Data Management, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Diversity, ERP (Enterprise Resource Planning), Federal Laws and Regulations, Finance, Financial Operations, Genetics, Healthcare, Hyperion, Identify Issues, Information Technology & Information Systems, Load Planning, Mentoring, Oracle, Oracle Data Integrator, Oracle ERP, Oracle Enterprise Performance Management (EPM), Oracle Fusion Middleware, Oracle PL-SQL, Peoplesoft, Problem Solving Skills, Process Improvement, SQL (Structured Query Language), Software Administration, Software Design, Software Development, Supply Chain, Systems Administration/Management, Team Lead/Manager, Vendor/Supplier Evaluation
LOCATION
Seattle, WA
POSTED
Today
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 highvolume 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 ApplicationsBackground 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 Providence
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.
Requsition ID: 409625
Company: Providence Jobs
Job Category: Development/Engineering
Job Function: Information Technology
Job Schedule: Full time
Job Shift: Day
Career Track: Business Professional
Department: 4011 SS IS EBA DP 5
Address: WA Renton 1801 Lind Ave SW
Work Location: Providence Valley Office Park-Renton
Workplace Type: Hybrid
Pay Range: $See Job Posting - $See Job Posting
The amounts listed 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 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.
About the Company
P