UW Facilities needs to transform operational data into clear, actionable insights for stakeholders to improve operational efficiency, inform decision-making, and enhance cross-unit collaboration.
Requirements
- Strong proficiency in SQL (T-SQL preferred).
- Experience working with SQL Server and related tools, including SSRS.
- Hands-on experience with data visualization tools like Tableau and Power BI.
- Advanced Excel skills (pivot tables, complex formulas, macros).
- Understanding of ETL concepts and data modeling principles.
- Strong analytical and troubleshooting skills.
- Experience using Python for automation or ETL processes.
Responsibilities
- Develop and maintain complex SQL queries, including CTE-heavy logic and subqueries, for reporting and analysis.
- Analyze operational and business data to identify trends, performance issues, and opportunities for improvement.
- Build reports and dashboards using Tableau, Power BI, SSRS, and Excel, selecting the appropriate tool based on business needs.
- Troubleshoot and enhance existing reports, including query tuning, logic adjustments, and performance optimization.
- Design and refine data models to support new reporting needs, combining existing enterprise models with purpose-built solutions.
- Assist in building ETL processes using SQL or Python, contributing to developing more automated and scalable pipelines.
- Manage ongoing KPI reporting and dashboard development for operational and business metrics.
Other
- Temporary position
- Integrity, trustworthiness, and professionalism.
- Strong problem-solving abilities and comfort working through ambiguity.
- Ability to prioritize and manage multiple projects in a changing environment.
- Clear verbal and written communication.
