The Pg&e Data Engineer interview guide, interview questions, salary data, and interview experiences.

Pg&e Data Engineer Interview Guide

Getting ready for an Data Engineer interview at Pg&amp;e? The Pg&amp;e Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Pg&amp;e Data Engineer roles.</li>
<li>Gain insights into the Data Engineer interview process at Pg&amp;e.</li>
<li>Practice real Pg&amp;e Data Engineer interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Pg&amp;e Data Engineer interview.


Getting ready for an Data Engineer interview at Pg&e? The Pg&e Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Pg&e Data Engineer roles.
- Gain insights into the Data Engineer interview process at Pg&e.
- Practice real Pg&e Data Engineer interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Pg&e Data Engineer interview.
        

Overview

Pg&e Data Engineer Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Pg&e Data Engineer Interview Process

Given a table called <code>employees</code>, get the largest salary of any employee by department

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>department</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>largest_salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Write a query to get the largest salary of any employee by department

Largest Salary by Department

You’re tasked with designing a database system for Swipe Inc., a company that manages payments for software developers. Swipe manages a set of APIs so developers can abstract payment processes for their web service and transfer control over to Swipe’s APIs to manage payment security and finance handling (contacting credit card providers, etc.)

Your database system should store a collection of API keys with their attributes, as shown in the example below:

<pre tabindex="0" class="chroma"><code>{
 &#34;API_key&#34;:{
 &#34;Transaction_list&#34;:{
 &#34;User_ID&#34;:{
 &#34;Name&#34;:{
 &#34;f_name&#34;: 
 &#34;l_name&#34;: 
 }
 &#34;Card_Details&#34;:{
 &#34;Bank&#34;:
 &#34;Card_No&#34;:
 &#34;Expiry&#34;:
 &#34;CV&#34;:
 } 
 }
 }
 &#34;Curr_balance&#34;:
 }
}
</code></pre>

What are the functional and non-functional requirements for this database?

Determine the requirements for designing a database system to store payment APIs

Swipe Payment API

You are given a dictionary with a key-value of <code>{string: number}</code> where values in the dictionary could be duplicates. You are required to extract the unique values from the dictionary where the value occurred only once.

Return a list of values where they occur only once.

Note: You can return the values in any order.

Input:

