SVC HS Information Technology - Pennsylvania-Pittsburgh - (25005449)
We are seeking a detail-oriented and analytical Data Analyst to join our team. This role is critical to ensuring the accuracy, reliability, and usability of our data pipelines. You will work closely with data engineers and developers to evaluate datasets, test ETL processes, and work with business teams to identify opportunities to improve data quality and accelerate development cycles.
Job Summary
Evaluates business requirements and performs complex data integration and analysis utilizing highly advanced analytical methods while developing advanced and highly complex analytical and reporting tools. Coordinates data projects, provides technical support, and participates in funding development.
Essential Functions
-
Analyze and validate complex datasets across multiple sources and systems.
-
Test and monitor ETL pipelines to ensure performance, accuracy, reliability and scalability.
-
Collaborate with data engineering to troubleshoot and optimize data workflows.
-
Develop and maintain data quality metrics and dashboards.
-
Develop and maintain data quality frameworks, including automated checks and anomaly detection.
-
Develop best practices in data analysis and ETL testing
-
Identify data anomalies and root causes, and recommend corrective actions.
-
Create and maintain documentation for data definitions, lineage, and transformation logic.
-
Support strategic initiatives, ad hoc data requests and reporting needs from stakeholders with advanced data analysis and modeling.
Physical Effort
Light, Little physical effort. Duties are primarily Sedentary. May be required to move objects up to 25 pounds occasionally.
Assignment Category
Full-time regular
Job Family
Information Technology
Minimum Education Level Required
Master's Degree
Minimum Years of Experience Required
7
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.
Additional details about Required Licensure/Certification
Advanced proficiency in SQL and experience with ETL tools Strong experience with cloud data platforms (e.g., Snowflake, AWS Redshift). Proficiency in Python or R for data analysis and automation. Solid understanding of data warehousing, data modeling, and data governance. Excellent communication and leadership skills.
Work Schedule
M-F 8am-4:30pm
Work Arrangement
Hybrid: Combination of On-Campus and Remote work as determined by the department.
Hiring Range
TBD Based Upon Qualifications
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