Application Developer, Portland Oregon

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.

SUMMARY

Portland General Electric Co. seeks Application Developer to work in Portland, OR

RESPONSIBILITIES

The Application Developer provides advanced data engineering services for complex, large-scale data systems in a fast-paced, innovative environment. This role involves designing, developing, and optimizing scalable data pipelines, ETL processes, and data warehousing solutions using AWS services and Snowflake. Responsibilities include coding, testing, debugging, and documenting complex data processing applications using Python, ensuring high data quality and integrity, and integrating diverse data sources to meet complex data requirements.

The candidate will also design and implement intricate data models and algorithms using advanced technologies such as AWS Glue, AWS Lambda, and Snowflake's unique features. They will utilize tools like AWS CloudWatch and Snowflake's query profiler to optimize query performance and generate analytics reports. The role requires recommending and designing innovative data architectures that ensure scalability, security, and seamless integration with existing systems.

This position also involves translating conceptual data models into efficient physical designs in Snowflake, producing detailed technical documentation, and implementing data governance policies to ensure compliance with data privacy regulations using tools like Snowflake's role-based access control (RBAC) and column-level security. The candidate will define and manage complex data integration processes, collaborating with cross-functional teams to align data solutions with business objectives. Responsibilities also include configuring and optimizing cloud-based data environments using AWS S3 and Snowflake, creating rigorous integration test plans, and conducting thorough performance testing.

In addition, the candidate will lead troubleshooting efforts for critical data issues and implement strategic solutions to prevent recurrence. This includes developing and maintaining Python based ETL jobs for data reconciliation, implementing robust data pipelines using Snowflake tasks and AWS Step Functions, creating efficient stored procedures in Snowflake, and configuring AWS Glue jobs for data cleansing and automation. The role involves streamlining the software development lifecycle for data solutions using Jenkins pipelines for CI/CD.

MINIMUM QUALIFICATIONS

Master's degree in computer science, Data Science, Software Engineering, or a related field (or foreign equivalent).

3 plus years' experience in Snowflake: Advanced SQL, stored procedures, virtual warehouses, storage layers, Time Travel, and Zero-Copy Cloning.

3 plus years hands on experience in AWS Cloud Platform: S3, Glue, Lambda, Step Functions, and IAM.

3 plus years hands on experience in Python and ELT platforms like Matillion

3 plus years' experience in Version Control & CI/CD: Git, Jenkins

3 plus years' experience with Data Governance: Snowflake's RBAC and column-level security.

3 plus years' experience with Real-Time Data Streaming: AWS Kinesis, Kafka.

3 plus years' experience with Optimization Techniques: Large-scale data processing in Snowflake and AWS.

Experience in utility data operations, including customer, asset, and resource data workflows, and the ability to implement tailored solutions to address industry-specific challenges

Compensation: $148,387.00

Actual total compensation, including a performance based incentive bonus, is commensurate with experience, skills, qualifications, education, training, and internal equity.

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.

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 an equal opportunity employer and is committed to fostering a workplace where employees feel connected, valued, and empowered to thrive. 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 Recruiter associated with the job posting. You may also make this request by contacting talentacquisition@pgn.comor by calling 503-464-7250. The Recruiter will provide information and next steps for the accommodation process.

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.