Consulting Application Developer

Overview

Rutgers, The State University of New Jersey, stands among the nation’s highest‑ranked, most diverse public research universities. The Office of Information Technology (OIT) is Rutgers’ enterprise IT office, providing university‑wide services such as the Rutgers network, email, calendaring, identity management, data centers, help desk support, wireless connectivity, and information security, risk and compliance services. For more information, please visit (Use the "Apply for this Job" box below)..edu
.

Rutgers is seeking a Consulting Application Developer for the Office of Information Technology – Enterprise Application Services (OIT‑EAS). The role 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 primarily focused within the Clinical Research environment, working in a HIPAA‑compliant environment.

• Analyzes, plans, designs, develops, implements, and maintains support for university‑wide ETL and reporting processes, and integrates with internal and external data partners.
• Develops processes to assist in clinical research efforts.
• Ingests data from a variety of university data sources.
• Adapts and leads standard methodologies for ETL development.
• Designs and develops ETL workflows to reshape data into consumable formats for research and reporting needs.
• Acts as an Honest Broker within the Clinical & Research environment, distributing portions of confidential data while protecting the entire set.
• Performs file management of sensitive data into and out of the CRDW environment with approval from the Data Governance Committee.
• Maintains status of data inventory and file transfers.
• Understands and adheres to Rutgers’ compliance standards as outlined in RBHS’s Corporate Compliance Policy, Code of Conduct, and Conflict of Interest Policy.
• Performs other related duties as assigned.

Minimum Education and Experience

• Bachelor’s degree in a technical field (equivalent education, experience, or training may be substituted).
• A minimum of seven (7) years in an analytical and programming environment with emphasis on healthcare data for research, reporting, and analytics.

• Current experience using ETL tools/software (e.g., Informatica, ODI, Data Quality, native PL/SQL).
• Proficient in SQL.
• Experience with data modeling in a data warehouse environment.

• Experience with Oracle and Microsoft SQL Server databases.
• Experience with Perl, Shell Scripting, R, or SAS.
• Proven experience with the EPIC data model and/or related healthcare data.
• EPIC Caboodle Developer Certification preferred.
• Customer service mindset and professional courtesy.
• Experience with data modeling for research, reporting, and analytics.
• Aptitude for leveraging big‑data technologies.
• Understanding of complex, integrated business intelligence and report data modeling.
• Understanding of user authentication and data access authorization security models.
• Excellent written, oral, and interpersonal skills with the ability to foster working relationships.
• Excellent technical documentation, analytical, and research skills.
• Skill in creating and maintaining ETL workflows for diverse data sources, including cloud sources, and developing ETL processes using Oracle PL/SQL, Informatica, R, SAS, or other tools.
• Knowledgeable in reporting tools, decision support systems, data modeling, data design, and ETL processing, especially within the EPIC data model and healthcare data.
• Experience with data mapping analysis and design.
• Familiarity with data warehouse concepts and star schema.
• Extensive knowledge of data structures, database solutions, and best‑practice data management principles.
• Strong analytical and problem‑solving skills.

• 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

$121,608…