Data Engineer, Associate

Requisition ID # 172276 Job Category: Information Technology Job Level: Individual Contributor Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Company Overview Based in Oakland, Pacific Gas and Electric Company is one of the largest combined natural gas and electric utilities in the United States (NYSE:PCG). In addition to providing energy to approximately 40% of Californians and 1 in 20 Americans, PG&E also delivers some of the nation’s cleanest electricity, more than 93% from GHG emissions free sources, and 0% from coal. As an active member of the community PG&E aims to improve our customers’ quality of life, economic vitality, and prospect for a better future by providing clean, safe, reliable and affordable energy. As such, PG&E proactively advocates for regulation of greenhouse gases through partnerships (such as at the UN COP in Paris), invests in renewables, and supports customer affordability through one of the country's most successful energy-efficiency programs. More information on PG&E and its other innovative sustainability initiatives can be found at Pacific Gas and Electric Company is an Affirmative Action and Equal Employment Opportunity employer that actively pursues and hires a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, age, religion, physical or mental disability status, medical condition, protected veteran status, marital status, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information or any other factor that is not related to the job. Position Summary We are looking for a Data Engineer to join our growing team of analytics experts. In this role you will work as part of cross functional teams, including data scientists, other data engineers, technology experts, and subject matter experts to develop data driven solutions. Successful candidates will be responsible for building, expanding, and optimizing our data, data storage, and data pipeline. This individual will support team members and decision products to ensure that data delivery is reliable and optimized. Qualified candidates will have a unique opportunity to be at the forefront of the utility industry and gain a comprehensive view of the nation’s most advance smart grid. It is the perfect role for someone who would like to continue to build upon their professional experience and help advance PG&E’s sustainability goals. Responsibilities: Work under the guidance of senior data engineers on moderate complexity data and analytics-centric problems which have broad impact and require in-depth analysis to obtain desired results. Plans work to meet mutually agreed to objectives; reviews progress with team members regularly; documents work in a manner that is aligned with best practices Identifies, designs, and implements internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes. Resolves application programming analysis problems of broad scope within procedural guidelines. Actively participates in agile/scrum ceremonies (stand ups, planning, retrospectives, etc.) Builds and conducts automated and user acceptances tests as part of an iterative development process Promotes a continuous improvement mindset by engaging in after action reviews and sharing learnings Broader Data System and Architecture Maturity Assesses performance of individual data pipeline and broader data systems, suggests and may implement changes as required to meet individual project or enterprise maturity objectives Conceptualizes and generates infrastructure that allows big data to be accessed and analyzed with verified data quality and metadata is appropriately captured and catalogued Work with team leadership to continually improve data driven decision making at PG&E via demonstrations, mentoring, disseminating best practices, etc. The hourly rate for this position ranges from $39.42 to $59.62 Minimum Qualifications: BA/BS or equivalent experience in appropriate technical discipline (Computer Science, Management Information Systems or equivalent experience and/or related field of study) 1 year of experience with data engineering/ETL ecosystems such as Palantir Foundry, Spark, Informatica. Required Skills Python PySpark Database design fundamentals Experience writing health checks, unit tests, integration tests, schema validations Proven ability to translate business requirements into technical requirements Ability to communicate with various stakeholders and leadership Ability to breakdown an ambiguous problems Desired Skills Typescript Web application development Experience with the Palantir Foundry platform Experience working with data scientists and machine learning engineers Front end tools: PowerBi, Tableau