Marsh & McLennan Companies has flagged the Application Developer job as unavailable. Let’s keep looking.

Recruitment/Posting Title ETL Developers – 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 (Business Intelligence and Data Analytics Systems) for the Office of Information of Technology – Enterprise Application Services (OIT-EAS).

Among the key duties of this position are the following:

  • 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).
  • 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.
  • Understands and adheres to Rutgers’ compliance standards as they appear in RBHS’s Corporate Compliance Policy, Code of Conduct and Conflict of Interest Policy.
  • Performs other related duties as assigned.

Position Status Full Time

Hours Per Week 

Daily Work Shift 

Work Arrangement 

FLSA Exempt

Grade 37S

Position Salary 

Annual Minimum Salary 117808.000

Annual Mid Range Salary 142621.000

Annual Maximum Salary 170245.000

Standard Hours 37.50

Union Description HPAE, Local 5094

Payroll Designation PeopleSoft

Benefits 

Rutgers offers a comprehensive benefit program to eligible employees. For details, please go to http://uhr.rutgers.edu/benefits/benefits-overview.

Rutgers also offers a benefit program to eligible full-time postdoctoral fellow students. For details, please go to https://finance.rutgers.edu/healthcare-risk/insurance/postdoctoral-health-insurance.

Seniority Unit

Terms of Appointment Staff - 12 month

Position Pension Eligibility ABP

  • Minimum Education and Experience
  • 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.

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

Preferred Qualifications

Equipment Utilized

Physical Demands and Work Environment

  • Special ConditionsMultiple vacancies

Posting Number 23ST1869

Posting Open Date 07/06/2023

Special Instructions to Applicants

Regional Campus Rutgers Biomedical and Health Sciences (RBHS)

Home Location Campus Off Campus

City Somerset

State NJ

Location Details

Read Full Description
Confirmed 10 hours ago. Posted 12 days ago.

Discover Similar Jobs

Suggested Articles