Data Analyst Expert

BayOne Solutions; Oakland (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

BayOne Solutions in Oakland is seeking an experienced data/engineering professional to support utility planning and DER integration initiatives. You will build consensus across matrixed teams and deliver complex models in a fast-paced environment.

Requirements include a Bachelor’s degree in data science, computer science, or engineering and 5+ years of related experience, with hands-on Python/SQL, data warehousing, ETL, and BI tooling expertise. California regulatory context knowledge is a plus.

Qualifications

• Bachelor's degree in data science, computer science, engineering or equivalent experience.
• 5 years of related experience or equivalent.
• Experience with programming and scripting languages, such as Python and SQL.
• Experience with data warehousing, data quality, and ETL techniques.
• Experience with data processing tools such as Excel, SharePoint, and Microsoft Lists.
• Experience with financial and techno-economic modeling.

Skills

Consensus-building

Project coordination

Matrixed teams

Strong communication

Education

Bachelor's degree in data science, computer science, engineering or equivalent experience

Master’s degree in business administration, engineering, or another advanced degree

Tools

Python

SQL

ETL

Excel

SharePoint

Microsoft Lists

Data warehousing

Data quality

Power BI

CYMDIST

PSLF

Aspen

Job description

• A strong applicant will be organized and motivated, with a demonstrated track record of building consensus and managing many moving parts within matrixed teams.
• Bachelor's degree in data science, computer science, engineering or equivalent experience.
• 5 years of related experience or equivalent.
• Experience with programming and scripting languages, such as Python and SQL.
• Experience with data warehousing, data quality, and ETL techniques.
• Experience with data processing tools such as Excel, SharePoint, and Microsoft Lists.
• Experience with financial and techno-economic modeling.

Desired Qualifications:

• Degree or advanced coursework in data science, engineering, economics, energy systems, or a related field.
• Master’s degree in business administration, engineering, or another advanced degree.
• Experience with grid modeling, power flow, or planning tools such as CYMDIST, PSLF, Aspen, or similar applications.
• Experience with business intelligence platforms, such as Power BI.
• Experience in transmission or distribution system planning and operations.
• Knowledge of DER integration, communications protocols, and grid impacts, including IEEE 2030.5, CSIP 2.1, OpenADR, aggregator APIs, distributed generation impacts, power electronics, and telecommunications.
• Experience with DER valuation frameworks, financial modeling, business case development, and methodologies such as the Avoided Cost Calculator, Non-Wires Alternatives, and related approaches.
• Demonstrated experience in project, product, or program management in the context of utility operations, IT systems, or DER product deployment.
• Familiarity with California utility regulations, regulatory processes, and policy context.

Desired Characteristics:

• Strong drive for results and continuous improvement.
• Strong ability to lead initiatives from concept to completion.
• Excellent verbal and written communication skills.
• Ability to work effectively in a matrixed environment with a positive, execution-oriented mindset.
• Ability to navigate ambiguity, adapt quickly, and move work forward independently.
• High attention to detail and strong organizational skills.