
Senior Software Developer, Data Warehousing and ETL
Providence
full-time
Posted on:
Location Type: Hybrid
Location: Renton • California • Oregon • United States
Visit company websiteExplore more
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