Share this Job

Business System Specialist, Senior

San Ramon, CA, US, 94583

Requisition ID # 25231 

Job Category : Business Operations / Strategy; Information Technology; Maintenance / Construction / Operations 

Job Level : Individual Contributor

Business Unit: Electric Operations

Job Location : San Ramon

Company

 

Based in San Francisco, Pacific Gas and Electric Company, a subsidiary of PG&E Corporation (NYSE:PCG), is one of the largest combined natural gas and electric utilities in the United States. And we deliver some of the nation's cleanest energy to our customers in Northern and Central California. For PG&E, Together, Building a Better California is not just a slogan. It's the very core of our mission and the scale by which we measure our success. We know that the nearly 16 million people who do business with our company count on our more than 24,000 employees for far more than the delivery of utility services. They, along with every citizen of the state we call home, also expect PG&E to help improve their quality of life, the economic vitality of their communities, and the prospect for a better future fueled by clean, safe, reliable and affordable energy.

 

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.

 

Position Summary

The Sr. Business System Specialist's primary function 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.

 

The Sr. Business System Specialist's secondary function is to maintain departmental application used to facilitate the day to day operations of the ET Contract Management team. Primarily, that consists of developing a web enabled UI with an MS SQL Server backend.  He/She works across functional teams and partners with peers and leaders on requirements gathering and implementation of those requirements.

 

Qualifications

Minimum:

  • BA/BS degree in Business, or IT or relevant degree or equivalent experience
  • 4 years of related experience in IT, Business or Engineering related fields.

 

Desired:

  • 4 years SQL Server (T-SQL) programming experience including stored procedures and functions
  • 4 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/Expert experience working in front end technologies
    • JavaScript, CSS, HTML Angular, etc.
  • Advanced/Expert 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.   

 

Responsibilities

  • Projects are moderately to highly 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

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

Company
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

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


Nearest Major Market: San Francisco
Nearest Secondary Market: Oakland