Data Management - Data Engineer III
The Data Management Engineer III for the URMC Enterprise Data Management team will be responsible for the design, development and support for reporting projects as they relate to the URMC’s Clinical, Revenue Cycle Data, Quality and Research areas.
Under general direction of the Senior Manager – Data Management Development, the Data Engineer III will be the key interface in operationalizing data and analytics on behalf of the business unit(s) and organizational outcomes. This role will require both creative and collaborative working with IT and the wider business. It will involve evangelizing effective data management practices and promoting better understanding of data and analytics. The Data Engineer III will also be tasked with working with key business stakeholders, IT experts and subject-matter experts to plan and deliver optimal analytics and data science solutions.
This position will interact with multiple disciplines of the Medical Center including, but not limited to Clinical, Financial, Quality, Research, Operations to ensure data services needs are met. 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.
Responsible for 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
Supports the data architect to provide best solutions to meet project’s data needs
Provides technical leadership and mentorship to team members
Evaluates team members work efforts and provides performance feedback.
Assigns work items to other team members.
Receives direction from Data Management Sr Manager.
Data warehouse design and development:
Understands and learns EMR workflows to translate between the transactional systems and the data repository
Develops standard dimensional data model optimized for performance and ease of reporting
Develops 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 UR Medicine eco-system of applications
Build data pipelines
Performs proper testing and validation techniques to ensure accuracy and integrity of reported or extracted data and documents the unit test and validation processes used
Develops new and supports maintenance of existing reports and data sets contributing to maintaining the report inventory
Obtains and maintain Data Model and/or reporting tools certifications or training as needed and/or maintains current knowledge via self-study for reporting tools and reporting programming techniques
Provides on call support as needed for business continuity and operations
Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required;
Graduate degree preferred
4-5 years of related experience required;
2-3 years in a supervisory capacity preferred;
or equivalent combination of education and experience required
7 years of related experience, with 3 years of report development experience preferred
Proven ability to work under pressure in a fast-paced environment required
Possess ability to analyze workflow and process build and changes and utilize technology to perform complex data analysis required
Knowledge about various architectures, patterns and protocols such as SSID, SSIS, ODBC, JDBC, unified data management architecture (UDM), event-driven architecture, real-time data flows, non-relational repositories, data virtualization, cloud enablement, etc. required
Strong experience with popular database programming languages including T-SQL, PL/SQL, others relational Database Management Systems required
Strong architectural understanding and knowledge of Data Virtualization Tools such as Denodo required
Basic experience working with popular data discovery, analytics and BI software tools like Tableau, Qlik, PowerBI and others for semantic-layer-based data discovery required
Report Development experience (one or more SQL, SSRS, Crystal Reports, Tableau, Spotfire and PowerBI) required
Healthcare information systems experience preferred
Epic Systems Caboodle Developer – (Required to obtain certification in 1 st year) required
The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University’s mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.
How To Apply
All applicants must apply online.
EOE Minorities/Females/Protected Veterans/Disabled
Pay Range: $ 65,000 - $135,000 Annually
The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job’s compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.
Apply for Job
Location: Health Sciences
Full/Part Time: Full-Time