Data Analyst

Health Sciences IT (HSIT) is seeking a dynamic professional to fill the role of Data Analyst The HSIT Research team provides support for the six schools of the health sciences. The successful candidate will be responsible for designing, developing, and maintaining software applications that meet the needs of our clients. This position requires a strategic thinker with strong technical skills and the ability to work collaboratively with cross-functional teams to deliver innovative and efficient solutions.

A Data Analyst 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 SQL Server on-prem or Cloud environments. On-prem work will be done in SQL Server with T-SQL and SSDT. When using cloud services skills including Azure Synapse/Data Factory and an understanding of Spark will be helpful.
The Data Manager will receive data and load into SQL Server. The data will arrive in various formats including SAS, CSV, Parquet 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 execution plans and make modifications 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, Power BI, and health datasets is ideal but not required.

Evaluates business requirements and performs moderately advanced data integration and analysis. Develops moderately advanced analytical and reporting tools utilizing integrated data. Provides technical support.

Data ingestion/transformation
Write SQL queries, views, and stored procedures
Work independently on multiple projects
Work with groups to understand and document project requirements
Document project processes
At least 5 years of experience with SQL server

Duties are primarily Sedentary

The University of Pittsburgh is committed to championing all aspects of diversity, equity, inclusion, and accessibility within our community. This commitment is a fundamental value of the University and is crucial in helping us advance our mission, which includes attracting and retaining diverse workforces. We will continue to create and maintain an environment that allows individuals to discover, belong, contribute, and grow, while honoring the experiences, perspectives, and unique identities of all.

The University of Pittsburgh is an Affirmative Action/Equal Opportunity Employer and values equality of opportunity, human dignity and diversity. EOE, including disability/vets.