Back to jobs

Data Analyst

San Diego, California

 

We are looking for talented and motivated professionals to join our team! We invite you to apply for our open position(s) below.

 

 

OPEN POSITION ANNOUNCEMENT!

 

Data Analyst

Open until filled.

Posted 4/11/2025 San Diego County - hybrid work schedule set by Community Power

 

ABOUT THE ROLE:  Community Power "SDCP" is seeking an experienced, driven, detail oriented and solutions-focused professional to join our growing team as a Data Analyst. Under supervision of the Data Analytics Manager, the Data Analyst will be responsible for developing Business Intelligence (BI) reports and dashboards, handling and tracking data requests, testing and validating data, and contributing to data analysis projects. The Data Analyst will work with datasets from our local Investor-Owned Utility (San Diego Gas & Electric) and external Data Management vendors that can include electric meter data, billing data, program data and geospatial data. This role will be key for supporting the needs of internal departments and external stakeholders, by enabling them to find needed datasets and generate business insights.

 

WHO IS COMMUNITY POWER?

Community Power is a community-driven, not-for-profit public agency providing cleaner energy to the San Diego region. Formed in 2019, Community Power is the second largest Community Choice Aggregator (CCA) in California, serving nearly 1 million customer accounts across its member agencies: the Cities of San Diego, Chula Vista, Encinitas, Imperial Beach, La Mesa and National City, as well as the unincorporated areas of San Diego County.  

 

OUR HISTORY

Community Power was formed in 2019 as a public, not-for-profit community choice aggregator (CCA) in the San Diego region. We began electric service in 2021 and now serve seven member agencies: the Cities of San Diego, Chula Vista, Encinitas, Imperial Beach, La Mesa and National City, as well as the unincorporated communities of San Diego County. Community Power was formed to bring local control and customer choice to San Diego while also providing clean and renewable energy at competitive rates. We are the second largest CCA in California, serving nearly 1 million customers. For more information, please visit SDCommunityPower.org.

 

COMMITMENT TO DIVERSITY

At Community Power, we value diversity and are committed to creating an inclusive environment for all employees. We represent a diverse customer base and hope to hire employees that reflect our communities. We provide equal employment opportunities to all applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. 

 

ESSENTIAL DUTIES AND PRIMARY RESPONSIBILITES

  • Develop queries to analyze data, find insights, and answer questions
  • Develop reports and dashboards for internal insights and analysis
  • Develop and maintain reports and dashboards for public meetings including Board of Directors, Community Advisory Committee and Financial Risk Management Committee
  • Work with other teams to develop needed reports and dashboards
  • Work to standardize reports to create consistency and repeatability
  • Assist users across the organization with use of Business Intelligence (BI) tools, troubleshoot reports, answer data questions and help use and understand reports
  • Receive and handle data requests from internal and external stakeholders
  • Maintain data request tracking for all incoming data requests
  • Maintain tracking of how requested data is securely shared, transferred and stored with internal and external stakeholders
  • Assist with Quality Assurance and testing of incoming and outgoing data, new implementations, and data across systems and platforms
  • Develop testing procedures to validate report data
  • Work with vendors to troubleshoot data issues
  • Write staff reports and deliver presentations at Board meetings
  • Follow best practices as well as internal guidelines for data governance, responsible use and handling of sensitive or private information.
  • Collaborate on data analysis projects
  • Perform related duties and responsibilities as required

 

KNOWLEDGE, SKILLS AND ABILITIES

  • Conduct research, analyze data, and evaluate issues and programs and offer solutions
  • Evaluate data to determine progress towards reaching agency goals
  • Use statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts
  • Prepare clear and comprehensive correspondence, reports, presentations, proposals, and carry out independent research and fact-finding assignments
  • Determine, develop, and implement objectives, strategies, policies, procedures, work standards, and internal controls to achieve short and long-term data governance goals
  • Define problem areas and evaluate, recommend, and implement alternative solutions to complex issues and problems
  • Effectively represent SDCP before the Board of Directors, Community Advisory Council, as well as in public and internal meetings
  • Deal tactfully and maintain effective working and diplomatic relations with various levels of staff, the public, civic organizations, and representatives from governmental, 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
  • Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines

 

EXPERIENCE:

  • Strong experience with SQL, querying, database structure, and performing complex joins
  • Strong experience with Python (and relevant packages) or other scripting languages
  • Strong experience with Business Intelligence (BI) tools (PowerBI, Tableau, Qlik)
  • Experience with AWS or other Cloud data platforms
  • Experience with large datasets, complex joins, and a variety of data
  • Experience with Microsoft Excel
  • Preferred experience in Energy, Electricity or Renewable Energy industries
  • Preferred experience with ArcGIS or other GIS (geographic information systems) tools
  • Preferred experience with CRM systems (Microsoft Dynamics 365, Salesforce, etc.)
  • Preferred experience with CCAs (Community Choice Aggregation or Community Energy)

 

QUALIFICATIONS & 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:
 
A four-year degree from an accredited college or university in Data Science, Computer Science, Statistics, Machine Learning, Mathematics, Economics, or any other related quantitative field.
 
AND

A minimum of two to three (2-3) years of progressively responsible experience in a data or business analytics capacity or related field. 

 

WORK ENVIRONMENT AND CONDITIONS

Prolonged periods of sitting at a desk and working on a computer. The position requires occasional carrying, lifting and/or moving objects up to 25 pounds. 

Occasional local travel required, and reliable transportation is expected to be able to attend Community Power events, meetings, and workshops as needed as needed. 

At Community Power we work in the communities we serve and in the office. Community Power works to ensure a safe and healthy workplace for employees and in our communities. Community Power requires employees to be fully vaccinated for COVID-19. Exemptions to the vaccine requirement will be considered for individuals with medical conditions that prevent them from being vaccinated and for individuals with sincerely held religious beliefs that prohibit them from being vaccinated, consistent with governing labor laws.

Community Power is an agency required to adopt and promulgate a Conflict-of-Interest Code (“COI”). The COI code requires employees in designated positions, including those identified under the interim disclosure process, to file a Statement of Economic Interests (Form 700) on an annual basis. A Successful candidate accepting this position may be required to file Conflict of Interest forms subject to the regulations of the Fair Political Practices Commission. 

 

Compensation: 

Salary Range: The position salary range is: $84,900 - $110,400; with exact compensation to be determined by Community Power, depending upon experience. 

Benefits: Standard benefits package including but not limited to:

Insurance: Community Power covers 100% of health benefits, including medical, vision, and dental insurance, for eligible FT employees and their dependents. Also provided is a $100,000 Life & AD&D policy, STD and LTD coverage that is 100% paid by Community Power.

Retirement: Community Power offers a 457(b) plan for employee contributions and contributes 10% of eligible compensation to the employee’s Money Purchase Plan.

Paid Time Off: 11 holidays per year + paid winter holiday (between 12/24-12/31), 160 hours of accrued paid time off per year (increases with time in service), and 96 hours per year of accrued paid sick leave.

 

This job description may not be inclusive of all assigned duties, responsibilities, or aspects of the job described, and may be amended at the discretion of Community Power as needed. 

 

 

 

California Pay Range

$84,900 - $110,400 USD

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter*

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Please provide three (3) professional references, their email addresses and your working relationship to your listed reference.*

Accepted file types: pdf, doc, docx, txt, rtf

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Community Power’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.