Rutgers University
Consulting Application Developer
Rutgers University, Franklin Park, New Jersey, United States
Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the
Apply for this Job
link/button. If you would like tobookmark this position for later review, click on the
Bookmark
link. If you would like to print a copy of this position for your records, click on the
Print Preview
link. Job Category Staff & Executive - Information Technology Department Overview Rutgers, The State University of New Jersey, stands among the nation’s highest-ranked, most diverse public research universities. The oldest, largest, and top-ranked public university in the New York/New Jersey metropolitan area, you’ll find us at our main locations in three New Jersey cities, and our footprint can be seen around the region. As one of the nation’s most diverse universities, Rutgers draws strength from the rich variety of perspectives and life experiences of our community. We’re an academic, health, and research powerhouse and a university of opportunity.
The Office of Information Technology ( OIT ) is Rutgers’ enterprise IT office. 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. OIT’s staff members work closely with the broader university community to advance Rutgers’ missions of teaching, research, and service. For more information, please visit
https://it.rutgers.edu. 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, this position 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. Working 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. Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee. Maintain status of data inventory and file transfers. FLSA FLSA Exempt Grade Grade 37S Salary Details Salary Details A maximum of $172969 is budgeted for this position. Minimum Salary Minimum Salary 121608.000 Mid Range Salary 147221.000 Maximum Salary 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. Rutgers offers a comprehensive benefits package to eligible employees, based on position, which includes: 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 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 Union Description HPAE 5094 Payroll Designation Payroll Designation PeopleSoft Seniority Unit Terms of Appointment Terms of Appointment Staff - 12 month Position Pension Eligibility Position Pension Eligibility ABP Qualifications Minimum Education and Experience 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. 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. Physical Demands and Work Environment
PHYSICAL DEMANDS :
Standing, sitting, walking, talking or hearing. No special vision requirements. Special Conditions Posting Number Posting Number 24ST2023 Posting Open Date Posting Open Date 08/21/2024 Special Instructions to Applicants Regional Campus Regional Campus Rutgers Biomedical and Health Sciences (RBHS) Home Location Campus Home Location Campus Off Campus City City Somerset State State NJ Position Information Recruitment/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 oldest, largest, and top-ranked public university in the New York/New Jersey metropolitan area, you’ll find us at our main locations in three New Jersey cities, and our footprint can be seen around the region. As one of the nation’s most diverse universities, Rutgers draws strength from the rich variety of perspectives and life experiences of our community. We’re an academic, health, and research powerhouse and a university of opportunity.
The Office of Information Technology ( OIT ) is Rutgers’ enterprise IT office. 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. OIT’s staff members work closely with the broader university community to advance Rutgers’ missions of teaching, research, and service. For more information, please visit
https://it.rutgers.edu.
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, this position 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. Working 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. Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee. Maintain status of data inventory and file transfers. FLSA Exempt Grade 37S Salary Details A maximum of $172969 is budgeted for this position. 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 offers a comprehensive benefits package to eligible employees, based on position, which includes:
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 Life insurance coverage Employee discounts programs For detailed information on benefits and eligibility, please visit:
http://uhr.rutgers.edu/benefits/benefits-overview
. Position Status Full Time Working Hours (per week) 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. 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
PHYSICAL DEMANDS :
Standing, sitting, walking, talking or hearing. No special vision requirements. WORK ENVIRONMENT :
Office environment. Moderate Noise. Special Conditions Posting Details Posting Number 24ST2023 Posting Open Date 08/21/2024 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. Affirmative Action/Equal Employment Opportunity Statement It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement Supplemental Questions
Required fields are indicated with an asterisk (*). * Do you have a minimum of a Bachelor’s Degree in a technical field or an equivalent combination of education and/or experience?
Yes No
* Do you have a minimum of seven (7) years in an analytical and programming environment with emphasis on healthcare data for research, reporting and analytics?
Yes No
Required Documents
Resume/CV Cover Letter/Letter of Application Optional Documents
List of Professional References (contact Info) It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement .
In compliance with the Americans with Disabilities Act (ADA) and the New Jersey Law Against Discrimination (NJLAD), if you have a disability and would like to request an accommodation with regard to your access to and/or your participation in the application and selection processes (for example, the online application process or interviews), please call 848-932-4444 or e-mail us . Rutgers University is an equal access/equal opportunity institution. If you have trouble accessing this page because of a disability, please contact us at 732.745.7378 or via email at OneSource@Rutgers.edu . For technical assistance with the applicant tracking system (login, filling out your application, resetting your password, etc.) please contact the ROCS Help Desk at 848-932-4444 or ROCS@hr.rutgers.edu .
To learn more about Rutgers University’s commitment to diversity and inclusion on its campuses, click here .
#J-18808-Ljbffr
Apply for this Job
link/button. If you would like tobookmark this position for later review, click on the
Bookmark
link. If you would like to print a copy of this position for your records, click on the
Print Preview
link. Job Category Staff & Executive - Information Technology Department Overview Rutgers, The State University of New Jersey, stands among the nation’s highest-ranked, most diverse public research universities. The oldest, largest, and top-ranked public university in the New York/New Jersey metropolitan area, you’ll find us at our main locations in three New Jersey cities, and our footprint can be seen around the region. As one of the nation’s most diverse universities, Rutgers draws strength from the rich variety of perspectives and life experiences of our community. We’re an academic, health, and research powerhouse and a university of opportunity.
The Office of Information Technology ( OIT ) is Rutgers’ enterprise IT office. 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. OIT’s staff members work closely with the broader university community to advance Rutgers’ missions of teaching, research, and service. For more information, please visit
https://it.rutgers.edu. 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, this position 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. Working 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. Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee. Maintain status of data inventory and file transfers. FLSA FLSA Exempt Grade Grade 37S Salary Details Salary Details A maximum of $172969 is budgeted for this position. Minimum Salary Minimum Salary 121608.000 Mid Range Salary 147221.000 Maximum Salary 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. Rutgers offers a comprehensive benefits package to eligible employees, based on position, which includes: 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 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 Union Description HPAE 5094 Payroll Designation Payroll Designation PeopleSoft Seniority Unit Terms of Appointment Terms of Appointment Staff - 12 month Position Pension Eligibility Position Pension Eligibility ABP Qualifications Minimum Education and Experience 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. 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. Physical Demands and Work Environment
PHYSICAL DEMANDS :
Standing, sitting, walking, talking or hearing. No special vision requirements. Special Conditions Posting Number Posting Number 24ST2023 Posting Open Date Posting Open Date 08/21/2024 Special Instructions to Applicants Regional Campus Regional Campus Rutgers Biomedical and Health Sciences (RBHS) Home Location Campus Home Location Campus Off Campus City City Somerset State State NJ Position Information Recruitment/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 oldest, largest, and top-ranked public university in the New York/New Jersey metropolitan area, you’ll find us at our main locations in three New Jersey cities, and our footprint can be seen around the region. As one of the nation’s most diverse universities, Rutgers draws strength from the rich variety of perspectives and life experiences of our community. We’re an academic, health, and research powerhouse and a university of opportunity.
The Office of Information Technology ( OIT ) is Rutgers’ enterprise IT office. 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. OIT’s staff members work closely with the broader university community to advance Rutgers’ missions of teaching, research, and service. For more information, please visit
https://it.rutgers.edu.
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, this position 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. Working 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. Perform file management of sensitive data into and out of the CRDW environment with the approval of the Data Governance Committee. Maintain status of data inventory and file transfers. FLSA Exempt Grade 37S Salary Details A maximum of $172969 is budgeted for this position. 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 offers a comprehensive benefits package to eligible employees, based on position, which includes:
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 Life insurance coverage Employee discounts programs For detailed information on benefits and eligibility, please visit:
http://uhr.rutgers.edu/benefits/benefits-overview
. Position Status Full Time Working Hours (per week) 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. 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
PHYSICAL DEMANDS :
Standing, sitting, walking, talking or hearing. No special vision requirements. WORK ENVIRONMENT :
Office environment. Moderate Noise. Special Conditions Posting Details Posting Number 24ST2023 Posting Open Date 08/21/2024 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. Affirmative Action/Equal Employment Opportunity Statement It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement Supplemental Questions
Required fields are indicated with an asterisk (*). * Do you have a minimum of a Bachelor’s Degree in a technical field or an equivalent combination of education and/or experience?
Yes No
* Do you have a minimum of seven (7) years in an analytical and programming environment with emphasis on healthcare data for research, reporting and analytics?
Yes No
Required Documents
Resume/CV Cover Letter/Letter of Application Optional Documents
List of Professional References (contact Info) It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement .
In compliance with the Americans with Disabilities Act (ADA) and the New Jersey Law Against Discrimination (NJLAD), if you have a disability and would like to request an accommodation with regard to your access to and/or your participation in the application and selection processes (for example, the online application process or interviews), please call 848-932-4444 or e-mail us . Rutgers University is an equal access/equal opportunity institution. If you have trouble accessing this page because of a disability, please contact us at 732.745.7378 or via email at OneSource@Rutgers.edu . For technical assistance with the applicant tracking system (login, filling out your application, resetting your password, etc.) please contact the ROCS Help Desk at 848-932-4444 or ROCS@hr.rutgers.edu .
To learn more about Rutgers University’s commitment to diversity and inclusion on its campuses, click here .
#J-18808-Ljbffr