Rutgers, The State University of New Jersey, is seeking a Consulting Application Developer to provide development and production support for the Business Intelligence infrastructure, focusing on the Clinical Research environment and ensuring HIPAA compliance.
Requirements
- 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.
- 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.
- Ability to understand complex, integrated state of the art business intelligence and report data modeling.
Responsibilities
- 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.
Other
- 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.
- Customer service mindset, profession 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.
- Excellent technical documentation, analytical and research skills.
