Senior IT Solutions Architect

Tualatin, OR, United States

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.

Senior IT Solutions Architect

Job Function

Solutions Architecture Designs and develops IT architecture (integrated process, applications, data, and technology) solutions to business problems in alignment with the enterprise architecture direction and standards. Performs technical planning, architecture development and modification of specifications. Researches and develops specifications for new products/services, applications, and service offerings. Assesses the compatibility and integration of products/services proposed as standards to ensure an integrated architecture across interdependent technologies.

Key Job Information

Requires specialized depth and/or breadth of expertise Interprets internal or external business issues and recommends best practices.

Solves complex problems; takes a broad perspective to identify innovative solutions.

Works independently, with guidance in only the most complex situations.

May lead functional teams or projects.

Requires experience working in a Financial, Commodity, or Energy sector.

Develop data mapping, design, and extraction methods to simplify data refresh and presentation architectures.

Key Responsibilities

Conformance Review (CORE) Plans formal reviews of activities, processes, products, or services. Evaluates and independently appraises the internal control of automated business processes based on investigative evidence and assessments undertaken by self or team. Ensures that independent appraisals follow agreed procedure and advises others on the review process. Provides advice to management on ways of improving the effectiveness and efficiency of their control mechanisms. Identifies and evaluates associated risks and how they can be reduced.

User Experience Evaluation (USEV) Advises on achievement of usability (including health and safety and accessibility) of specific visual design approaches and their suitability for different audiences. Advises on what to evaluate and type of evaluation. Manages evaluation of systems, products, or services to assure that the stakeholder and organizational requirements have been met, required practice has been followed and systems in use continue to meet organizational and user needs. Evaluates design aspects of web tenders and proposals, including wireframes and mock-ups. Ensures that the results of evaluations are understood by system developers. Influences design teams to act on the findings of usability tests.

Solution Architecture (ARCH) Uses appropriate tools, including logical models of components and interfaces, to contribute to the development of systems architectures in specific business or functional areas. Produces detailed component specifications and translates these into detailed designs for implementation using selected products. Within a business change program, assists in the preparation of technical plans and cooperates with business assurance and project staff to ensure that appropriate technical resources are made available. Provides advice on technical aspects of system development and integration (including requests for changes, deviations from specifications, etc.) and ensures that relevant technical strategies, policies, standards, and practices (including security) are applied correctly.

Systems Design (DESN) Specifies and designs large or complex systems. Selects appropriate design standards, methods, and tools consistent with agreed enterprise and solution architectures and ensures they are applied effectively. Reviews others' systems designs to ensure selection of appropriate technology, efficient use of resources and integration of multiple systems and technology. Contributes to policy for selection of architecture components. Evaluates and undertakes impact analysis on major design options and assesses and manages associated risks. Ensures that the system design balances functional, service quality, security, and systems management requirements.

Emerging Technology Monitoring (EMRG) Monitors the market to gain knowledge and understanding of currently emerging technologies. Identifies new and emerging hardware and software technologies and products based on own area of expertise, assesses their relevance and potential value to the organization and contributes to briefings of staff and management.

Consultancy (CNSL) Takes responsibility for understanding client requirements, collecting data, delivering analysis and problem resolution. Identifies, evaluates, and recommends options, implementing if required. Collaborates with and facilitates stakeholder groups as part of formal or informal consultancy agreements. Seeks to fully address client needs, enhancing the capabilities and effectiveness of client personnel, by ensuring that proposed solutions are properly understood and appropriately exploited.

Job Duties:

Attending Business Requirement discussions with Stakeholders and customers.

Reviewing Business Requirement documents and use cases to gather scope details.

Understood entire ETL flow of Enterprise data warehouse with producing the key critical metrics to business users.

Preparing structured Query language (SQL) scripts for retrieving customer asked data stats.

Performed development activities from gathering requirements and designing solutions through developing reports, to testing and release/deployment.

Fully understood and translate the legacy existing reporting system (Excel reports) to convert them as Tableau dashboards.

Built complex reporting applications against various data sources like Flat files (Excel, Access), SQL server, Snowflake, Oracle.

