Performance and Data Quality Analyst

Position Description Use your big data skills for good! Seattle Public Utilities (SPU) seeks a detail-oriented Performance and Data Quality Analyst (Management System Analyst, MSA) to advance Zero Waste in Seattle by measuring, monitoring, and reporting on performance measures and ensuring the quality of the data used to inform the Solid Waste Line of Business’s (SWLOB’s) leading-edge policies, incentives, and programs. The best candidates for this position excel at communicating technical information to non-technical audiences and have experience collecting and maintaining high-quality data, using complex data sets to optimize efficiency and accuracy and resolve data quality issues, and demonstrate the ability to work effectively across departments to improve data quality and performance. Highly qualified candidates have experience advising management on data processing and reporting systems and implementing recommended solutions. Their experience includes researching, and analyzing data to create options and alternatives, developing automated reports and data dashboards, and identifying and implementing process improvements to existing business operations, such as new systems, procedures, or solutions. If you feel this may be the perfect job for you, please continue reading …and APPLY! About Seattle Public Utilities (SPU):Seattle Public Utilities (SPU) is a Community Centered Utility whose mission is to foster healthy people, environment, and economy by partnering with our community to equitably manage water and waste resources for today and future generations. We deliver high quality, vital services, across four major lines of business: providing water, solid waste, drainage and wastewater services for Seattle residents and businesses. In addition, SPU provides drinking water for 1.5 million regional customers in Seattle and other municipalities. Our customers depend on us to deliver high quality, reliable, and cost-conscious utility services and to achieve the highest benefits possible for every investment we make. For more information about Seattle Public Utilities (SPU), please visit: • SPU Website • Strategic Business Plan SPU commits to Our City Values and Race and Social Justice as core principles that guide our work. We actively take steps to dismantle systemic racism and increase service equity. We value diverse life experiences and strive to create a workplace that is welcoming to all. We take steps to be inclusive and equitable in our recruiting, hiring and promotional opportunities. Why join us? We know work isn't only about what you do it’s also about who you work for and with! SPU provides a fun and family-friendly work environment that supports a work life balance, including: • Family-friendly and multicultural work environment • Generous benefits package • Free public transportation options • City pension plan with employer/employee contributions • Growth potential and advancement opportunities Job Responsibilities • Serve as one of the primary technical advisors to the SWLOB Branch Management on performance data and data quality. • Lead SWLOB system user groups in the collaborative design, development, implementation, and enhancement of internal self-service reports and quality assurance and quality control (QA/QC) reporting tools. • Streamline access to actionable insights by integrating manual management information systems into scalable, automated self-service business intelligence solutions. • Cultivate and maintain strong relationships with external stakeholders to ensure the delivery of timely and accurate data. • Administer data assets developed with software such as Power BI and programming languages such as SQL and R. • Coordinate project plans and/or data processing activities with inter- and intradepartmental partners and/or with vendors to ensure that functions and systems design, modifications, and implementation requirements meet the needs of users, such as contractors, collectors, recycling facilities, and regulators. • Analyze and evaluate the effectiveness of operating practices and procedures in areas such as planning, policy, and program development, performance measurement and evaluation, information management, or similar areas, with the objective of improving managerial effectiveness. • Clearly document code as well as data and reporting-related processes and procedures so that it can be understood and replicated or verified by other analysts. Please note this job advertisement is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Qualifications Experience:Minimum of two (2) years in systems, operations, procedures, research, or analysis. Education:A bachelor’s degree in business or public administration, finance, computer or data science or a related field. Education and Experience Equivalency:Combinations of appropriate education, training, certification, and experience will be evaluated on an individual basis for comparability to the minimum education and experience requirements. Desired Qualifications: • Strong quantitative, analytical, and problem-solving skills, meticulous attention to detail, and comfort with data. Statistical sample design and hypothesis testing skills are a plus. • Experience with end-to-end data work: Querying data sets, performing data QA/QC, doing analysis, producing automated self-service reports, and making recommendations. • Proficient in SQL, preferably Oracle SQL developer, business intelligence and data visualization tools such as Power BI and Tableau, and programming languages, such as R and Python. • High level of proficiency with M365, particularly Excel, Forms, and SharePoint. Proficiency with Visio and Power Platform (e.g. Power Automate, Power Apps) preferred but not required. • Familiarity with best practices for open data, reproducible workflows, and data management. Additional Information How to Apply: • Submit complete City of Seattle online applicationAND • Upload a cover letter that addresses your knowledge, experience, and interest related to this position,AND • A work sample. Your work sample should demonstrate your ability to analyze, validate, and/or communicate data quality insights, such as a script, dashboard, visualization, or report. *** You must submit both a resume and cover letter. If you do not submit these documents, your application will not be considered. Please ensure that ALL documents have successfully been uploaded before submitting your application. *** The full salary range for this position is $40.08 - $46.68 per hour. Benefits:The City of Seattle offers a comprehensive benefits package including vacation, holiday, and sick leave as well as medical, dental, vision, life and long-term disability insurance for employees and their dependents. More information about employee benefits is available on the City's website at: https://www.seattle.gov/human-resources/benefits/employees-and-covered-family-members/most-employees-plans. Who may apply:The City of Seattle encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ, people with disabilities, veterans, and those with diverse life experience. This position is open to all qualified candidates that meet the minimum qualifications. The City of Seattle values diverse perspectives and life experiences. Applicants will be considered regardless of race, color, creed, national origin, ancestry, sex, marital status, disability, religious or political affiliation, age, sexual orientation, or gender identity. If you have any questions, please contact Katie Muzzin [email protected] Learn more about Seattle Public Utilities at our web page www.seattle.gov/util/. The City of Seattle offers a comprehensive benefits package including vacation, holiday and sick leave as well as medical, dental, vision, life and long-term disability insurance for employees and their dependents.