Data Manager

University of Pittsburgh

Date: 06/03/2020

Location: Pittsburgh

A Data Manager is sought for a growing data center which serves the schools of the health sciences. This person will manage the data lifecycle from ETL to data destruction in a SQL Server environment. The incumbent will be required to work in both on-prem and cloud data repositories which will include SQL as a service and NoSQL options.†

The Data Manager will receive data and load into SQL Server. The data will arrive in various formats including SAS, CSV, and fixed width. The format will change based on the data owner. All actions must be performed in our secure HIPAA compliant environment according to data center policies and procedures and thoroughly documented. The data manager will monitor the SQL Server systems and make recommendations to improve performance. The incumbent will work with Principal Investigators and their teams to create analytic datasets in SQL server. This will require gathering specifications and listening to requirements from various teams. The position must be responsive to different requirements from different groups.†

In some cases, you will serve as an Honest Broker. Must be able to consider various options for data collection and recommend solution that works for customer. The candidate must be able to evaluate different performance metrics and recommend ETL solutions. Must be able to work as part of a team with strong communication skills.†

Required skills include strong SQL Server skills with the ability to write advanced queries and excellent organizational, documentation and communication skills with proficiency in Microsoft Office. Familiarity with Execution Plans and optimization a plus. Experience with SAS, Stata, Web technologies, C#, Powershell, and health datasets is ideal but not required.

Two years of experience in SQL Server or relational DB. Bachelorís Degree in Computer Science or related area. Experience with relational databases, stored procedures and SQL queries. Required skills include strong SQL Server skills with the ability to write advanced queries and excellent organizational, documentation and communication skills with proficiency in Microsoft Office. Familiarity with Execution Plans and optimization a plus. Experience with SAS, Stata, Web technologies, C#, and health datasets is ideal but not required.

Apply below.