Data Analyst

Orange County Power Authority
Data Analyst

Orange County Power Authority (Authority) is a new community choice aggregator (CCA) in Orange County that will launch phased electric service beginning in April 2022. Upon full implementation, the Authority will service over 366,000 accounts in Southern California Edison and San Diego Gas & Electric territories. We serve five member agencies (Buena Park, Fullerton, Huntington Beach, Irvine, and County of Orange (unincorporated areas)) with the potential of expansion throughout the region. For more information, please visit our website at www.ocpower.org.

APPLICATION PROCESS
Applications will be accepted on a continuous basis.

THE POSITION
OCPA is seeking an experienced and enthused professional to join our growing team as Data Analyst (DA). Under direction of the CFO, the DA will carry out complex and sophisticated analytical analyses for OCPA rates, IOUs billing operations management, customer account services, and load forecasting. The DA will collaborate closely with other teams (Power Services, Communications & External Affairs, Regulatory and Legislative Affairs) to develop solutions to data-intensive problems.

This is an at-will exempt position reporting directly to the CFO.

SUPERVISORY RESPONSIBILITIES
This position has no supervisory responsibilities.

CULTURE
Orange County Power Authority fosters a culture of open communication, responsibility, and intellectual curiosity. We value transparency, innovation, and an entrepreneurial spirt. We pride ourselves on having a collaborative work environment and seek a team player for this position.
Candidates can expect an environment offering challenging and rewarding work.

EXAMPLES OF DUTIES / FUNCTIONS
Management reserves the right to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees with disabilities can perform the essential functions of the job.

• Manage financial reporting and reconciliations provided by the data management service provider to ensure accuracy and completeness. Develop and track business metrics.
• Research legislation and regulatory changes that affect OCPA's rate design and implementation. Maintain financial models for forecasting revenue requirements. Prepare statistical, feasibility, and sensitivity analysis.
• Perform budgets and forecasts on rates, Power Charge Indifference Adjustment (PCIA), data management and related accounts.

• Collaborate with internal and external stakeholders to understand business and policy challenges, goals and objectives and translate them into data analytics use cases.
• Collaborate closely with third-party data analytics consultants and other OCPA teams to develop the OCPA Data Analytics Platform with data dashboards and visualizations to support overall business goals.
• Identify and drive process improvements. Increase productivity by developing automated reporting tools.
• Prepare a variety of professional reports, presentations, and correspondence in assignment area.
• Perform other duties as assigned.

QUALIFICATIONS

Minimum Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily with or without accommodation.

The successful candidate will bring a mix of data analytics acumen, the ability to work independently and collaboratively with OCPA staff, a passion for building solutions and streamlining processes, a commitment to data-driven decision-making, and a deep interest in OCPA’s mission. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Candidates must hold a Bachelor of Arts or Bachelor of Science degree from an accredited college or university in Accounting, Finance, Statistics, Economics, Math, Engineering, or closely related field AND at least three (3) years of experience in data analytics, utility rate design, and rate analyses. Start-up working experience in a Community Choice Aggregation (CCA) and/or electric utility is highly desirable. Must be able to sit at a desk and work on a computer for prolonged periods.

Required Skills:

• Strong technical analytic skills: o Expert proficiency in Excel modeling o MS SQL Server stack in a professional environment o Python is highly desirable o Azure and Tableau o Configure and maintain various database systems
• Ability to extract data, perform various analyses, and translate findings into meaningful business recommendations
• Knowledge of policy development, load and demand forecasting, revenue requirements, rates or accounting, pricing, tariffs theory & practice, energy markets and customer data analysis
• Strong written and oral communications skills

• Team player, ability to prioritize, be nimble, and self-directed in a highly fluid and rapidly changing environment
• Knowledge of utility ratemaking design and/or energy program design
• Knowledge of electric utility generation and retail business structures
• Experience with utility load and financial forecasting methodologies
• Experience with the development, maintenance of a self-service data analytics platform to disseminate data-driven insights into the organization
• Knowledge of and experience with California Public Utilities Commission (CPUC) regulations for electric utilities and knowledge of utility ratemaking, tariffs, and contracts
• Passion for contributing to the success of community choice aggregation in California

Ability to:

• Have a strong work ethic, take initiative, and be comfortable working in a fast paced, start-up environment
• Demonstrate integrity, patience, tact, and courtesy at all times
• Enjoy engaging with passionate internal and external stakeholders
• Be detail-oriented with strong organizational and analytical skills
• Ensure projects and reports are completed in a timely and accurate manner
• Work independently with minimum supervision and as a team member
• Exercise good judgment in handling multiple priorities to meet deadlines and open-ended tasks
• Work accurately and swiftly under pressure
• Have a high tolerance for uncertainty and know how to bring things to resolution
• Work well on diverse teams

Other Qualifications

Analytical Thinking: Approaches a problem or situation by using a logical, systematic, sequential approach.

Collaboration: Develops networks and builds alliances; engages in cross-functional activities.

Communication Skills: Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and displays openness to other people's ideas and thoughts.

Fiscal Management: Demonstrates strong financial management skills and oversees complex energy procurement practices with large financial impacts for the organization. Complies with applicable laws and policies.

Leadership: Leads by example; demonstrates high ethical standards; remains visible and approachable and interacts with others on a regular basis; promotes a cooperative work environment, allowing others to learn from mistakes; provides motivational supports and direction.

Vision/Strategic Thinking: Supports, promotes, and ensures alignment with the organization’s vision and values; understands how an organization must change in light of internal and external trends and influences; builds a shared vision with others and influences others to translate vision to action.

PHYSICAL DEMANDS
Must possess mobility to work in a standard office setting and use standard office equipment, including a computer / laptop; to operate a motor vehicle and to visit various meeting sites in
Orange County for the conduct of the Authority’s business. This is primarily a sedentary office classification, although standing in and walking between work areas may be required. Finger dexterity is needed to access, enter, and retrieve information using a computer keyboard or calculator and to operate standard office equipment. Positions in this classification bend, stoop, kneel, reach, push, and pull drawers open and closed to retrieve and file information. Employees must possess the ability to lift, carry, push, and pull materials and objects up to 25 pounds.

ENVIRONMENTAL ELEMENTS
This is primarily a sedentary classification, and the employee works in an office environment with moderate noise levels, controlled temperature conditions, and no known direct exposure to hazardous physical substances. The employee interfaces with staff, management, other Authority’s representatives, and government officials, business representatives, and the general public in explaining the Authority’s programs and requesting and providing information.

COMPENSATION AND BENEFITS
The salary range for this position is $7,500 - $9,167 per month. The exact compensation package offered will be dependent on candidate experience.

OCPA offers a generous benefits package which includes:

• Individual, family, and domestic partner health insurance (medical, dental, vision)
• Life, short-term disability, and long-term disability insurance coverages
• Retirement with employer matching
• Paid-time-off (PTO) and holidays
• Health and wellness reimbursement benefit
• Technology stipend
• Flexible spending accounts (FSA) - health and dependent care
• Employee Assistance Program (EAP)

This is not a civil service position; however, some OCPA employees may be required to submit a Statement of Economic Interests form, also known as the Form 700.

Orange County Power Authority is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

Job Type: Full-time

Pay: $7,500.00 - $9,167.00 per month

Benefits:

• Dental insurance
• Health insurance
• Paid time off
• Retirement plan
• Vision insurance

Schedule:

• 8 hour shift

Education:

• Bachelor's (Preferred)

Work Location: One location