<pre tabindex="0" class="chroma"><code>dictionary = {&#34;key1&#34;: 1, &#34;key2&#34;: 1, &#34;key3&#34;: 7, &#34;key4&#34;: 3, &#34;key5&#34;: 4, &#34;key6&#34;: 7}
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>find_unique_values(dictionary) -&gt; [3,4]

#Only 3 and 4 occurred once.
</code></pre>

Dictionary Unique Values

Pg&e Data Engineer Interview Questions

<div id="sajCpTopImage"></div><div id="sajCpCustomDescription">Requisition ID# 159114Job Category: Information TechnologyJob Level: Individual ContributorBusiness Unit: Information TechnologyWork Type: HybridJob Location: OaklandDepartment OverviewInformation Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions.Position SummaryThe Data Analytics and Insights team is seeking an experienced and talented Senior Data Engineer to join our growing team of analytics experts. As a key member of our team, you will play an essential role in the design, development, and maintenance of data pipelines, analytic products, which includes data applications, reports, and dashboards. We are looking for a proactive, detail-oriented, and motivated individual who can thrive in a fast-paced environment and help us scale our analytic product development to meet our clients' ever-evolving needs. The data engineer will collaborate with our cross functional team including solution architects, data pipeline engineers, data analysts, and data scientists on mission critical initiatives and will ensure optimal delivery of analytic products.You will have a unique opportunity to be at the forefront of the utility industry and gain a comprehensive view of the nations most advanced smart grid. It is the perfect role for someone who would like to continue to build upon their professional experience and help advance PG&Es sustainability goals.This position is hybrid, working from your remote office and the Oakland General Office(OGO)once a month and for critical in person meetings as needed. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of thejob posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will bebased on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience,market value, geographic location, and internal equity.Although we estimatethe successful candidate hiredinto this rolewill beplaced between the entry point and the middle of the range, the decisionwill be made on a case-by-casebasis related tothese factors.This job is also eligible to participate inPG&Es discretionary incentive compensation programs.A reasonable salary range is:Bay Area Minimum: $118,000Bay Area Maximum: $188,000Responsibilities <ul><li>Work closely with Subject Matter Experts (SMEs) to design and develop data model, data pipelines and front end applications.</li><li>Implement data transformations to derive new datasets or create ontology objects necessary for business applications.</li><li>Monitor and debug critical issues such as data staleness or data quality</li><li>Improve on performance of data pipelines (latency, resource usage)</li><li>Implement operational applications using Foundry Tools (Workshop, Quiver, and Slate) </li><li>Implement data visualizations using Foundry Tools (Quiver and Contour).</li><li>Maintain applications as usage grows and requirements change.</li><li>Available for 7x24 operational support.</li></ul>Minimum Qualifications<ul><li>Bachelor's Degree in Computer Science, Engineering, or a related field.</li><li>5 years of experience as a data engineer or in a similar role</li><li>Hands-on experience with building data pipelines from ingestion to final object delivery.</li><li>Experience with developing analytic applications, reports, or dashboards</li><li>Experience in using no- and low-code tools for developing analytic applications</li><li>Strong SQL skills and experience working with large datasets and complex data structures.</li><li>Complete proficiency in Python and or Pyspark</li><li>Experience in Typescript (preferred) or Javascript</li><li>Excellent problem-solving and analytical skills with a strong attention to detail.</li><li>Experience with Palantir Foundry platform.</li></ul>Desired Qualifications<ul><li>Knowledge with commercial visualization tools such as Tableau or Power BI.</li><li>Databases familiarity with common relational database models and proprietary instantiations, such as SAP, Salesforce etc. </li><li>Git knowledge of version control / collaboration workflows and best practices </li><li>Agile familiarity with agile and iterative working methodology and rapid user feedback gathering concepts </li><li>UX design knowledge of best practices and applications </li><li>Data literacy data analysis and statistical basics to ensure correctness in data aggregation and visualization.</li></ul>#featuredjob</div><div id="sajCpQualifications"><div id="sajCpQualificationsRequired"><h3 class="jobOverviewSubtitle">Required</h3><ul></ul></div><div id="sajCpQualificationsPreferred"><h3 class="jobOverviewSubtitle">Preferred</h3><ul></ul></div></div><div id="sajCpIndustries"><h3 class="jobOverviewSubtitle">Job Industries</h3><ul><li><a id="sajCpSingleIndustryLink" href="https://www.snagajob.com//job-search/q-Other">Other</a></li></ul></div>

Requisition ID # 159114 Job Category: Information Technology Job Level: Individual ContributorBusiness Unit: Information TechnologyWork Type: HybridJob Location: Oakland Department OverviewInformation Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions. Position Summary The Data Analytics and Insights team is seeking an experienced and talented Senior Data Engineer to join our growing team of analytics experts. As a key member of our team, you will play an essential role in the design, development, and maintenance of data pipelines, analytic products, which includes data applications, reports, and dashboards. We are looking for a proactive, detail-oriented, and motivated individual who can thrive in a fast-paced environment and help us scale our analytic product development to meet our clients' ever-evolving needs. The data engineer will collaborate with our cross functional team including solution architects, data pipeline engineers, data analysts, and data scientists on mission critical initiatives and will ensure optimal delivery of analytic products. You will have a unique opportunity to be at the forefront of the utility industry and gain a comprehensive view of the nations most advanced smart grid. It is the perfect role for someone who would like to continue to build upon their professional experience and help advance PG&Es sustainability goals. This position is hybrid, working from your remote office and the Oakland General Office(OGO) once a month and for critical in person meetings as needed. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.? This job is also eligible to participate in PG&Es discretionary incentive compensation programs. A reasonable salary range is:? Bay Area Minimum: $118,000Bay Area Maximum: $188,000 Responsibilities <ul style="margin-bottom:11.0px"><li>Work closely with Subject Matter Experts (SMEs) to design and develop data model, data pipelines and front end applications.</li><li>Implement data transformations to derive new datasets or create ontology objects necessary for business applications.</li><li>Monitor and debug critical issues such as data staleness or data quality</li><li>Improve on performance of data pipelines (latency, resource usage)</li><li>Implement operational applications using Foundry Tools (Workshop, Quiver, and Slate) </li><li>Implement data visualizations using Foundry Tools (Quiver and Contour).</li><li>Maintain applications as usage grows and requirements change.</li><li>Available for 7x24 operational support.</li></ul> Minimum Qualifications<ul><li>Bachelor's Degree in Computer Science, Engineering, or a related field.</li><li>5 years of experience as a data engineer or in a similar role</li><li>Hands-on experience with building data pipelines from ingestion to final object delivery.</li><li>Experience with developing analytic applications, reports, or dashboards</li><li>Experience in using no- and low-code tools for developing analytic applications</li><li>Strong SQL skills and experience working with large datasets and complex data structures.</li><li>Complete proficiency in Python and or Pyspark</li><li>Experience in Typescript (preferred) or Javascript</li><li>Excellent problem-solving and analytical skills with a strong attention to detail.</li><li>Experience with Palantir Foundry platform.</li></ul> Desired Qualifications<ul style="margin-bottom:11.0px"><li>Knowledge with commercial visualization tools such as Tableau or Power BI.</li><li>Databases familiarity with common relational database models and proprietary instantiations, such as SAP, Salesforce etc. </li><li>Git knowledge of version control / collaboration workflows and best practices </li><li>Agile familiarity with agile and iterative working methodology and rapid user feedback gathering concepts </li><li>UX design knowledge of best practices and applications </li><li>Data literacy data analysis and statistical basics to ensure correctness in data aggregation and visualization.</li></ul> #featuredjob

Requisition ID # 158787 Job Category: Information Technology Job Level: Individual Contributor Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Department Overview Meter to Cash Requirements, Analysis & Design (MTC RAD) is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients. Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC RAD provides the utmost service to its clients, it is organized into three functional areas that align with PG&Es business operations: Customer Information, Billing/Financials, and Measure & Field Services. Each Analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. In addition, the analyst is responsible for analyzing O&M and project defects to determine business and technical impact and providing input on the priority of fixing the defects. Position Summary We are looking for a Senior Level IT applications design analyst in Customer Information team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst is mainly responsible for analyzing business requirements and developing function requirement and functional design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. A reasonable salary range is: Bay Area Minimum: $105,000 Bay Area Maximum: $169,000 Job Responsibilities Ideation: <ul> <li>Work with business organizations to guide/provide input regarding enhancement feasibility </li> <li>Using business process knowledge, proactively look for opportunities for system enhancements </li> <li>Evaluate and provide input to business needs and requirements </li> <li>Prepare estimates for customer requests </li> <li>Prepare preliminary mockups and designs </li></ul> Project: <ul> <li>Analyze/assemble Functional/non-Functional requirements </li> <li>Provide technical expertise and assistance in designing, testing and developing applications </li> <li>Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems </li> <li>Prepare final functional requirement and functional design document </li> <li>Conduct walkthrough of deliverables with business and IT Stakeholders and obtain approval/signoff </li> <li>Provide Subject Matter Expert support to developers and testers </li> <li>Work with business to document and analyze project change controls </li> <li>Support stabilization of deployed code </li></ul> Maintenance: <ul> <li>Troubleshoot potential system issues to determine if there is a defect </li> <li>Analyze production defects, identify business and system impacts and quantify problems </li> <li>Contribute to defect troubleshooting and solution design </li> <li>Assist business and technical teams with adhoc requests </li> <li>Provide functional expertise to clients for resolving business issues </li></ul> Qualifications Minimum: <ul> <li>Bachelors Degree in Computer Science/ Information Systems, Business, Engineering, etc. or equivalent work experience </li> <li>4 years of experience in analyzing, designing and developing functional requirements, functional design, UX/UI design </li> <li>3 years of experience with Oracle CC&B applications, and data modeling </li> <li>Experience in project participation, high complexity </li> </ul> Desired: <ul> <li>Working knowledge of relational databases (SQL experience) </li> <li>Working knowledge of UML </li> <li>Be able to work independently but within the framework of the team and product </li> <li>Be able to work well within a team setting </li> <li>Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement </li> <li>Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio </li> <li>Excellent verbal and written communication skills </li> <li>Working knowledge of Salesforce CRM application and data model </li> <li>Experience dealing with Call Center and/or Back Office centric business </li> <li>Understanding of database/schema architecture </li></ul> #featuredjob

Requisition ID# 158787 Job Category: Information Technology Job Level: Individual Contributor Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Department Overview Meter to Cash - Requirements, Analysis & Design (MTC RAD) is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients. Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC RAD provides the utmost service to its clients, it is organized into three functional areas that align with PG&E's business operations: Customer Information, Billing/Financials, and Measure & Field Services. Each Analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. In addition, the analyst is responsible for analyzing O&M and project defects to determine business and technical impact and providing input on the priority of fixing the defects. Position Summary We are looking for a Senior Level IT applications design analyst in Customer Information team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst is mainly responsible for analyzing business requirements and developing function requirement and functional design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. A reasonable salary range is: Bay Area Minimum: $105,000 Bay Area Maximum: $169,000 Job Responsibilities Ideation: <ul> <li>Work with business organizations to guide/provide input regarding enhancement feasibility </li> <li>Using business process knowledge, proactively look for opportunities for system enhancements </li> <li>Evaluate and provide input to business needs and requirements </li> <li>Prepare estimates for customer requests </li> <li>Prepare preliminary mockups and designs </li></ul> Project: <ul> <li>Analyze/assemble Functional/non-Functional requirements </li> <li>Provide technical expertise and assistance in designing, testing and developing applications </li> <li>Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems </li> <li>Prepare final functional requirement and functional design document </li> <li>Conduct walkthrough of deliverables with business and IT Stakeholders and obtain approval/signoff </li> <li>Provide Subject Matter Expert support to developers and testers </li> <li>Work with business to document and analyze project change controls </li> <li>Support stabilization of deployed code </li></ul> Maintenance: <ul> <li>Troubleshoot potential system issues to determine if there is a defect </li> <li>Analyze production defects, identify business and system impacts and quantify problems </li> <li>Contribute to defect troubleshooting and solution design </li> <li>Assist business and technical teams with adhoc requests </li> <li>Provide functional expertise to clients for resolving business issues </li></ul> Qualifications Minimum: <ul> <li>Bachelors Degree in Computer Science/ Information Systems, Business, Engineering, etc. or equivalent work experience </li> <li>4 years of experience in analyzing, designing and developing functional requirements, functional design, UX/UI design </li> <li>3 years of experience with Oracle CC&B applications, and data modeling </li> <li>Experience in project participation, high complexity </li> </ul> Desired: <ul> <li>Working knowledge of relational databases (SQL experience) </li> <li>Working knowledge of UML </li> <li>Be able to work independently but within the framework of the team and product </li> <li>Be able to work well within a team setting </li> <li>Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement </li> <li>Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio </li> <li>Excellent verbal and written communication skills </li> <li>Working knowledge of Salesforce CRM application and data model </li> <li>Experience dealing with Call Center and/or Back Office centric business </li> <li>Understanding of database/schema architecture </li></ul> #featuredjob

Requisition ID # 158787 Job Category: Information Technology Job Level: Individual ContributorBusiness Unit: Information TechnologyWork Type: HybridJob Location: Oakland Department OverviewMeter to Cash Requirements, Analysis & Design (MTC RAD) is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients. Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC RAD provides the utmost service to its clients, it is organized into three functional areas that align with PG&Es business operations: Customer Information, Billing/Financials, and Measure & Field Services. Each Analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. In addition, the analyst is responsible for analyzing O&M and project defects to determine business and technical impact and providing input on the priority of fixing the defects. Position SummaryWe are looking for a Senior Level IT applications design analyst in Customer Information team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst is mainly responsible for analyzing business requirements and developing function requirement and functional design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. A reasonable salary range is:Bay Area Minimum: $105,000Bay Area Maximum: $169,000 Job ResponsibilitiesIdeation:<ul><li style="text-align:justify">Work with business organizations to guide/provide input regarding enhancement feasibility</li><li style="text-align:justify">Using business process knowledge, proactively look for opportunities for system enhancements</li><li style="text-align:justify">Evaluate and provide input to business needs and requirements</li><li style="text-align:justify">Prepare estimates for customer requests</li><li style="text-align:justify">Prepare preliminary mockups and designs </li></ul> Project:<ul><li style="text-align:justify">Analyze/assemble Functional/non-Functional requirements</li><li style="text-align:justify">Provide technical expertise and assistance in designing, testing and developing applications</li><li style="text-align:justify">Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems</li><li style="text-align:justify">Prepare final functional requirement and functional design document</li><li style="text-align:justify">Conduct walkthrough of deliverables with business and IT Stakeholders and obtain approval/signoff</li><li style="text-align:justify">Provide Subject Matter Expert support to developers and testers</li><li style="text-align:justify">Work with business to document and analyze project change controls</li><li style="text-align:justify">Support stabilization of deployed code</li></ul> Maintenance:<ul><li style="text-align:justify">Troubleshoot potential system issues to determine if there is a defect</li><li style="text-align:justify">Analyze production defects, identify business and system impacts and quantify problems</li><li style="text-align:justify">Contribute to defect troubleshooting and solution design</li><li style="text-align:justify">Assist business and technical teams with adhoc requests</li><li style="text-align:justify">Provide functional expertise to clients for resolving business issues</li></ul> QualificationsMinimum:<ul><li>Bachelors Degree in Computer Science/ Information Systems, Business, Engineering, etc. or equivalent work experience </li><li>4 years of experience in analyzing, designing and developing functional requirements, functional design, UX/UI design</li><li>3 years of experience with Oracle CC&B applications, and data modeling </li><li>Experience in project participation, high complexity </li></ul>Desired:<ul><li style="text-align:justify">Working knowledge of relational databases (SQL experience) </li><li style="text-align:justify">Working knowledge of UML</li><li style="text-align:justify">Be able to work independently but within the framework of the team and product</li><li style="text-align:justify">Be able to work well within a team setting</li><li style="text-align:justify">Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement</li><li style="text-align:justify">Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio</li><li style="text-align:justify">Excellent verbal and written communication skills</li><li style="text-align:justify">Working knowledge of Salesforce CRM application and data model</li><li style="text-align:justify">Experience dealing with Call Center and/or Back Office centric business</li><li style="text-align:justify">Understanding of database/schema architecture</li></ul> #featuredjob

Senior Data Engineer Immediate opportunity for a Senior Data Engineer to join a top-notch company experiencing rapid growth! RESPONSIBILITIES: <ul><li>Contribute to a team of data engineers through design, demand delivery, code reviews, release management, implementation, presentations, and meetings.</li><li>Mentor fellow data engineers and contribute to ongoing process improvements for the team</li><li>Evaluate business needs and objectives and align architecture/designs with business requirements</li><li>Build the data pipelines required for the optimal extraction, transformation, integration, and loading of raw data from a wide variety of data sources</li><li>Assemble large, complex data sets and model our data in a way that meets functional / non-functional business requirements</li><li>Create data tools for analytics team members that assist them in generating innovative industry insights that provide our business a competitive advantage</li><li>Implement data tagging mechanisms and metadata management so data is accurately classified and visible to the organization</li><li>Build processes to help identify and improve data quality, consistency, and effectiveness</li><li>Ensure our data is managed in a way that conforms to all information privacy and protection policies</li><li>Use agile software development processes to iteratively make improvements to our data management systems</li><li>Identify opportunities for automation</li><li>Be an advocate for best practices and continued learning</li></ul> This is a direct-hire position in Atlanta. Work a hybrid schedule - onsite three days a week at our Smyrna location! REQUIRED SKILLS:<ul><li>4+ years of data management experience</li><li>3+ years in data engineering with detailed knowledge of data warehouse technical architectures, infrastructure components, and ETL/ELT</li><li>Experience with performance analysis and optimization.</li><li>Experience in data acquisition, transformation, and storage design using design principles, patterns, and best practices.</li><li>Experience with Informatica, Kafka, CDC, SQL, Irwin, Python, AWS (S3, Athena, Glue, Kinesis, Redshift), Spark, Scala, AI/ML, Modern data platforms, Snowflake, dbt, Fivetran, and Airflow.</li></ul> PREFERRED SKILLS:<ul><li>Data engineering certification</li><li> Bachelor's degree</li></ul> Must be authorized to work in the US. Sponsorships are not available.***NO 3RD PARTIES OR C2C!!

Position Title: Data Engineer / Analyst Direct Hire Remote - EST only Essential Functions:<ul><li>Meet with stakeholders to determine data requirements.</li><li>Develop reports, dashboards, and analytics to improve organizational outcomes.</li><li>Use ETL tools to extract, transform, and load data.</li><li>Analyze data for trends and patterns; prepare reports for management.</li><li>Collaborate with teams to identify process improvements and data governance strategies.</li><li>Troubleshoot and resolve data issues promptly. </li></ul>Qualifications:<ul><li>BS in Computer Science, Data Analytics, or Business Analytics.</li><li>2+ years of experience in a related field, preferably in HVAC or similar industries.</li><li>Proficiency in SQL, ETL processes, and data accuracy.</li><li>Experience with Power BI, SSRS, and ETL tools.</li><li>Strong problem-solving skills and attention to detail.</li><li>Experience with BuildOps, SageIntacct, ADP, and data sourcing from databases and APIs is a plus.</li></ul>Apply now!

Data Engineer Location: Atlanta, GA (Hybrid)Position Type: Contract, W2 (September 2024 - April 2025)$55-$62/hour About Us:Our Energy and Utilities client is a leading provider of reliable and sustainable energy solutions. We are committed to innovation and efficiency in every aspect of our operations. As part of our continued growth and digital transformation efforts, we are seeking a skilled Data Engineer to join our team on a contract basis. Position Overview:The Data Engineer will play a critical role in managing and optimizing data pipelines, ensuring the reliability and scalability of our data architecture. This role involves working closely with cross-functional teams, including IT, data science, and business units, to support data-driven decision-making processes. The ideal candidate will have a strong background in data engineering within the energy and utilities sector. Key Responsibilities:<ul><li>Data Pipeline Development: Design, build, and maintain scalable data pipelines to collect, process, and analyze large datasets from various sources.</li><li>Data Integration: Integrate data from multiple sources, ensuring data consistency, quality, and availability for analytical and operational needs.</li><li>Data Modeling: Develop and optimize data models to support efficient storage, retrieval, and analysis of data.</li><li>ETL Processes: Implement and manage ETL (Extract, Transform, Load) processes to ensure timely and accurate data delivery.</li><li>Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver high-quality data solutions.</li><li>Data Quality: Monitor and improve data quality, implementing best practices for data governance and security.</li><li>Performance Optimization: Optimize database performance and query execution, ensuring the system meets performance standards.</li><li>Documentation: Create and maintain detailed documentation of data engineering processes, workflows, and systems.</li></ul> Qualifications:<ul><li>Education: Bachelor's or Master’s degree in Computer Science, Data Engineering, Information Technology, or a related field.</li><li>Experience:</li><li>Proven experience as a Data Engineer, preferably within the energy and utilities industry.</li><li>Strong experience with SQL and NoSQL databases, data warehousing solutions, and ETL tools.</li><li>Proficiency in programming languages such as Python, Java, or Scala.</li><li>Familiarity with cloud platforms like AWS, Azure, or Google Cloud.</li><li>Experience with big data technologies such as Hadoop, Spark, or Kafka is a plus.</li><li>Skills:</li><li>Excellent problem-solving skills and attention to detail.</li><li>Strong understanding of data structures, algorithms, and data architecture best practices.</li><li>Ability to work collaboratively in a fast-paced environment.</li><li>Effective communication skills, with the ability to translate technical concepts for non-technical stakeholders.</li></ul>

Pg&e Data Engineer Interview Guide

Overview

Pg&e Data Engineer Salary

Pg&e Data Engineer Interview Process

Pg&e Data Engineer Interview Questions

Pg&e Data Engineer Jobs