University of Rochester Advancement · 1 day ago
Data Warehouse Developer II
United States
Full-time
Remote
Mid Level
$70K/yr - $105K/yr
4+ years expThe University of Rochester is committed to fostering an inclusive community and is seeking a Data Warehouse Developer II. This role involves the design, development, implementation, and support of various components for the enterprise data warehouse, ensuring data services needs are met and supporting reporting projects.
Higher Education
Responsibilities
Responsible for the design, development, implementation, and support of various components for the enterprise data warehouse and associated data sources
Provides support for reporting projects and works on projects as assigned
Interacts with multiple disciplines to ensure data services needs are met
Works collaboratively to build a foundation for integrated analytical applications/extracts in SQL tools (SSIS/SSRS/T-SQL) as well as ETL development using Informatica, Virtual and Physical data warehousing, Epic Systems and reporting BI tools
Supports additional projects and requests to perform analysis and/or programming addressing challenging tasks as needed
Acts as a resource for lower level staff
Develops SQL Server by understanding the security model and schema objects, including tables, indexes and applied constraints, functions, and stored procedures
Views and advances T-SQL programming
Implements ETL (Informatica) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse with guidance
Performs proper testing and validation techniques to ensure accuracy and integrity of reported or extracted data and document the unit test and validation processes used
Develops new and supports maintenance of existing reports and data sets contributing to maintaining the report inventory
Utilizes EMR workflows to translate between the transactional systems and the data repository
Utilizes standard dimensional data model optimized for performance and ease of reporting
Provides development support for integrated administration tools for managing and monitoring the Data Warehouse
Learns new technologies related to virtual data warehousing
Works with clinical, financial, and business requirements related to reporting applications support for the eco-system of applications
Manages requests and/or components of larger projects with appropriate documentation and status reports
Assists Senior Developers with requests and/or components of larger projects with appropriate documentation and status reports
Obtains and maintains Data Model and/or reporting tools certifications or training as needed
Maintains current knowledge via self-study for reporting tools and reporting programming techniques
Responds 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 duties as assigned
Qualification
Required
Associate's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering and 4 years of relevant experience required
TSQL experience (MSSQL Server) required
ETL Development experience (Informatica), some report development (SSRS, Tableau) required
Ability to work professionally and progressively in a matrix organization and to work under pressure in a fast-paced environment, as well as the ability and initiative to learn new technologies required
Development, analytical and problem solving skills required
Good customer service orientation and communication skills required
Knowledge of relational data bases and star schemas required
Skills with Microsoft Office (Including Office & Visio). Must be proficient in Microsoft SQL Server Management Studio required
Preferred
Experience with healthcare information systems preferred
Experience with Epic Systems preferred
EPIC - EPIC Certification upon hire preferred
Company
University of Rochester Advancement
The University of Rochester, one of the nation’s top private research universities, has built a national caliber advancement program in support of the largest campaign in the University’s history.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase