Rutgers University
Consulting Application Developer
Rutgers University, New Brunswick, New Jersey, us, 08933
Position DetailsPosition InformationRecruitment/Posting Title
Consulting Application Developer
Job Category
Staff & Executive - Information Technology
Department
OIT-Enterprise Application Services
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) provides university-wide services and support and collaborates with department and unit IT professionals on projects and initiatives for the Rutgers community. OIT's services and systems include the Rutgers network; email and calendaring systems; IDs/passwords and identity management; data centers; computer labs; help desk support; wireless connectivity; a software portal; information security, risk, and compliance services; research computing; and many others.
Posting Summary
Rutgers, The State University of New Jersey, is seeking an ETL Developer for the Office of Information of 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:
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.With minimal supervision, develops processes to assist in clinical research efforts.Involved with ingesting data from a variety of university data sources.Adapts and helps lead standard methodologies for ETL development.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.Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee.Position Status
Full Time
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.
FLSA
Exempt
Annual Minimum Salary
119693.00
Annual Mid Range Salary
144903.00
Annual Maximum Salary
172969.00
QualificationsMinimum Education and Experience
Bachelor's degree.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.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.Customer service mindset, professional courtesy, respect and consistent positive communications to team members and clients is essential to delivering great work experiences.Excellent written, oral, and interpersonal skills and the ability to foster working relationships with users and peers.Physical Demands and Work EnvironmentPHYSICAL DEMANDS:
Standing, sitting, walking, talking or hearing. No special vision requirements.WORK ENVIRONMENT:
Office environment. Moderate Noise.Posting DetailsPosting Number
24ST2023
Posting Open Date
08/21/2024
Regional Campus
Rutgers Biomedical and Health Sciences (RBHS)
Home Location Campus
Off Campus
City
Somerset
State
NJ#J-18808-Ljbffr
Consulting Application Developer
Job Category
Staff & Executive - Information Technology
Department
OIT-Enterprise Application Services
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) provides university-wide services and support and collaborates with department and unit IT professionals on projects and initiatives for the Rutgers community. OIT's services and systems include the Rutgers network; email and calendaring systems; IDs/passwords and identity management; data centers; computer labs; help desk support; wireless connectivity; a software portal; information security, risk, and compliance services; research computing; and many others.
Posting Summary
Rutgers, The State University of New Jersey, is seeking an ETL Developer for the Office of Information of 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:
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.With minimal supervision, develops processes to assist in clinical research efforts.Involved with ingesting data from a variety of university data sources.Adapts and helps lead standard methodologies for ETL development.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.Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee.Position Status
Full Time
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.
FLSA
Exempt
Annual Minimum Salary
119693.00
Annual Mid Range Salary
144903.00
Annual Maximum Salary
172969.00
QualificationsMinimum Education and Experience
Bachelor's degree.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.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.Customer service mindset, professional courtesy, respect and consistent positive communications to team members and clients is essential to delivering great work experiences.Excellent written, oral, and interpersonal skills and the ability to foster working relationships with users and peers.Physical Demands and Work EnvironmentPHYSICAL DEMANDS:
Standing, sitting, walking, talking or hearing. No special vision requirements.WORK ENVIRONMENT:
Office environment. Moderate Noise.Posting DetailsPosting Number
24ST2023
Posting Open Date
08/21/2024
Regional Campus
Rutgers Biomedical and Health Sciences (RBHS)
Home Location Campus
Off Campus
City
Somerset
State
NJ#J-18808-Ljbffr