Peninsula Clean Energy

Data Engineer

LocationRedwood City, CA
Job Typefull_time
Salary$110,000-$145,000

About This Job


Job Title: Data Engineer


Salary: $110,000 to $145,000 (commensurate with experience)



Job Type: Full-Time with Benefits


Location: California residency is required. We are a remote-first work environment with a strong preference to hire staff within a 100-mile radius of San Mateo County. Employees are expected to attend in-person meetings (generally monthly/quarterly) at our Redwood City office. Other meetings may be required.

Visas and Relocation: We regret that we are unable to sponsor Visas at this time and that no relocation assistance is available.



About Peninsula Clean Energy


Peninsula Clean Energy is the community choice energy program (known as a "CCA") for San Mateo County and portions of Merced County. Peninsula Clean Energy's customer base includes approximately 310,000 accounts, serving a population of 800,000, with a total electrical load of almost 4 million megawatt-hours.


Our mission is to reduce greenhouse gas emissions by expanding access to sustainable and affordable energy solutions. This includes providing cleaner power at lower rates with virtually GHG-free power as its standard power service. We have aggressive decarbonization goals including delivering 100% renewable energy and supporting its service territory in reaching comprehensive decarbonization for transportation and buildings. Peninsula Clean Energy is making significant and growing investments to advance these objectives, providing a full spectrum of programs and pilots to serve the community.



Position Summary

PCE is looking for a Data Engineer who is an experienced data pipeline builder, data wrangler, and enjoys optimizing data systems. They will be working under the direction of the Director of Data and Technology and will be responsible for expanding and enhancing our data and data pipeline architecture, improving data flow and collection for cross functional teams, as well as building dashboards and reporting tools.



Duties and Responsibilities

Maintain and enhance the current infrastructure for the extraction, transformation, and loading (ETL) of data from a wide variety of data sources

Develop methods for aggregating large volumes of data across different sources

Implement process improvements for the automation of manual processes, optimization of data ingestion and delivery, and scalability of the data system

Develop best practices for data storage and query optimization to reduce the cost and resources

Standardize and clean-up data warehouse data sets and table schemas

Build robust error monitoring dashboards and methods for debugging issues

Clean and validate the data quality from our provider data streams

Design and develop analytics dashboards and tools utilizing the data pipeline for reporting, data visualization, and key business metrics

Develop documentation for current and new data processes

Work closely with stakeholders in other departments on ad hoc or ongoing analyses and insights

Understanding requirements and mapping to actionable tasks

Perform other duties as required



Knowledge and Skills

Advanced working SQL knowledge

Knowledge of different types of databases and architecture differences

Experience with
databases and query (SQL) optimization

Excellent scripting and programming skills, including Python and R

Experience building data pipelines, architecture, and datasets

Strong analytical skills working in unstructured datasets

Significant working knowledge of the Google Cloud Platform, including but not limited to BigQuery, Cloud Storage, Cloud Functions, Cloud Scheduler, Cloud Run, Compute Engine, VPC Network, IAM Roles

Experience with translating business requirements to business insights via dashboards and data visualization

Advanced working knowledge of backend APIs

Experience supporting and working with cross-functional teams in a dynamic environment



Nice to have

Understanding of statistics, machine learning, and optimization algorithms and principles, and their application (regression analysis, time series, probabilistic models, supervised classification, and unsupervised learning)

Strong project management and organizational skills

Energy industry domain knowledge

Software development processes and tools: Github, CI/CD



Required Experience

3+ years of progressively responsible experience as a Data Engineer or similar role at a software company, electric utility, cleantech company, or similar organization

B.S./B.A. in a related field.



SALARY AND BENEFITS


Compensation is commensurate with experience. Peninsula Clean Energy offers a generous benefits package including:

Individual, family and domestic partner health (medical, dental, vision) insurance
Retirement and employer matching contributions
Health and dependent care flex spending account
Long term disability benefits
Cell phone and internet stipend for remote work
Paid parental leave
Paid vacation



APPLICATION PROCESS

Please include:

Cover Letter describing your experience in the energy industry and why you're a fit for this role (optional)

Resume (required)
Answers to three application questions (required)

Trending Jobs

company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, TX
2 months ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, NM
about 1 month ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, TX
2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, TX
about 1 month ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, LA
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, TX
3 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, TX
over 1 year ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, OK
4 months ago
company-logo

Business Analyst – Accounting

Permian Resources
Job TypeFull-time
Salary
$110000 - $150000
The Woodlands, Texas
7 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, TX
3 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, TX
6 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, PA
5 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, PA
5 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, TX
2 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Midland, TX
4 months ago
company-logo

Civil/Structural Designer

Dudley Staffing
Job TypeFull-time
Salary
$30 - $60
Canonsburg, PA
5 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Cheyenne, WY
4 months ago
company-logo

Data Analyst

River City Science Academy
Job TypeFull-time
Salary
$20 - $45
Jacksonville, FL
4 months ago
company-logo

Senior Division Order Analyst

Formentera
Job TypeFull-time
Salary
$110000 - $130000
Austin, TX
about 1 year ago