University of Rochester

University of Rochester logo

Job Information

University of Rochester Data Management Senior Developer - 232116 in Rochester, New York

Data Management Senior Developer Job ID 232116

Location Health Sciences Full/Part Time Full-Time Favorite Job Regular/Temporary Regular Opening

Full Time 40 hours Grade 055 ISD Analytics

Schedule

8 AM-5 PM

Responsibilities

GENERAL PURPOSE:

Provide support for reporting projects as they relate to the URMC’s Clinical, Revenue Cycle Data, Quality and Research areas, as well as, providing process and architectural recommendations, mentor staff, and work on projects as assigned by the Enterprise Data Management Team Leads.

This position will interact with multiple disciplines of the Medical Center including, but not limited to Clinical, Financial, Quality, Research, Operations to insure data services needs are met. Primary responsibilities include administration of enterprise data systems by working closely with Application Reporting Leads, Data Analysts and IT Server Administrators to build a foundation for integrated analytical applications/extracts in Crystal Reports, SQL tools (SSIS/SSRS/T-SQL), Virtual and Physical data warehousing, Epic Systems and reporting BI tools. Other responsibilities include adherence to change management and control, service requests intake documentation and process documentation. Assignment of additional projects and requests to perform analysis and programming addressing challenging tasks may be assigned as needed.

RESPONSIBILITIES:

Database Development:

  • SQL Server development by understanding the security model and schema objects including tables, indexes and applied constraints, functions, stored procedures, Views and advance T-SQL programming

  • Designing ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse

  • Extract/Data Set Development:

  • Perform proper testing and validation techniques to insure accuracy and integrity of reported or extracted data and document the unit test and validation processes used

  • Develop new and support maintenance of existing reports and data sets contributing to maintaining the report inventory

  • Data warehouse design and development:

  • Understand and learn EMR workflows to translate between the transactional systems and the data repository

  • Develop standard dimensional data model optimized for performance and ease of reporting

  • Develop integrated administration tools for managing and monitoring the Data Warehouse

  • Learn new technologies related to virtual data warehousing

    Independently managing projects and requests:

  • Works with clinical, financial and business requirements related to reporting applications support for the UR Medicine eco-system of applications

  • Manage requests and/or components of larger projects with appropriate documentation and status reports

  • Other responsibilities:

  • Obtain and maintain Data Model and/or reporting tools certifications or training as needed and/or maintain current knowledge via self-study for reporting tools and reporting programming techniques

  • Provide on call support as needed for business continuity and operations

    QUALIFICATIONS:

    Required

  • Bachelor's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering

  • 5 plus years of related experience

  • or an equivalent combination of education and experience

  • 5 years of business analysis experience

  • 3 years of report development experience

  • Proven ability to work professionally and progressively in a matrix organization

  • Proven business process design and development skills

  • Proven analytical and problem-solving skills

  • Proven customer service orientation and excellent communication skills

  • Proven ability to work under pressure in a fast-paced environment

  • Ability and initiative to learn new technologies

  • Must understand relational data bases and star schemas

  • Possess ability to analyze workflow and process build and changes and utilize technology to perform complex data analysis

  • All Microsoft Office (Including Office & Visio)

  • SQL experience (MSSQL Server) - Required

  • Must be proficient in Microsoft SQL Management and Business Intelligence Studio

  • Report Development experience (one or more SQL, SSRS, Crystal Reports, Tableau, Spotfire)

  • Healthcare information systems experience

    Experience with Epic Systems preferred

    Epic Systems Cogito or Clarity and Caboodle preferred

    How To Apply

All applicants must apply online.

EOE Minorities/Females/Protected Veterans/Disabled

DirectEmployers