Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award winning energy efficiency programs, our pathway to an exciting and innovative future is now.
PSE’s IT Application Solutions team is looking for qualified candidates to fill an open Sr App Development Analyst position!
Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.
Job Description
PSE IT data team is seeking an experienced data engineer with ETL experience in BW/HANA/AWS to be part of our ongoing journey building a platform of insights and data lake solutions. This is a great opportunity for you to show off your creative data skills and work on different ETL methods (real-time/near real time and batch processing).
We are highly motivated and continuously evolving team in the data space using the latest technologies within SAP or AWS. Come join us and be a part of the exciting and dedicated team working with our passion for big data.
Job Responsibilities
- Carries out detailed system design for ETL and reporting needs in HANA, BW or AWS.
- Writes functional and technical requirements, develops test plans and applies testing, and quality monitoring procedures.
- Leads coordination, facilitating interactive analysis and design sessions with representatives of business line and functional units.
- Writes stored procedures in HANA and performs data modeling, imports & exports code between different environments.
- Provides day-to-day support to users and to lower-level developers. Continuously contributes to maintain and optimize the overall ETL (BW, BODS, HANA, and AWS) and report (BOBJ, PowerBI) execution times.
- Works with security teams to setup roles and authorizations, creates user documentation, data interface design, data migration and reconciliation.
- Proactively contributes to the overall IT strategy via direct experience in tactical projects and specific user requirements.
- Performs daily monitoring, troubleshooting to analyze complex problems to resolve technical issues.
- Mentors other team members as needed.
- Establishes and manages moderate sized project plans.
- Acts as a champion in data technologies applying the standards, performing code, design and standard reviews for others within the department.
- Performs other duties as assigned.
Minimum Qualifications
- Two year degree or certification in a technology-related field or equivalent combination of education, work experience or relevant military experience, and at least 4 years of experience in related field.
- 5+ years IT experience, including several years of systems development experience in the design and development of department-wide or enterprise-wide applications.
- Detailed understanding and 5+ years programming languages (specialized technical requirements as shown in attachment) and strong knowledge of office applications (e.g. Microsoft Office).
- Possesses full technical knowledge of phases of software development life cycle.
- Experience with at least two full life cycle implementations of a new application or purchased application.
- Extensive knowledge of multiple languages, i.e (specialized technical requirements as shown in attachment) environment, active business processes, business areas, as well as industry.
- Knowledge of systems and/or business analysis design concepts. Demonstrated proficiency in the applied use of systems and process analysis tools. Full system life cycle experience, including development lifecycle methodologies.
- Demonstrated understanding of Structured Query Language (SQL).
- Ability to facilitate interactive design and functional specification sessions.
- Highly developed interpersonal, written and verbal skills with an ability to express complex technical concepts in business terms. Excellent technical writing and system documentation skills.
- Strong analytical problem-solving, and conceptual skills.
- Demonstrated project management skills for moderate sized projects.
- Must be a “team player” able to work with management in developing and implementing new processes and enabling systems. Able to work with end user groups to define application needs and identify feasible solutions.
- Proactive, self-motivated with the ability to motivate others and a customer-focused service attitude.
- Good organizational skills, with the ability to meet objectives and effectively multi-task.
- Ability to work with multiple levels of the organization, both technical and non-technical.
Desired Qualifications
- Bachelor’s degree
- 5 years of experience working on ETL and reporting tools in SAP (BW/HANA) or AWS.
- Understanding of SAP BW Extractors functionality with ABAP Debugging skills.
- Hands-on experience or Knowledge on BW/4 HANA.
- Hands-on experience with SAP HANA data modelling views (Attribute, Analytics and Calculation views) and stored procedures to perform ETL
- Experience or knowledge handling ETL in big data technologies like AWS.
- Working experience in writing and analyzing python code.
- Experience or knowledge in SAP BODS and AWS products like redshift, Athena etc.
- Knowledge of visualization tools like BOBJ and POWER BI.
At PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package.
The pay range for this position is $92,900.00 – $163,600.00, and this position is eligible for annual goals based incentive bonuses.
PSE offers a suite of benefits to our employees. Employees are eligible for medical, dental, vision, basic life, and short- and long-term disability insurance. There are additional voluntary options of supplemental life insurance, accidental death and dismemberment insurance, flexible spending accounts for health care and dependent daycare, and an Employee assistance program (EAP). For long term savings, PSE offers a 401(k) investment option and a cash balance retirement plan. Employees will also receive Paid Time Off (PTO) and Paid Holidays throughout the calendar year. Detailed benefit overviews can be found on our Career page – Why Work For Us (pse.com).
Families and businesses depend on PSE to provide the energy they need to pursue their dreams. Our steadfast commitment to serving Washington communities with safe, dependable and efficient energy started in 1873. Today we’re building the Northwest’s energy future through efforts like our award winning energy efficiency programs and our leadership in renewable energy.
At PSE we value and respect our employees and provide them opportunities to excel. We offer an expansive pay package that includes competitive compensation, annual goals-based incentive bonuses, comprehensive benefits, 401(K), a company paid retirement pension plan, and an employee assistance and wellness program.
Puget Sound Energy is committed to providing equal employment opportunity to all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation, gender identity, marital status, veteran status or presence of a disability that with or without reasonable accommodation does not prevent performance of the essential functions of the job, or any other category prohibited by local, state or federal law.
Should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources Staffing department at jobs@pse.com or 425-462-3017.