What are the responsibilities and job description for the Application Developer, Portland Oregon position at Portland General Electric?
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.
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.
Salary : $148,387