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. Minimum Education and Experience: 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. City: Somerset State: NJ Physical Demands and Work Environment: PHYSICAL DEMANDS : Standing, sitting, walking, talking or hearing. No special vision requirements. WORK ENVIRONMENT : Office environment. Moderate Noise. Posting Number: 26ST1897
