Operations Data Analyst, Senior

TheCorporate LLC; Michigan; Hybrid; USD 110,000 - 150,000; Full time

Job summary

TheCorporate LLC in Oakland, CA is seeking an Operations Data Analyst, Senior to join our data analytics team. You will support electrification programs by building scalable data pipelines, dashboards, and reports to drive decision making.

Candidates should have strong coding skills in Python and SQL, experience with ETL processes, and the ability to communicate insights clearly to stakeholders. This role is hybrid with monthly onsite presence in OGO.

Qualifications

• BA/BS degree or equivalent work experience.
• 4 years of related work experience required.

Responsibilities

• ETL Pipeline Creation: Develop and maintain an extract-transform-load data pipeline across multiple data environments to screen and prioritize electrification opportunities.
• 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 dashboards or ad hoc reports.

Skills

Python

SQL

ETL Pipelines

Data visualization

Dashboards

Communication

GIS

Education

BA/BS in Computer Science, Engineering, or related field

Job description

Job Title:

Operations Data Analyst, Senior

**Location:**Oakland, CA

Notes

• Local candidates only. The role is hybrid with once a month onsite in OGO

TOP THINGS:

• Coding skills (Python, SQL, etc.)
• Experience developing ETL pipelines
• Demonstrated communication skills.

Job Description:

Operations Data Analyst, Senior

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.