Position Details

Position Information

Recruitment/Posting Title
Consulting Application Developer

Job Category
Staff & Executive - Information Technology

Department
Enterprise Application Service

Posting Summary

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

Among the key duties of this position are the following:

• Analyzes, plans, designs, developments, implements , and maintains support of University central and departmental standardized ETL and report processes, as well as, integration with both internal and external data partners.
• Develops processes to assist in clinical research efforts.
• Involves with ingesting data from a variety of university data sources.
• Adapts and helps lead standard methodologies for ETL development.
• Works with the research leads and other technical teams, this position designs and develops ETL workflows to reshape the data into consumable formats for research and reporting needs.
• Acts as an Honest Broker within the Clinical & Research environment that keeps sets of confidential information but distributes parts of those set to other entities who should not have access to the entire set.
• Performs file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee.
• Maintains status of data inventory and file transfers.
• Understands and adheres to Rutgers' compliance standards as they appear in RBHS's Corporate Compliance Policy, Code of Conduct and Conflict of Interest Policy.
• Performs other related duties as assigned.

FLSA
Exempt

Grade
37S

Salary Details

Minimum Salary
121608.000

Mid Range Salary
147221.000

Maximum Salary
175737.000

Offer Information

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.

Benefits

Rutgers provides a comprehensive benefits package to eligible employees. The specific benefits vary based on the position and may include:

• 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

Position Status
Full Time

Working Hours

Standard Hours
37.50

Daily Work Shift

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.

Union Description
HPAE 5094

Payroll Designation
PeopleSoft

Seniority Unit

Terms of Appointment
Staff - 12 month

Position Pension Eligibility
ABP

Qualifications

Minimum Education and Experience

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

Certifications/Licenses

Required Knowledge, Skills, and Abilities

• Current experience using ETL Tools/software (for example only: Informatica, ODI, Data Quality and native PL/SQL).
• Proficient in SQL.
• Experience with Data Modeling in a Data Warehouse environment.

Preferred Qualifications

• Current experience with Oracle and MS Sql Server databases.
• Experience with Perl or Shell Scripting, R, SAS is also desirable.
• Prefer proven experience with the EPIC data model and/or related experience with healthcare data.
• EPIC Caboodle Developer Certifications preferred.
• 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 research, reporting and analytics.
• Aptitude for leveraging big-data technologies.
• 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.
• Skills to create and maintain ETL workflows/processes for a myriad of data sources including cloud sources, creating source to target specifications from client requirements and completing development of ETL processes using Oracle PL/SQL, Informatica, R, SAS or any other ETL tools.
• Knowledgeable in reporting tools, decision support systems, data modeling, data design and ETL processing, preferably experienced in EPIC data model and other Healthcare data.
• Experience with data mapping analysis and design.
• Familiar with Data Warehouse concepts and experience with Star Schema.
• Extensive knowledge of data structures, database solutions, and best practice data management principles.
• Strong analytical and problem solving skills.

Equipment Utilized

Physical Demands and Work Environment

• Standing, sitting, walking, talking or hearing.
• No special vision requirements.
• Office environment.
• Moderate Noise.

Special Conditions

Posting Details

Posting Number
25ST1813

Posting Open Date
08/21/2025

Special Instructions to Applicants

Regional Campus
Rutgers Biomedical and Health Sciences (RBHS)

Home Location Campus
Off Campus

City
Somerset

State
NJ

Location Details

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.