Data Warehouse Developer
Rutgers University
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Benefits offered by this job
Job summary
Rutgers University seeks a Data Warehouse Developer to design and implement data warehouse architecture, models, and secure integrations across Oracle Fusion data sources and OCI/ADW. You will collaborate with IT and business units to deliver scalable, governed enterprise data solutions and support reporting needs.
The role involves migrating legacy environments to OCI/ADW, developing data pipelines, and enforcing data governance while aligning with institutional reporting requirements.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field is required.
- Seven (7) years of experience in data management, data engineering, data architecture, or enterprise analytics, with cloud-scale data platforms and data modeling.
- Equivalent experience, education and/or training may be substituted for the education requirements.
Responsibilities
- Data Warehouse Architecture and Data Modeling.
- Participate in cloud modernization and data platform evolution initiatives.
- Develop and optimize data models that support high-performance analytics.
- Establish consistent and reusable data structures across cloud and on-prem environments.
- Ensure alignment with business reporting and analytics requirements.
Skills
Education
Tools
Job description
Rutgers, The State University of New Jersey, is seeking Data Warehouse Developer in the Department of Enterprise Applications and Research Computing ( EARC ) – Data Management within the Office of Information Technology ( OIT ).
Under the direction of the Director of IT, Consulting Application Developer, supports the university’s Oracle Fusion Data Intelligence ( FDI ) platform and the strategic Oracle Cloud Infrastructure ( OCI ) initiatives. The role is responsible for data warehouse architecture, data modeling, and integration of Oracle Fusion applications data and other data sources. Designs and implements secure data integrations utilizing data that resides within the Oracle Autonomous Data Warehouse ( ADW ). Supports designing OCI access policies to organizational roles and enforcing scalable integration architecture using Oracle Integration Cloud ( OIC ), aligning access policies to organizational roles, and enforcing enterprise data governance standards to support data access and reporting needs.
The position works closely with project teams implementing new Oracle and third-party cloud enterprise systems to ensure those platforms are effectively integrated with the data warehouse and aligned to institutional reporting needs, including both centrally developed and unit-level self-service reporting.
The role also supports migration of legacy on-premises data warehouse environments to Oracle Cloud Infrastructure ( OCI ) and Oracle Autonomous Data Warehouse ( ADW ), including the development of custom schemas and the expansion of enterprise data assets across multiple business and system domains.
This position collaborates within the centralized Office of Information Technology ( OIT ) Data management and Reporting team, across other OIT teams, and with university administrative and campus departments to deliver secure, scalable, and well‑governed enterprise data solutions.
Among the key duties of this position are the following;
- Data Warehouse Architecture and Data Modeling.
- Participate in cloud modernization and data platform evolution initiatives, including data pipeline migration, optimization, and adoption of new analytics technologies.
- Develop and optimize data models that support high-performance analytics.
- Establish consistent and reusable data structures across cloud and on-prem environments.
- Ensure alignment with business reporting and analytics requirements.
FLSA Exempt
Grade 37S
Minimum Salary 121608.000
Mid Range Salary 147221.000
Maximum Salary 175737.000
The final salary offer may be determined by several factors, including, but not limited to, the candidate’s qualifications, experience, and expertise, and availability of department or grant funds to support the position. We also take into consideration market benchmarks, if and when appropriate, and internal equity to ensure fair compensation relative to the university’s broader compensation structure. We are committed to offering competitive and flexible compensation packages to attract and retain top talent.
- Medical, prescription drug, and dental coverage
- Paid vacation, holidays, and various leave programs
- Competitive retirement benefits, including defined contribution plans and voluntary tax‑deferred savings options
- Employee and dependent educational benefits (when applicable)
- Life insurance coverage
- Employee discount programs
Full Time
Standard Hours 37.50
Work Arrangement
Consistent with the current application of Rutgers Policy 60.3.22 or the applicable provisions of relevant collective negotiations agreements, this position may be eligible for a hybrid work arrangement. Flexible work arrangements are not permanent, are subject to change or discontinuation, and contingent on the employee receiving approval in the FlexWork@RU Application System.
HPAE 5094
PeopleSoft
Terms of Appointment
Staff - 12 month
ABP
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field is required.
- Seven (7) years of experience in data management, data engineering, data architecture, or enterprise analytics, including recent hands‑on work with cloud‑scale data platforms, modern integration frameworks, and data modeling is required.
- Equivalent experience, education and/or training may be substituted for the education requirements.
- Hands‑on experience with modern data architecture, specifically cloud warehousing, ELT / ETL modernization, semantic modeling, and governed data products and services.
- Strong SQL and data modeling skills, including conceptual, logical, and physical modeling; performance tuning; normalization; and optimization.
- Experience with ETL / ELT tools and pipeline automation.
- Strong understanding of enterprise systems, preferably Oracle ERP / HCM and their related data reporting needs relying on the data warehouse, data models, and datasets.
- Proven ability to collaborate across IT and business departments—to meet data warehouse, data governance, and support reporting data needs.
- Excellent technical documentation, analytical and research skills.
- Proven expertise in implementing row‑level data security (data filters, data access sets, or similar constructs).
- Hands‑on experience with identity and access management, including role‑based access control and policy design.
- Strong experience with Oracle Cloud Infrastructure ( OCI ) and Oracle Integration Cloud ( OIC ) in an effort to synchronize data between the ADW and on‑premises resources.
- Familiarity with Oracle Data Integration ( ODI ) platform to help support ETL workflows.
- Experience with Oracle Identity Cloud Service ( IDCS ) or OCI IAM.
- Familiarity with Fusion security model concepts (privileges, roles, data security policies).
- Experience with data mapping analysis and design.
- Demonstrated experience in implementing data warehouse and related data management, and data architecture, in a large complex environment.
- Familiarity with higher education administrative systems, including Oracle ERP / HCM , Banner, Salesforce, and related platforms.
- Experience implementing or modernizing cloud data platforms with Oracle FDI and/or equivalent.
- Experience implementing new data platform capabilities into production is strongly preferred.
- Professional certifications such as Microsoft Certified: Azure Data Engineer Associate, AWS / GCP Data Engineer, Oracle data management certifications, or Certified Data Management Professional ( CDMP ).
- Oracle Cloud certifications ( OCI Architect, Integration Specialist, etc.)
- Standing, sitting, walking, talking or hearing.
- No special vision requirements.
- Office environment.
- Moderate Noise.
Posting Number 26ST1897
Pre‑employment Screenings All offers of employment are contingent upon successful completion of all pre‑employment screenings.
Immunization Requirements
Under Policy 100.3.1 Immunization Policy for Covered Individuals , if employment will commence during Flu Season, Rutgers University may require certain prospective employees to provide proof that they are vaccinated against Seasonal Influenza for the current Flu Season, unless the University has granted the individual a medical or religious exemption. Additional infection control and safety policies may apply. Prospective employees should speak with their hiring manager to determine which policies apply to the role or position for which they are applying. Failure to provide proof of vaccination for any required vaccines or obtain a medical or religious exemption from the University will result in rescission of a candidate’s offer of employment or disciplinary action up to and including termination.
Equal Employment Opportunity Statement It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we encourage all qualified applicants to apply. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement
Required fields are indicated with an asterisk (*).
- * Do you have a Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related and seven (7) years of experience in data management, data engineering, data architecture, or enterprise analytics, including recent hands‑on work with cloud‑scale data platforms, modern integration frameworks, and data modeling or equivalent experience, education and/or training that may be substituted for the education requirements.
- Yes
- No
- Resume/CV
- Cover Letter/Letter of Application
- Certifications/Licenses
It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we encourage all qualified applicants to apply. For additional information please see the Non-Discrimination Statement at the following web address: Non-Discrimination-Statement .
In compliance with the Americans with Disabilities Act (ADA) and the New Jersey Law Against Discrimination (NJLAD), if you have a disability and would like to request an accommodation with regard to your access to and/or your participation in the application and selection processes (for example, the online application process or interviews), please call 848-932-3973 or e-mail us .
Rutgers University is an equal access/equal opportunity institution. If you have trouble accessing this page because of a disability, please contact us at 732.745.7378 or via email at OneSource@Rutgers.edu .
Rutgers University participates in the E-Verify program as required by law. Learn more about the E-Verify program .
For technical assistance with the applicant tracking system (login, filling out your application, resetting your password, etc.) please contact the ROCS Help Desk at 848-932-4444 or ROCS@hr.rutgers.edu .
To learn more about Rutgers University’s commitment to diversity and inclusion on its campuses, click here .
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
