Forecasting Data Analyst

Full Job 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

Requirements

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)

Qualifications

• 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.

Additional 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.