Senior Operations Data Analyst

TheCorporate LLC; Oakland (CA); On-site; USD 105,000 - 135,000; Full time

Job summary

TheCorporate LLC in Oakland, CA is seeking a Senior Operations Data Analyst to support electrification analytics and decarbonization initiatives. You will work across data environments to build reliable ETL pipelines and deliver insights to guide program decisions.

Ideal candidates have strong Python and SQL skills, experience with dashboards, data visualization, and GIS; familiarity with utility operations is a plus, as is the ability to clearly communicate findings to stakeholders.

Qualifications

• BA/BS Degree in Computer Science, Engineering, or related field or equivalent work experience.
• 4 years of related work experience.

Responsibilities

• ETL Pipeline Creation: Develop and maintain an ETL pipeline across multiple data environments to screen electrification opportunities.
• New Data Sources: Provide recommendations to enhance data pipelines with new data sources and improved data processes.
• Process Automation: Create automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation and data cleansing.
• Dashboards and Ad Hoc Analysis: Develop and communicate clear, concise, and actionable data analyses in dashboards or ad hoc reports.

Skills

Python

SQL

ETL pipelines

Data visualization

GIS

Utility operations

Communication

Education

BA/BS in Computer Science or Engineering or related field

Job description

Job Title

Operations Data Analyst, Senior

Location

Oakland, CA

Notes

TOP THINGS

1. Coding skills (Python, SQL, etc.)
2. Experience developing ETL pipelines
3. Demonstrated communication skills.

Job Description

Role Summary:

Analytics support for NPA and zonal electrification programs, an initiative focused on accelerating building electrification to avoid gas infrastructure investments and support long-term decarbonization goals

Key Responsibilities

• ETL Pipeline Creation: Develop and maintain an extract-transform-load data pipeline across multiple different core data environments to screen and prioritize electrification opportunities across system.
• New Data Sources: Provide recommendations to enhance data pipeline with new data sources and improved data processes.
• Process Automation: Create automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation and data cleansing.
• Dashboards and Ad Hoc Analysis: Develop and communicate clear, concise, and actionable data analyses in the form of dashboards or ad hoc reports.

Education Minimum

• BA/BS Degree in Computer Science, Engineering, or other related field or equivalent work experience

Minimum Experience

• 4 years of related work experience

Knowledge, Skills, and Abilities (Desired)

• Advanced skill in Python (or similar programming languages) for data analysis and automation.
• Advanced skill in SQL and database query languages for extracting, transforming, and analyzing data from data environments.
• Advanced skill in designing and maintaining ETL processes for large datasets.
• Experience with data visualization and dashboarding tools.
• Experience in GIS preferred.
• Familiarity with utility operations.
• Able to analyze and interpret data and effectively communicate findings.