Share this Job

Senior Business System Specialist

Rocklin, CA, US, 95765

Requisition ID # 51083 

Job Category : Information Technology 

Job Level : Individual Contributor

Business Unit: Electric Operations

Job Location : Rocklin

Department Overview

The men and women of Electric Operations ensure the delivery of safe and reliable electric service to our customers. Electric Operations is responsible for every aspect of PG&E's electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration and emergency response.


Position Summary

The primary function of the Senior Business System Specialist is to maintain a departmental application used to facilitate the day to day operations of the Electric Transmission Contract Management team. Primarily, that consists of developing a web enabled UI with an MS SQL Server backend.  The successful candidate will work across functional teams and partner with peers and leaders on requirements gathering and implementation of those requirements.


The secondary function of the Senior Business System Specialist is to develop and maintain a departmental data warehouse and to facilitate the day to day operations of the ET Governance and Technology team. Primarily, that consists of developing and maintaining a reporting schema and performing extract, transform, and loading activities within an existing MS SQL Server.  He/She works across functional teams and partners with peers and leaders on requirements gathering and implementation of those requirements.



  • Projects are moderately complex and require selecting methods, approaches and tactics to resolve problems and obtain solutions.
  • Designs and creates forms for UI
  • Manages SQL Server security
  • Supports power users with creation of queries and analysis and reporting.
  • Applies judgment solve problems of diverse scope
  • Typically receives general instructions on new assignments or projects. Receives little instruction on recurring assignments.
  • May assist in coaching and developing less experienced staff and end users of Databases
  • Determines data needs, collects data, selects from different analytical techniques to conduct root cause analysis and determine issues.
  • Collects data to identify root cause of problems. Measures performance against process requirements. Provides consultation on the use of re-engineering techniques to improve process performance. Aligns improvement to performance shortfalls. Surveys and analyzes best practices for techniques and processes.
  • Understands business process needs and develops solutions




  • BA/BS in Business, Engineering, Computer Science/Information Systems, etc. or equivalent work experience
  • 4 years of job-related experience in Business, IT or Engineering fields
  • Participation in projects of medium to high complexity


  • 5 years’ design experience using MS SQL Server 2012 (or later) – creating tables/views
  • 5 years SQL Server (T-SQL) programming experience including stored procedures and functions
  • 5 years’ experience in SSIS 2012 or later designing and developing ETL packages (Visual Studio/SQL Server Data Tools)
  • SQL/SSIS deployment and administration (deploy/execute/monitor)
  • Experienced working with data stored across multiple databases/data sources
  • Experienced in data warehousing data modeling/design/data loading patterns and techniques. (Any RDBMS – Oracle, DB2 Teradata, MySQL, etc.)
  • Experience working in all phases of SDLC
  • Advanced experience working in front end technologies
    • JavaScript, CSS, HTML Angular, etc.
  • Advanced knowledge of full stack development
    • MS SQL (T-SQL), APIs, .NET and MVC
  • Experience with Agile/Scrum methodologies
  • Ability to work independently and part of a team
  • Self-Starter
  • Advanced problem-solving skills
  • Ability to keep pace and contribute to a high performing team

Our Mission

To safely and reliably deliver affordable and clean energy to our customers and communities every single day, while building the energy network of tomorrow.

Our Vision

With a sustainable energy future as our North Star, we will meet the challenge of climate change while providing affordable energy for all customers.

Our Culture

We put safety first.
We are accountable. We act with integrity, transparency and humility.
We are here to serve our customers.
We embrace change, innovation and continuous improvement.
We value diversity and inclusion. We speak up, listen up and follow up.
We succeed through collaboration and partnership. We are one team.

Pacific Gas and Electric Company (PG&E), a subsidiary of PG&E Corporation (NYSE:PCG), is one of the largest combined natural gas and electric companies in the United States. Based in San Francisco, our 24,000 employees deliver safe, reliable, affordable and clean energy to nearly 16 million people throughout our Northern and Central California service area, stretching from Eureka to Bakersfield and from the Pacific Ocean to the Sierra Nevada.

More About Our Company

Pacific Gas and Electric Company is an Affirmative Action and Equal Employment Opportunity employer that actively pursues and hires a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, age, religion, physical or mental disability status, medical condition, protected veteran status, marital status, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information or any other factor that is not related to the job.

Employee Privacy Notice                                                                                                                                                                                                                                      The California Consumer Privacy Act (CCPA) goes into effect on January 1, 2020. CCPA grants new and far-reaching privacy rights to all California residents. The law also entitles  job applicants, employees and non-employee workers to be notified of what personal information PG&E collects and for what purpose. The Employee Privacy Notice can be accessed through the following link: Employee Privacy Notice

PG&E will consider qualified applicants with arrest and conviction records for employment in a manner consistent with all state and local laws.

Nearest Major Market: Sacramento