UW Facilities needs to recommend and implement solutions for its energy management platform based on statistical and data analysis to improve utility services, campus sustainability, and regulatory compliance. This requires a dedicated data analyst to support the platform, document functional requirements, and inform operational performance metrics.
Requirements
- Proficiency in SQL with experience creating complex queries, stored procedures, functions, triggers, and report writing/creation/modification.
- Experience designing and structuring relational databases and organizing asset frameworks.
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Experience as a systems administrator (standing up virtual servers, setting firewall rules, managing updates and backup policies, etc.).
- Demonstrated strong written/oral communication skills, technical documentation skills, and status reporting.
- Report writing skill set using SQL Server Reporting Services (SSRS) or Tableau.
- Experience with the AVEVA (formerly OSIsoft) PI System or other data management system built specifically to collect, store, and manage sensor and time series operational data.
Responsibilities
- Design, develop, configure, recommend, and implement features, customizations, and product functionality improvements for systems supported by this position.
- Perform requirements gathering with customers and stakeholders to support the collection, organization, analysis, and distribution of campus wide energy data.
- Implement processes and procedures for the successful integration of new large data sets.
- Develop written procedures and program implementation documentation for users and online support resources.
- Provide user training and support for campus-wide solutions and serve as an advocate and subject matter expert for supported applications.
- Support regular application and license upgrades of vendor provided solutions.
- Analyze a wide range of data integrations between internal and external applications.
Other
- Bachelor’s degree in information technology, computer science, Engineering, physical sciences in engineering, information sciences, facility engineering, or equivalent experience.
- 3 years of experience administering an enterprise data management platform, preferably in the energy or utility sector.
- Positive interpersonal skills that include collaboration, taking different perspectives, and listening.
- Related technical customer service experience.
- Experience working with clients to understand and translate their requirements.
