Requisition ID # 169398
Job Category: Information Technology
Job Level: Individual Contributor
Business Unit: Customer & Enterprise Solutions
Work Type: Hybrid
Job Location: Sacramento
Department OverviewIn Customer Care we are focused on delivering the desired customer experience for each of our customers. Everything we do starts with the customer and our information about the customer. That information is collected and managed by Customer Channels and Services. Each of our organizations, though completely dependent upon each other, are the experts in their area and will further drive PG&Es alignment around the customer.
The Workforce Management Reporting Team supports multiple lines of business for all reporting needs. We heavily rely on automation process through Microsoft SQL Server for data collection with multiple applications for outputs, including Tableau, Excel, Microsoft SQL SSRS, Microsoft Power BI and Ontrack. Reporting has a critical role within the Customer Contact Emergency Coordination Center (CCECC), supporting all PSPS, Storm and Outage events 24/7.
Position SummaryDesigns, develops, modifies, configures, debugs and evaluates application programs for functional business areas. Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs. Consults with business analysts and architects to understand, anticipate, and meet current and future business needs. Modifies and configures applications/systems as specified in the requirements and/or technical design document. Prepares and obtains approval of system and development documentation, with strong focus on web applications, database design, and data integration. The role is responsible for designing and developing data-driven ASP.NET applications, building and optimizing SQL Server databases, and creating complex SSIS packages to support data integration, migration, and transformation needs.
This position is hybrid, working from your remote office and your assigned work location, at least once per week, or more, based on business need. The assigned work location will be within the PG&E Service Territory.
PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity.
Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.This job is also eligible to participate in PG&E's discretionary incentive compensation programs.
A reasonable salary range is:
Bay Area Minimum: $102,000.00
Bay Area Maximum: $162,000.00
OR
California Minimum: $97,000.00
California Maximum: $154,000.00
Job Responsibilities- Design, develop, and maintain data-driven web applications using ASP.NET and related technologies.
- Develop complex backend logic, procedure, and application workflows to support business processes and system requirements.
- Architect, build, and optimize SQL Server database structures, including tables, stored procedures, functions, and indexes.
- Lead the development and maintenance of advanced SSIS packages to support data integration, migration, and transformation projects.
- Ensure data accuracy, reliability, and performance across ETL workflows and integrated systems.
- Develop interactive dashboards, reports, and data visualizations using SSRS, and Power BI to support organizational decision-making.
- Perform comprehensive systems analysis, gather requirements, and translate business needs into technical solutions.
- Take ownership of designing scalable, secure, and efficient applications and data solutions by leading business units, project teams, and stakeholders throughout the development process.
- Troubleshoot, diagnose, and resolve complex application, database, and ETL issues to ensure system stability and continuity.
- Provide technical expertise, documentation, and guidance to internal teams and contribute to continuous improvement initiatives.
- Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to Senior and Executive Leaders.
- Proficient in Microsoft applications for developing Power BI dashboards, writing complex Microsoft SQL queries, SharePoint Development, SSIS.
- Applies advanced analytical knowledge to wide-ranging issues.
- Develop business cases in support of strategy or change initiatives.
- Performs analysis on highly complex data models that have cross- functional impact.
QualificationsMinimum:
- Bachelors Degree in Business Administration or job-related discipline or equivalent experience
- Job-related experience, 6 years
Desired:
- Executive Leadership presentation delivery: Skilled in Power Point presentation development
- Collaborate with technical teams to design cloud-ready solutions and support application modernization initiatives.
- Develop and support secure, scalable RESTful APIs for system integration and data exchange.
- Produce clear, accurate, and comprehensive technical documentation, including system designs, application architectures, data models, API specifications, and integration workflows.
- Contact Center operational knowledge with emphasis in Cisco ACD Platform
Purpose, Virtues and StandsOur
Purpose explains "why" we exist:
- Delivering for our hometowns
- Serving our planet
- Leading with love
Our
Virtues capture "who" we need to be:
- Trustworthy
- Empathetic
- Curious
- Tenacious
- Nimble
- Owners
Our
Stands are "what" we will achieve together:
- Everyone and everything is always safe
- Catastrophic wildfires shall stop
- It is enjoyable to work with and for PG&E
- Clean and resilient energy for all
- Our work shall create prosperity for all customers and investors
More About Our Company
EEOPacific Gas and Electric Company is an Equal Employment Opportunity employer that actively pursues and hires a workforce that reflects the hometowns we serve. 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.
Never miss an opportunity! Create an alert based on the job you applied for.
