Be an early applicantLess than 25 applicants

Company

Original Job Post

Rutgers University · 2 days ago

ETL Developers - Consulting Application Developer

Somerset, NJ

Full-time

Onsite

Mid, Senior Level

$145K/yr - $145K/yr

7+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

EducationHigher Education

Insider Connection @Rutgers University

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Provides development and production support for the Business Intelligence infrastructure including data warehouses, data marts, data models, data services, views, and reports.

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.

Develops processes to assist in clinical research efforts with minimal supervision.

Designs and develops ETL workflows to reshape data into consumable formats for research and reporting needs.

Acts as an Honest Broker within the Clinical & Research environment, maintaining confidentiality and data integrity.

Performs file management of sensitive data into and out of the CRDW environment, adhering to compliance standards.

Performs other related duties as assigned.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Healthcare data analysisETL toolsSQLData modelingOracleMS SQL ServerPerlShell ScriptingRSASBig data technologiesBusiness intelligenceData securityTechnical documentationETL workflowsCloud sourcesReporting toolsDecision support systemsEPIC data modelData mappingData warehouse conceptsStar SchemaData structuresDatabase solutionsData managementProblem solvingCustomer serviceInterpersonal skillsCommunicationHealthcare data

Required

Bachelor’s degree or an equivalent combination of education and/ or experience in system design and development.

A minimum of seven years in an analytical and programming environment with emphasis on healthcare data for research, reporting and analytics or equivalent experience.

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.

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 & 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