Lead Data Wareshouse Developer

Rochester, NY 14602

Posted: 05/30/2019 Job Number: 201457 Pay Rate: $90,000.00


As a Lead AP Data Warehouse and Management Developer for the Enterprise Data Management team you will be responsible for the design, development, implementation, and support of various components for the enterprise data warehouse and associated data sources. Provide data modeling support for reporting projects as they relate to the 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 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.

Specific Responsibilities:

Database Development: (30%)
  • 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
  • Perform data modeling to transform raw data into star schema structured data sources for BI tools consumption

Extract/Data Set Development: (30%)
  • 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 (10%)
  • 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
  • Perform data modeling analysis and design for structured data bases for the BI toolkit fabric
  • Learn new technologies related to virtual data warehousing

Independently managing projects and requests (20%)

  • 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
  • Responds to, solves and makes decisions on more complex/non-routine business requests with limited to moderate risk
  • Responsible for own work and contributing to the team, department and organizational results
  • Assess and estimate requests to determine scope and efforts
  • Respond promptly to all problems keeping in mind the computing environment supports a user community that requires access to critical patient care and business information 24 hours a day / 7 days a week

Other responsibilities (10%)

  • 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


  • Bachelor's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering, and 4-5 years of related experience, preferably 2-3 years in a supervisory capacity; or an equivalent combination of education and experience


  • 5 years relevant work 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 have an understanding of relational data bases and star schemas
  • Possess ability to analyze workflow and process build and changes and utilize technology to perform complex data analysis
  • Studied and experience with the Kimball methodologies of data warehousing techniques and structures

Preferred Technical Skills
  • 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 (SQL, SSRS, Crystal Reports, Tableau, SpotFire preferred)
  • Healthcare information systems experience
  • Experience with Epic Systems preferred

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.