Description
Data Analyst III
Pitt IT Analytics - Pennsylvania-Pittsburgh - (26000419)
Job Summary - We are seeking a Senior Data Analyst to join our team and play a critical role in transforming complex data into actionable insights for our users. This position will leverage analytics tools and platforms to analyze large datasets, develop comprehensive reporting solutions, and drive data-informed decision-making across the organization.
Key Responsibilities
Analyze complex datasets using SQL, Tableau, Alteryx & Snowflake to extract meaningful insights & identify trends
Design, develop & maintain interactive dashboards & reports in Tableau that enable stakeholders to monitor key performance indicators & make data-driven decisions
Write efficient, optimized SQL queries to extract, transform & analyze data from multiple sources
Build automated data workflows using Alteryx to streamline reporting processes & improve data quality
Partner with business stakeholders to understand their analytical needs & translate them to technical requirements & solutions
Job Qualifications
3+ years of professional experience in data analysis or related role
Expert-level proficiency in SQL, including complex queries, joins, subqueries, window functions & query optimization
Strong experience with Tableau for dashboard & report development, including calculated fields, parameters & advanced visualizations
Working knowledge of Python, R, or similar programming languages for data manipulation & analysis
Strong knowledge of data manipulation, cleaning & wrangling techniques
Applicants should include salary requirements in cover letter.
Pitt Digital provides innovative services to support teaching, learning, research, and administrative functions at the University. We are committed to leveraging resources to enhance the experience of students, faculty, and staff; drive the digitization of campus; facilitate community engagement; and accelerate regional impact.
The University offers a robust retirement savings plan with 100% employer match, 150% after vesting. 11 Paid Holidays. Paid Vac, Sick, Personal. Add'l Winter Recess Paid Time Off. Paid Parental Leave. Above-average Employer Contribution toward Medical, Prescription Drug, Dental, Vision, Life, and more. Education benefits for staff, spouses/partners, dependents. Student loan assistance. Free transit pass.
Join the team responsible for strategy, implementation, and maintenance of technology at the University of Pittsburgh—ranked by Forbes among Amazon, CDW, Cisco Systems, Google, LinkedIn, and Microsoft as one of "America's Best Large Employers."
Job Summary
Evaluates business requirements and performs advanced data integration and analysis. Develops advanced analytical and reporting tools utilizing multiple sources of integrated data. Provides technical support.
Essential Functions
Must have the ability to work with PC equipment and related hardware/software and telephony video-conferencing systems. Must have good written and verbal communication skills, as well as, analytical, organizational, planning, and strong leadership skills. Must have a proficient knowledge of IT.
Physical Effort
Generally sedentary desk work with computer-keyboard-video phone other than traveling to other buildings on campus for meetings/events on occasion. Must be able to sit or stand for prolonged periods of time.
Assignment Category: Full-time regular
Job Classification: Staff.Data Analyst III
Job Family: Information Technology
Job Sub Family: Analytics
Campus: Pittsburgh
Minimum Education Level Required: Bachelor's Degree
Minimum Years of Experience Required: 5
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: M-F bus hrs EST. On occasion, some evening and weekend work may be necessary depending on business load, project timeline requirements, urgent support, or scheduled downtime changes. May be responsible for manning an escalation/on-call phone number.
Work Arrangement: Hybrid: Combination of On-Campus and Remote work as determined by the department.
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: Cover Letter
PI281744618