Closing: 6/16/2021 11:59pm EST
Hiring Range: $43,981 – $54,000 annually
This class is the eighth level in a ten-level Utilities Series devoted to providing operational, technical and maintenance support for the City’s water, wastewater, collection and distribution systems.
Seeking an experienced analyst to develop Power BI reports for the Raleigh Water Department to aid in strategic planning and performance management implementation. This includes translating business requirements into functioning reports and dashboards and interacting and communicating with non-technical users. The analyst will work with a performance and quality assurance team to develop reports, engage with staff for user testing and feedback and promote reports to Power BI. A successful candidate must be highly motivated to perform and learn, able to work collaboratively and independently, detail-oriented, and able to manage assigned tasks and projects from start to finish with input from supervisors.
Duties & Responsibilities:
- Develop and publish Power BI reports and dashboards to meet business requirements.
- Prepare technical reports by collecting, analyzing, and summarizing information and trends.
- Work closely with the departmental subject matter experts to understand the requirements and translate that into a reporting solution.
- Establish and follow guidelines and best practices for analytic development.
- Assist with user testing and troubleshooting.
- Improve systems and processes by studying current practices, following industry trends, completing benchmark studies, and designing modifications.
- Develop and update technical documentation.
- Participate in projects across the Department to forward business plan initiatives.
- Provide professional support including research, analysis and providing program/functional expertise related to the City’s water, wastewater, collection, and distribution systems.
- Coordinate and communicate with internal staff and leaders, external agencies, property owners, design professionals, contractors, and other organizations; recommends and implements processes for the support, maintenance and control of utility programs and systems.
Education and Experience
Bachelor’s degree in environmental science, business or directly related field and two years of related experience. Computer Science, Information Technology, Business Analytics or related degree preferred. Classwork or professional experience with EPA regulatory programs, environmental science or policy, and economics also desirable. Applied experience with research activities in an academic or professional setting very helpful.
An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation.
Licensing/Certifications: None Required
Knowledge, Skills, and Abilities:
- Supervisory principles, practices and techniques (based on assignment).
- Techniques and methods for organizing, prioritizing, assigning and monitoring work (based on assignment).
- Practices and methods of coaching and leading the work of others (based on assignment).
- Principles and practices of program administration and management.
- Water and wastewater treatment methods and collection system maintenance (based on assignment).
- Principles and applications of critical thinking and analysis.
- Principles and methods of qualitative and quantitative research.
- Best practices, trends and emerging technologies.
- Project management principles.
- Modern budget practices.
- Applicable federal, state and local laws, codes, regulations (based on assignment).
- Customer service principles.
- Specialized equipment relevant to area of assignment.
- Modern office technology.
- Supervising and evaluating staff performance (based on assignment).
- Training and coaching staff (based on assignment).
- Coordinating deadlines, prioritizing work demands and assigning/monitoring work performed (based on assignment).
- Gathering data, analyzing findings and applying logic and reason.
- Researching industry trends, solutions and best practices.
- Interpreting, monitoring and reporting data and statistics.
- Determining compliance with applicable regulations and providing enforcement documentation (based on assignment).
- Authoring and preparing original reports, technical documents and resource materials.
- Organizing and maintaining documentation, data, records and files.
- Coordinating deadlines and prioritizing competing demands.
- Interpreting and applying applicable laws, codes, regulations and standards (based on assignment).
- Providing customer service.
- Utilizing a computer and relevant software applications.
- Utilizing communication and interpersonal skills as applied to interaction with coworkers, supervisors, the general public and others to sufficiently exchange or convey information and to receive work direction.
ADA and Other Requirements: Positions in this class typically require: stooping, kneeling, crouching, crawling, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, talking, hearing, seeing and repetitive motions.
Medium Work: Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
Working Conditions: Work is performed in both the field and in an indoor office environment with frequent exposure to hazardous physical conditions (such as mechanical parts, electrical currents, vibration, etc.); frequent exposure to atmospheric conditions (such as fumes, odors, dusts, gases, poor ventilation, etc.); moderate exposure to hazardous materials (such as chemicals, blood and other body fluids); frequent exposure to environmental conditions (such as disruptive people, imminent danger, or a threatening environment); frequent exposure to extreme temperatures, inadequate lighting and movement restrictions; and moderate exposure intense noise or travel.
Note: This job classification description is intended to be generic in nature. It is not necessarily an exhaustive list of all duties and responsibilities. The essential duties, functions and responsibilities and Fair Labor Standards Act (FLSA) designation may vary based on the specific tasks assigned to the position.