Providence

Senior Software Developer, Data Warehousing and ETL

Providence

full-time

Posted on:

Location Type: Hybrid

Location: RentonCaliforniaOregonUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $54 - $96 per hour

Job Level

About the role

  • Build the systems that keep a whole organization running by partnering with analysts, vendors, and IS teams.
  • Tackle some of the most challenging technical puzzles across HR & Payroll, Supply Chain, Finance, and clinical operations.
  • Leverage Oracle Data Integrator (ODI) to build robust data pipelines and integrate complex datasets across the enterprise.
  • Harness Oracle Fusion Data Intelligence (FDI) to deliver deep, actionable insights and advanced analytics that drive smarter decision-making.
  • Lead project teams and mentor peers to optimize business processes and drive innovation from concept to release.
  • Solve complex problems and bring stability to critical ERP technologies through technical mastery.

Requirements

  • 5 or more years of application design, development, implementation and/or maintenance of one or more of the following large scale ERP systems - Oracle Cloudsuite FSCM and HCM, Oracle EBS/EPM 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.
  • 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
Benefits
  • Health care benefits (medical, dental, vision)
  • Retirement 401(k) Savings Plan with employer matching
  • Paid parental leave
  • Time off benefits (vacations, holidays, health issues)
  • Health and welfare benefit plan offerings
  • Voluntary benefits
  • Well-being resources
  • Additional compensation opportunities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Oracle Data Integrator (ODI)Oracle Fusion Data Intelligence (FDI)ERP systemsSQLPL/SQLETL processesdata modelingSlowly Changing Dimensions (SCD)data quality analysisdata pipeline optimization
Soft Skills
leadershipmentoringproblem-solvinginnovationcollaboration
Certifications
Bachelor's Degree in Computer ScienceBachelor's Degree in Business ManagementBachelor's Degree in Information ServicesBachelor's Degree in EngineeringBachelor's Degree in Commerce