Power Budget Data Analyst
Tacoma Power's Rates, Planning, and Analysis (RPA) department is seeking a talented Data Analyst to join our Budget Team! The Budget Team within RPA operates in a fast-paced environment, supporting Tacoma Power's biennial budget development while creating and improving processes and analyses related to budget monitoring and management.
As the Budget Data Analyst, you will perform a lead role in making data and information available to all levels of the organization through accurate reporting, development of new data sources, creation of sustainable data processes and queries, as well as visual storytelling. The ideal candidate will be a detail-oriented problem-solver who is challenge motivated, creative, and committed to delivering ever-increasing value to our internal stakeholders.
In addition to the day-to-day work, this position is expected to perform as a Subject Matter Expert and advisor on budget data and information within the organization, ensuring staff can make the best use of available analytical resources.
The individual selected for this position will join the broader Rates, Planning, & Analysis (RPA) team. Made up of high-performing critical thinkers, RPA is dedicated to continuous learning, innovation, and cross-functional collaboration. The department uses these strengths to best serve Tacoma Power and its ratepayers in financial stewardship, forecasting, and other analytical areas.
This position is eligible for a hybrid work arrangement upon the completion and approval of a telework request.
This position is primarily responsible for the complex design and development of business intelligence tools, data collection mechanisms, data validation, dashboards, metrics, and reports in support of Tacoma Power's Budget program and overarching financial strategy. This involves:
- The preparation of complex financial and operational dashboards, reports, and presentations for staff at all levels, including senior leaders;
- The identification of dashboard/model requirements and data collection needs and the creation of analytical solutions;
- Partnering with stakeholders and management to design business intelligence models, dashboards, metrics and reports;
- Assisting leadership with decision-making by producing dashboards, visuals and reports, and making recommendations based on the information;
- Serving as an internal consultant and liaison with Tacoma Power Sections to provide budget program guidance.
Bachelor's degree in Engineering, Computer Science, Economics, Statistics, Mathematics or directly related field.
2 years of experience in statistical analysis, forecasting, or financial/operational modeling.
*Equivalency: 1 year of directly related work experience = 1 year of relevant higher education
Knowledge & Skills
The ideal candidate would thrive in an environment that requires the ability to both collaborate/work with a team and to work independently on large work efforts. Additionally, they would have the following skills:
- Data analysis and visual storytelling
- Developing logical and consistent systems/processes
- Proficiency with SQL language or an equivalent programming language (e.g. Python, R, etc.) to analyze data and create accurate and sustainable data processes
- Proficiency with Excel and experience with Tableau or a similar data visualization software
- Ability to contribute positively to a diverse and inclusive team culture that values work/life balance
While no prior experience in these specific applications is required, the following are the primary software tools utilized in this position (other than Microsoft Suite): SAP, MySQL, Tableau, Smartsheet
Selection Process & Supplemental Information
This recruitment is being managed by Kye Merritt. If you would like to be notified of similar opportunities or stay connected with things going on at Tacoma Public Utilities and the City of Tacoma, connect with her on LinkedIn.
City of Tacoma Commitment to Diversity and Inclusion
Tacoma's diversity is its greatest asset. Tacoma embraces its multi-cultural and multi-ethnic character. Communities of color and immigrant communities are fundamental to Tacoma's entrepreneurial spirit, workforce, and long-term success. In Tacoma, equity and empowerment are top priorities, meaning that all Tacoma residents must have equitable opportunities to reach their full potential and share in the benefits of community progress. One of our goals is for the City of Tacoma workforce to reflect the community it serves. We actively work to eliminate racial and other disparities and welcome candidates with diverse backgrounds and/or multicultural skill sets and experiences. Our goal is for Tacoma to be an inclusive and equitable place to live, work, and play.
The City of Tacoma is an Equal Opportunity Employer and values diversity in its workplace. Applicants are considered for positions without regard to race, color, religion, sex, national origin, ancestry, age, marital or veteran status, disability, sexual orientation, gender identity, or any other basis prohibited by federal, state, and local laws.
Tacoma Power is an almost 100% hydroelectric, municipally-owned public power utility, located in Tacoma. We serve approximately 170,000 customers as one of the three operating divisions of Tacoma Public Utilities, alongside Tacoma Water and Tacoma Rail. As one of the most livable, walkable cities in the country, you'll find that Tacoma is a great fit for all interests with places to bike, run, hike, and explore, the perks of a big city, and the charm of a small town.
Interested individuals should apply online and attach a detailed resume and cover letter that includes job experience, major responsibilities and accomplishments related to this position.
Reference checks will be conducted on final candidates and appointment is subject to passing a background check.
Communication from the City of Tacoma:
We primarily communicate via e-mail during the application process. E-mails from cityoftacoma.org and/or governmentjobs.com must be placed on your safe domain list to ensure that you receive notifications in a timely manner. As a precaution, you may also want to check your junk e-mail folders.
If you have any additional questions regarding this position, please contact the Human Resources office at (253) 591-5400 before 5pm on the closing date.
The City of Tacoma provides excellent medical, dental and vision plans for the whole family; paid holidays and paid leave; participation in the Tacoma Public Employees' Retirement System (alternate plan for Police/Fire); continuing education and advancement opportunities and a growing variety of City-sponsored health and wellness opportunities and incentives.
Medical Coverage: For eligible employees and their families, including domestic partners and dependent children age 26 or younger.
Dental Coverage: For eligible employees and their families, including domestic partners and dependent children age 26 or younger.
Vision Coverage: For eligible employees and their eligible dependents.
Paid Leave: City employees are entitled to received paid holidays, sick/vacation leave or personal time off (PTO), depending upon union affiliation and appointment type.
Insurance Plans: Employees are covered by a long-term disability plan. Short-term and expanded long-term disability insurance plans are also available to employees. The State Industrial Insurance Act also covers employees.
Deferred Compensation: Income can be set aside on a pretax basis and invested for supplementation of normal retirement income.
Retirement: All employees of the City, except members of the Police and Fire services, Tacoma Rail and certain project employees, are included in the Tacoma Employees' Retirement System. Information on the Tacoma Employees' Retirement System can be found at www.cityoftacoma.org or by calling (253) 502-8200.
Other Employment Information
Direct Deposit: Employees are paid on a bi-weekly schedule by direct deposit.
Salary Increases: Based on satisfactory job performance, the City provides for a regular progression of salary increases for most classifications according to the salary schedule.
Union Affiliation: Many job classifications are covered by union security provisions which require union membership, dues, or payment of equivalent service fees.
Note: The provisions of this job announcement do not constitute an expressed or implied contract. Any provision contained herein may be modified and/or revoked without notice.
Closing Date/Time: 11/27/2023 5:00 PM Pacific