Rutgers, The State University of New Jersey, is seeking a ETL Developer/Data Modeler for the Office of Information Technology-Enterprise Application Services (OIT-EAS). This position provides development and production support for the Business Intelligence infrastructure including data warehouses, data marts, data models, data services, views, and reports. The position is also responsible for analysis, planning, design, development, implementation, and maintenance in support of University central and departmental standardized ETL and report processes, as well as, integration with both internal and external data partners.
Among the key duties of this position are the following:
Develops processes for data integrations.
Involved with ingesting data from a variety of university data sources.
Adapts and helps lead standard methodoglies for ETL development.
Designs and develops DB views and shell scripts.
Minimum Education and Experience:
Bachelor’s degree in Computer Science, Information Systems or related technology field or an equivalent combination of education and/or relevant experience in system design, development.
A minimum five (5) years in an analytical and programming environment with emphasis on financial, human resources, student, and/or healthcare applications, critical business areas and analytics, ERPs, systems design, and data modeling.
Required Knowledge, Skills, and Abilities:
Experience with ETL tools such as Informatica and native PL/SQ: programming required.
Customer service mindset, profession courtesy, respect and consistent positive communications to team members and clients is essential to delivering great work experiences.
Experience with data modeling for reporting. Aptitude for leveraging big-data technolgies.
Ability to understand complex, integrated state of the art business intelligence and report data modeling
Ability to understand complex user authentication and data access authorization security models
Excellent written, oral, and interpersonal skills and the ability to foster working relationships with users and peers.
Excellent technical documentation, analytical and research skills..
Knowledgeable in reporting tools, decision support systems, data modeling, data design and ETL processing, preferably experienced in Oracle Financial Cloud ERP and/or Oracle HCM and/or Healthcare data.
Seven (7) years in an analytical and programming environment with emphasis on financial, human resources, student, and/or healthcare applications, critical business areas and analytics, ERPs, systems design, and data modeling.
Additional experience with reporting tools such as OAC, Tableau, BI Publisher, OTBI, ODI preferred.
Peoplesoft or Oracle Financial ERP experience, Oracle Application Development Framework (ADF), PLSQL, JAVA programming, File Based Data Import skills, Web Services, and/or PaaS.
Posting Number: 20ST1752
Location: Off Campus
Internal Number: 120123
About Rutgers University
Rutgers, The State University of New Jersey, is a leading national public research university and the state's preeminent, comprehensive public institution of higher education. Rutgers is dedicated to teaching that meets the highest standards of excellence; to conducting research that breaks new ground; and to turning knowledge into solutions for local, national, and global communities. As it was at our founding in 1766, the heart of our mission is preparing students to become productive members of society and good citizens of the world. Rutgers teaches across the full educational spectrum: preschool to precollege; undergraduate to graduate and postdoctoral; and continuing education for professional and personal advancement. Rutgers is New Jersey's land-grant institution and one of the nation's foremost research universities, and as such, we educate, make discoveries, serve as an engine of economic growth, and generate ideas for improving people's lives.