Forecasting Data Analyst

Job Description:

Forecasting Data Analyst

Description

Position Description

Tacoma Power is seeking a talented individual to join its Rates and Forecasting team. As a Forecasting Data Analyst, you will have the opportunity to help lay the foundation for advanced customer analytics and help improve Tacoma Power's sales and revenue forecasting capabilities.

The Rates and Forecasting team develops and maintains a portfolio of high-visibility analytical models that directly influence Tacoma Power’s financial outlook and help ensure rates remain equitable and cost-effective for customers. As the team continues to modernize and expand our toolset, we are upgrading several key modeling tools and processes. These improvements will strengthen our ability to accurately forecast and uphold our commitment to providing rates that are fair, just, and reasonable.
The culture of our team is very collaborative and supportive. We are highly skilled, self-motivated individuals who enjoy working together and believe in the work that we do.

Responsibilities Include:

• Query, screen, validate, clean and organize large sets of our utility’s smart-meter and customer billing data
• Analyze meter and billing data to identify anomalies and trends to support business decisions and provide customer insights
• Automate data retrieval and build dashboards
• Validate and reconcile meter data with billing systems
• Develop electric usage forecasting models for different customer classes
• Diagnose and interpret model output, perform sales variance analysis at the customer class level
• Visualize data for technical documents and presentations
• Research customer class load profiles to support cost-of-service analysis and other rates projects
• Maintain and improve existing the existing econometric system load forecasting model
• Support rate-making and long-term financial planning
• Serve as the subject matter expert for customer load and sales analyses
• Work on cross-functional teams on various projects related to customer load and rate-making
• Provide ad-hoc analysis to various stakeholders

Qualifications

Minimum Education*
Bachelor's degree in business, engineering, computer science, economics, statistics, mathematics or directly related field

Minimum Experience*
4 years of experience in statistical analysis, data modeling or data analytics including 1 year prior at senior, lead and/or supervisory level

*Equivalency: 1 year of experience = 1 year of education

Licensing, Certifications and Other Requirements for some assignments:
North American Electric Reliability Corporation Critical Infrastructure Protection certification (NECC-CIP)

Knowledge & Skills

• Hands-on experience with managing and analyzing large, complex data sets; statistical modeling and data science, including econometric and machine learning modelling techniques.
• Expertise in common programming languages such as SQL, Python and R.
• Proficient with Excel, Tableau and Power BI.
• Excellent communication skills and team-orientation.
• Ability to explain complex technical concepts to technical and non-technical stakeholders.

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 me on LinkedIn !

Compensation & Benefits

Pay Details:

Annual Rate: $122,096.00 - $171,953.60

Employee Benefits | City of Tacoma

Tacoma Power
Tacoma Power is an almost 100% hydroelectric, municipally-owned public power utility, located in Tacoma. We serve approximately 180,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. We welcome you to take a look at our website and discover how the City of Tacoma can make your next career move part of our combined destiny:
http://www.cityoftacoma.org/ https://www.mytpu.org/ http://www.traveltacoma.com/

City of Tacoma’s Commitment to Diversity, Equity, and Inclusion

A Commitment to Equity & Diversity

At the City of Tacoma, we're on a mission to make our workforce as diverse and inclusive as the community we serve. We actively seek out candidates from a wide range of backgrounds and cultures. Join our team at the City of Tacoma and help us build a more vibrant, inclusive, and equitable community for all.

If you have a less traditional background, we want to hear about your transferrable skills and experience. We value a variety of perspectives and are excited to see what you bring to the table.

The Community

Tacoma is centrally located just 32 miles south of the city of Seattle and 31 miles north of the state capital, Olympia. The City of Tacoma is also home to the Port of Tacoma, which is among the largest container ports in the United States. Like most cities in the northwest, Tacoma is surrounded by beautiful nature, offering residents many opportunities for outdoor adventures.

Largely suburban in nature with a small, but dense, urban core, Tacoma is home to numerous institutes of higher learning that attract students from across the country. The University of Washington Tacoma, Pacific Lutheran University, University of Puget Sound, a satellite campus of the Evergreen State College, three community/technical colleges, and several trade and business schools are within Tacoma's geographic area. Downtown's Cultural District is the site of the Washington State History Museum, Museum of Glass, the Tacoma Art Museum, and America's Car Museum.

With its affordable housing and distinctive neighborhoods and business districts, the city has been recognized numerous times as a best city to live in the nation. To see a few of the great things Tacoma has to offer, view this YouTube Video!

View this exciting video to learn more about the City of Tacoma: https://www.youtube.com/watch?v=2n5MWl8KFvI

Application Process

Interested individuals should apply online by completing the application and attaching a resume and cover letter by the closing date and time listed on the job announcement. Applications received without attaching the required materials may not progress in the selection process. Applicants who have the strongest backgrounds related to the responsibilities of this position may be invited to participate in the interview process, which may include a work problem. Appointment is subject to passing a background check.

Get Assistance

For assistance with the application process or questions regarding this job announcement please contact the Human Resources office at (253) 591-5400 by 4:00 p.m. of the closing date of the job announcement.

For technical difficulties using the NEOGOV system, call the applicant support line at 1-855-524-5627 between 6:00a.m. and 5:00 p.m. Pacific Standard Time. This will allow us to assist you before the job announcement closes.

Communication with the City of Tacoma

We primarily communicate via email during the application process. Emails from Tacoma.gov and/or governmentjobs.com should 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 email folders.

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.

The City of Tacoma provides excellent medical, dental and vision plans for the whole family; paid holidays and paid leave; participation in the Tacoma 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 age26 or younger.

Dental Coverage: For eligible employees and their families, including domestic partners and dependent children age26 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: 4/2/2026 5:00 PM Pacific

Salary:

$122,096.00 - $171,953.60 Annually