Data Analyst

Description

Central Coast Community Energy’s (CCCE) Data Analytics Team is developing Business Intelligence (BI) and analytics capabilities, including reporting, dashboards, predictive analytics, and descriptive analytics. These new analytics span financial and operational data. They will leverage a wide variety of internal and external data sources; developing them will include building data pipelines, cleaning data, automating processes, and automating reporting and analytics.
CCCE is also developing larger infrastructure projects such as a Risk Management Data Platform and a Customer Data Platform. This position will support financial analysis, analytics development and infrastructure projects under the general supervision of the Director of Data Analytics
We offer a career-building opportunity, competitive salary and a generous benefits package in Monterey – one of the most beautiful and geographically diverse areas in the country, with beaches, mountains, oceans and vineyards. World-famous for Pebble Beach, Carmel by the Sea, the Monterey Jazz Festival, golf, resorts and a Mediterranean atmosphere, Monterey is a unique location less than 90 minutes from the San Francisco Bay Area.
Additional Information

*
CCCE requires all employees to be fully vaccinated against COVID-19 as a condition of employment.

• Excellent pay and generous benefits including health, retirement, and paid leave
• The typical target salary for this role is $95,000
• Remote or hybrid work options will be considered.

Continuous until filled. The recruitment may be extended or closed as early as 10 days after issue date. You are encouraged to apply as soon as possible.*
Supervision Received/Exercised*
This position reports to the Director of Data Analytics and no direct supervision is exercised.

Example of Duties

Essential Duties and Responsibilities (including but not limited to):

• Analyzes a wide variety of financial and operational data, delivering insights and solutions across the organization. Analyses can range from customer consumption patterns by geography to rate impacts
• Develops reports, extracts, dashboards, and analytics packages. Gathers requirements from CCCE staff and external consultants.
• Builds pipelines to data vendors using APIs.
• Administers data connectors to enable access to data platforms from project team tools (e.g., Tableau, Microsoft Excel, ArcGIS, etc.).
• Develops and implements automated data retrieval, validation, cleaning, reporting, and metrics.
• Document solutions and business processes.
• Performs related duties as assigned.

Typical Qualifications

Experience/Education
Any combination of education and experience that would provide the knowledge and abilities listed. A typical way to obtain the require qualifications would be:

Education and experience equivalent to a bachelor’s degree from an accredited college or university in accounting, finance, mathematics, economics, or a social science field with a significant quantitative analysis component.
*
AND*
A minimum of two (2) years of progressively responsible work experience.
Experience in the energy industry is highly desirable.

Knowledge, Skills, and Abilities

Knowledge of:

• SQL in a professional environment, including writing queries and extracts.
• Python in a professional environment, including, at a minimum, NumPy, pandas, and Matplotlib. Experience with Scikit-learn or seaborn is highly desirable.
• Data Analytics Expressions (DAX) is highly desirable.
• Basic statistical methods, such as correlations and regressions, is highly desirable.
• Advanced Excel skills.
• Experience with Tableau and with Azure are highly desirable.
• Microsoft Office Suite (Word, Excel, and PowerPoint) and Adobe Acrobat.

*_
Ability to: _*

• Research, analyze and interpret complex data; reach conclusions and make recommendations
• Define problem areas and evaluate, recommend, and implement alternative solutions to complex issues and problems
• Be detail oriented and manage multiple projects in a fast-paced environment
• Work independently
• Deal tactfully and maintain effective working and diplomatic relations with various levels of staff, the public, civic organizations, and representatives from government, industry, media, and other agencies
• Demonstrate sensitivity to and respect for the rights of individuals and differences in people’s ethnic and cultural heritage, attitudes, beliefs, goals, and interests
• Promote teamwork, a positive work environment, and collaborative problem solving
• Work effectively under stressful situations involving tight deadlines, including ability to work occasional evening and weekend hours
• Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines

Job Type: Full-time

Pay: From $95,000.00 per year

Work Location: One location

GET THE BOOK