University of Pittsburgh is hiring: Data Analyst in Pittsburgh

Data Analyst

Health Sciences IT (HSIT) is seeking a dynamic professional to fill the role of Senior Application Developer. 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 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 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.

Job Summary

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

Essential Functions

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

Physical Effort

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.

Assignment Category: Full-time regular

Job Classification: Staff.Data Analyst II

Job Family: Information Technology

Job Sub Family: Analytics

Campus: Pittsburgh

Minimum Education Level Required: Bachelor's Degree

Minimum Years of Experience Required: 3

Will this position accept substitution in lieu of education or experience: Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.

Work Schedule: Monday - Friday /remote/on campus as needed

Work Arrangement: Monday - Friday /remote/on campus as needed

Hiring Range: TBD Based Upon Qualifications

Relocation_Offered: No

Visa Sponsorship Provided: No

Background Check: For position finalists, employment with the University will require successful completion of a background check

Child Protection Clearances: Not Applicable

Required Documents: Resume

Optional Documents: Not Applicable

Please see job description

PI257131510