Portland General Electric
Customer Information Systems Analyst
Portland General Electric, Portland, Oregon, United States, 97204
At PGE, our work involves dreaming about, planning for, and realizing a smarter, cleaner, more enduring Oregon neighborhood. Its core to our DNA and we haven’t stopped since we started in 1888. We energize lives, strengthen communities and drive advancements in energy that promote social, economic and environmental progress. We’re always on the lookout for people passionate about leading and being a part of teams that are advancing innovative clean energy solutions that are also affordable and accessible to all.
Job Function
Customer Information Systems Develops and maintains the customer information database to support analysis, application development and data-driven customer account management techniques.
Key Responsibilities
Customer Information Systems Management
Develops, manages, maintains and improves customer information databases that support residential and commercial energy efficiency outreach activities
Designs databases using appropriate mainframe, Excel, SharePoint and Access applications; populates databases from existing and new sources
Create and maintain Salesforce dashboards
Develop data queries using SQL
Coordinates with IT. Customer Information System Operation
Creates, manages and runs routine reports and queries regarding customer account information; maintains and provides data on metrics.
Data Analysis Analyzes customer data, presents results and recommends process improvements.
External Relations Establishes and maintains professional communications and relationships with contractors, Energy Trust and other external stakeholders to maintain quality of customer information.
Software Research Researches and recommends software to improve residential and commercial energy efficiency outreach activities.
System Training and Presentations Prepares communications and makes presentations on system improvements
Delivers user training programs on the customer information system.
Infrequently conduct residential customer heat pump inspections with training provided
Education/Experience/Certifications Education
Requires a bachelor’s degree in any field or equivalent experience. Experience Typically two or more years in managing a database, project management, data analysis or related field.
Required experience with Tableau
Preferred experience with Salesforce
Preferred experience with Snowflake
Physical Capabilities
Does the job require a valid driver’s license? Yes
Driving/travel/commute: Occasionally (one to two times a month or less)
Overnight inside/outside the service territory: Occasionally (one to two times a month or less)
Computer use (use computer regularly for entire work shift): Yes
Lifting/pushing/pulling (check appropriate weight): Up to 50 lb
Carrying (check appropriate weight): Up to 50 lb
Unstable surfaces requiring balance (i.e., moving equipment, boats): Confined spaces
Environment - Indoor/Outdoor ☒ Office environment ☒ Plant environment ☒ Field environment
Physical and Cognitive Demands Cognitive Level Intermediate:
Consistent use of relevant principles to solve practical problems and to deal with a variety of concrete variables in situations where only limited standardization exists.
Cognitive Ability to adhere to set response times, deadlines and time-sensitive tasks Ability to follow accuracy standards
Ability to follow through on decision-making tasks
Ability to interact effectively and collaboratively within a team environment
Ability to communicate and problem solve when under stress
Ability to respond and adapt to frequent change
Ability to accept and demonstrate self-awareness when provided constructive feedback
Ability to discern feedback and acknowledge ownership of areas of improvement
Ability to avoid future mistakes by applying reasonable skills to new but similar work situations or tasks
Ability to successfully collaborate with peers, managers and others within the organization Demonstrates sound memory
Ability to process new information to be applied consistently to work tasks
Physical Capabilities
Driving/travel/commute: Daily within service territory - Frequently (at least once a week or more)
Computer use (use computer regularly for entire work shift)
Lifting/pushing/pulling: Up to 50 lbs.
Carrying: Up to 50 lbs.
Unstable surfaces requiring balance
Elevated areas (i.e., catwalks, roofs and high buildings)
Confined spaces
Walking distances and surfaces (long distances and over rough, uneven or rocky surfaces)
Stairs (over 10 steps)
Ladders (over 10 rungs)
Environment - Indoor/Outdoor (check all that apply):
Office
Field
Compensation Range:
$72,900.00 - $145,375.00
Actual total compensation, including a performance based incentive bonus, is commensurate with experience, skills, qualifications, education, training, and internal equity. While we anticipate the selected candidate for this position will fall towards the middle or entry point of the compensation range, the decision will be made on a case-by-case basis.
PGE believes in rewarding dedicated performance. We provide a total rewards package that is designed to reward your contributions to the company, and, at the same time, support your well-being and professional development, both now and into the future. To find out more, click here (https://portlandgeneral.com/hrcs5511) .
Join us today and power your potential!
Assisting with storms or other Company emergencies is a part of all positions at Portland General Electric.
PGE is committed to diversity and inclusion in the workplace and is an equal opportunity employer. PGE will not discriminate against any employee or applicant for employment based on race, color, national origin, gender, gender identity, sexual orientation, age, religion, disability, protected veteran status, or other characteristics protected by law.
PGE does not discriminate on the basis of disability. We recognize individuals have a variety of abilities to offer and we believe there is much to value and celebrate by incorporating different abilities into the work we do. One very important way we live this out is in our application and interview process. We work hard to support individuals who may need an accommodation to fully participate in these processes. If you feel you may need an accommodation, or would like to request one, please notify the Talent Acquisition Specialist (Recruiter) associated with the job posting. You may also make this request by contacting talentacquisition@pgn.com or by calling 503-464-7250. The Recruiter will provide information and next steps for the accommodation process. Our Diversity, Equity & Inclusion (DEI) team is also available for support. You can contact them at dei@pgn.com .
To be considered for this position, please complete the following employment application by the posting close date. Posting closes at midnight (Pacific Time) on the closing date below. If no date is listed, job is open until filled.
Job Function
Customer Information Systems Develops and maintains the customer information database to support analysis, application development and data-driven customer account management techniques.
Key Responsibilities
Customer Information Systems Management
Develops, manages, maintains and improves customer information databases that support residential and commercial energy efficiency outreach activities
Designs databases using appropriate mainframe, Excel, SharePoint and Access applications; populates databases from existing and new sources
Create and maintain Salesforce dashboards
Develop data queries using SQL
Coordinates with IT. Customer Information System Operation
Creates, manages and runs routine reports and queries regarding customer account information; maintains and provides data on metrics.
Data Analysis Analyzes customer data, presents results and recommends process improvements.
External Relations Establishes and maintains professional communications and relationships with contractors, Energy Trust and other external stakeholders to maintain quality of customer information.
Software Research Researches and recommends software to improve residential and commercial energy efficiency outreach activities.
System Training and Presentations Prepares communications and makes presentations on system improvements
Delivers user training programs on the customer information system.
Infrequently conduct residential customer heat pump inspections with training provided
Education/Experience/Certifications Education
Requires a bachelor’s degree in any field or equivalent experience. Experience Typically two or more years in managing a database, project management, data analysis or related field.
Required experience with Tableau
Preferred experience with Salesforce
Preferred experience with Snowflake
Physical Capabilities
Does the job require a valid driver’s license? Yes
Driving/travel/commute: Occasionally (one to two times a month or less)
Overnight inside/outside the service territory: Occasionally (one to two times a month or less)
Computer use (use computer regularly for entire work shift): Yes
Lifting/pushing/pulling (check appropriate weight): Up to 50 lb
Carrying (check appropriate weight): Up to 50 lb
Unstable surfaces requiring balance (i.e., moving equipment, boats): Confined spaces
Environment - Indoor/Outdoor ☒ Office environment ☒ Plant environment ☒ Field environment
Physical and Cognitive Demands Cognitive Level Intermediate:
Consistent use of relevant principles to solve practical problems and to deal with a variety of concrete variables in situations where only limited standardization exists.
Cognitive Ability to adhere to set response times, deadlines and time-sensitive tasks Ability to follow accuracy standards
Ability to follow through on decision-making tasks
Ability to interact effectively and collaboratively within a team environment
Ability to communicate and problem solve when under stress
Ability to respond and adapt to frequent change
Ability to accept and demonstrate self-awareness when provided constructive feedback
Ability to discern feedback and acknowledge ownership of areas of improvement
Ability to avoid future mistakes by applying reasonable skills to new but similar work situations or tasks
Ability to successfully collaborate with peers, managers and others within the organization Demonstrates sound memory
Ability to process new information to be applied consistently to work tasks
Physical Capabilities
Driving/travel/commute: Daily within service territory - Frequently (at least once a week or more)
Computer use (use computer regularly for entire work shift)
Lifting/pushing/pulling: Up to 50 lbs.
Carrying: Up to 50 lbs.
Unstable surfaces requiring balance
Elevated areas (i.e., catwalks, roofs and high buildings)
Confined spaces
Walking distances and surfaces (long distances and over rough, uneven or rocky surfaces)
Stairs (over 10 steps)
Ladders (over 10 rungs)
Environment - Indoor/Outdoor (check all that apply):
Office
Field
Compensation Range:
$72,900.00 - $145,375.00
Actual total compensation, including a performance based incentive bonus, is commensurate with experience, skills, qualifications, education, training, and internal equity. While we anticipate the selected candidate for this position will fall towards the middle or entry point of the compensation range, the decision will be made on a case-by-case basis.
PGE believes in rewarding dedicated performance. We provide a total rewards package that is designed to reward your contributions to the company, and, at the same time, support your well-being and professional development, both now and into the future. To find out more, click here (https://portlandgeneral.com/hrcs5511) .
Join us today and power your potential!
Assisting with storms or other Company emergencies is a part of all positions at Portland General Electric.
PGE is committed to diversity and inclusion in the workplace and is an equal opportunity employer. PGE will not discriminate against any employee or applicant for employment based on race, color, national origin, gender, gender identity, sexual orientation, age, religion, disability, protected veteran status, or other characteristics protected by law.
PGE does not discriminate on the basis of disability. We recognize individuals have a variety of abilities to offer and we believe there is much to value and celebrate by incorporating different abilities into the work we do. One very important way we live this out is in our application and interview process. We work hard to support individuals who may need an accommodation to fully participate in these processes. If you feel you may need an accommodation, or would like to request one, please notify the Talent Acquisition Specialist (Recruiter) associated with the job posting. You may also make this request by contacting talentacquisition@pgn.com or by calling 503-464-7250. The Recruiter will provide information and next steps for the accommodation process. Our Diversity, Equity & Inclusion (DEI) team is also available for support. You can contact them at dei@pgn.com .
To be considered for this position, please complete the following employment application by the posting close date. Posting closes at midnight (Pacific Time) on the closing date below. If no date is listed, job is open until filled.