Senior Software Developer, Data Warehousing and ETL

Role Overview

• 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

Tech Stack

• Cloud
• ERP
• ETL
• Oracle
• SQL

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