Built complex views in the cloud -snowflake environment for the reporting needs.

Publish dashboards to Tableau server to make them available for internal external users and subscribe then to automate report delivery process.

Conducted data exploration and analysis to understand source data and identify insights that could be translated into meaningful visualizations.

Guiding, Reviewing team members deliverables, unit & QA test cases.

Attending Daily/Weekly status meetings to track the deliverables status and clarify the concerns.

Worked with cross-functional teams.

Adhered to Agile principles and practices, including the use of agile Project management tools Jira to track work items and sprints.

Work with offshore team to communicate user requirements.

Trained various users on tableau usage and navigation appropriate documentation for the same.

Conducted Business acceptance and user acceptance testing and sign off meetings.

Providing support to testing and defect resolution.

Proactively monitor the Production dashboards on daily basis.

Perform data fixes based on customer business needs.

Education/Experience/Certifications

Requires a bachelor’s degree in business, computer science, engineering management or equivalent work experience in related discipline.

Typically, eight or more years in related field.

TOGAF, ITIL, ARCHIMATE, AWS Architecture (or other cloud provider) certification preferred.

Competencies (Knowledge, Skills, Abilities)

Functional Competencies

Advanced knowledge of quality and conformance frameworks.

Advanced knowledge of specification and design of information systems.

Advanced knowledge of emerging technologies.

Intermediate knowledge of the business areas and functions and work with business users to understand the technical solution designs needed.

Intermediate knowledge of IT/business strategies.

Knowledge of messaging, data lake, and advanced analytics reporting and business Intelligence platforms.

Able to interact with intraday systems and capabilities such Webservices, Kafka, Spark in an on-prem and cloud environment.

Hands-on experience at the debugging level with Python, R, Java, SQL

Be able to write complex Business Intelligence reports.

Use established BI practices and methodology, define, and develop BI solutions including cubes, reports, analyses, and portals (identify and integrate industry standards and best practices to optimize the presentation of key data to defined audiences)

Collaborate effectively with cross-functional teams including Trading, Origination, Risk, and Finance

General Competencies

Advanced customer focus skills.

Advanced accuracy skills.

Advanced risk management skills.

Advanced oral and written communication skills.

Advanced interpersonal skills.

Advanced decision-making skills.

Advanced organization and prioritization skills Advanced meeting facilitation skills.

Advanced team-building skills.

Physical and Cognitive Demands

Cognitive Level Substantial: Consistent use of logic or scientific thinking to define problems, collect information, establish facts, and draw valid conclusions (for example, engineer, HR director, plant manager, etc.).

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.

Schedule/Attendance

Ability to adhere to pre-established schedule, including start/stop time and break/lunch schedule.

Ability to work long hours.

Ability to work a variable schedule.

Ability to report to work and perform work during periods of severe inclement weather.

Ability to consistently meet attendance standards for regular, reliable, predictable, full-time attendance.

Ability to work shift schedule.

Ability to work on-call schedule.

Physical Capabilities

Driving/travel/commute: Daily within service territory - Occasionally (one to two times a month or less)

Driving/travel/commute: Overnight inside/outside the service territory - Occasionally (one to two times a month or less)

Computer use (use computer regularly for entire work shift)

Environment - Indoor/Outdoor (check all that apply):

Office

PGE supports hybrid flexible work arrangements; and will have a combination of in-the-office and working offsite. This role will be primarily Remote but may come to the office as needed. These arrangements may change due to business needs or changes in responsibility.

#LI-CU1

Compensation Range:

$113,925.00 - $189,875.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 [email protected] 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 [email protected] .

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.

At Portland General Electric, we’re innovators, builders, and achievers. We’re committed to powering our customers’ potential and making a difference for our community and the planet. Today, that commitment includes developing an intelligent and resilient electric grid, electrifying transportation and de-carbonizing the energy sector.

We’re proud to deliver an exceptional experience to help our customers thrive. Our mission is to make clean, reliable and affordable energy services available to all. We obsess over serving customers and are committed to growing employee career paths with purpose. Equity and inclusion are core business values; we celebrate our differences and are committed to developing teams that reflect the communities we serve.