Rutgers University
Consulting Application Developer
Rutgers University, New Brunswick, New Jersey, us, 08933
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 in a HIPAA compliant environment.
Key Duties
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. 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. 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, professional 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. WORK ENVIRONMENT:
Office environment. Moderate Noise. Special Conditions
All offers of employment are contingent upon successful completion of all pre-employment screenings. 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.
#J-18808-Ljbffr
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. 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. 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, professional 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. WORK ENVIRONMENT:
Office environment. Moderate Noise. Special Conditions
All offers of employment are contingent upon successful completion of all pre-employment screenings. 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.
#J-18808-Ljbffr