Business Analyst

Celerity Consulting Group, LLC; Walnut Creek (CA); Remote; Full time

Job summary

An established industry player is seeking a skilled Business Analyst to join its dynamic team. In this role, you will leverage your analytical skills to manage data projects, develop complex SQL queries, and support operational analysis efforts. This remote position offers the chance to contribute to impactful projects within the utility sector, ensuring data integrity and providing actionable insights to drive business decisions. If you are detail-oriented, with a passion for data and problem-solving, this opportunity is perfect for you. Join a collaborative environment where your expertise will help shape strategic initiatives and optimize operations.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

Disability Insurance

401(k) plan + matching

Paid Time Off

Flexible Work Schedules

Employee Referral Program

Professional Development

Charitable Contribution Match

Qualifications

• 2+ years of experience in Business, IT, or Engineering fields.
• Proficient in SQL and Microsoft programs including Power BI and Excel.

Responsibilities

• Manage data projects and present data results effectively.
• Develop and maintain complex SQL queries for data analysis.

Skills

SQL

Data Analysis

Communication Skills

Analytical Skills

Problem-Solving

Education

Bachelor's degree in Business, Engineering, Computer Science, or Information Systems

Continuous education in IT and business-specific areas

Tools

Microsoft Power BI

Excel

DAX

Power Query

Job description

Celerity is looking for a Business Analyst to join our Northen California Utility team. This is a remote (work from home) eligible position.

As a Business Analyst you will facilitate projects by supporting the development of analytics, create and maintain operational reporting, and respond to data requests about program objectives. You will play a key role in extracting and analyzing data to support operational analysis efforts.

Key Responsibilities:

• Manage data management projects from initial request to presenting data results.
• Develop and maintain complex SQL queries and objects.
• Research and analyze data discrepancies, ad hoc requests, and propose solutions.
• Extract and transfer data from databases to various analysts to support operational analysis efforts.
• Support daily operations and production processes, monitoring data pipelines through BI reporting endpoints.
• Coordinate requirements and deliverables with senior team members.
• Provide timely and professional responses to business partners or user inquiries, escalating as necessary.
• Identify and solve current gaps in data requirements and ease of access to ensure fast and consistent responses to leadership inquiries.
• Contribute to business case development.
• Manage standard, routine data analysis projects with limited supervision to present data results within budget and on-time.
• Work with other Data Management Analysts to process data, analyze data, and report findings.
• Develop and communicate clear, concise, and actionable data analyses for clients.
• Analyze data using various statistical tools to develop ad hoc reports, statistics, trends, and profiles.
• Work closely with colleagues to understand technical needs. Understand how any disruptions will potentially change a project and affect the business. Communicate with team leads to ensure client satisfaction, and provide recommendations as needed.
• Develop, measure and report on various projects and providing strategic guidance to cross-functional project teams.
• Solve unique and complex problems, anticipate issues and develop innovative solutions. Present findings and recommendations to leaders and coworkers to gain agreement.
• Apply broad expertise and advanced knowledge to wide-ranging issues. Integrate industry knowledge related to data into everyday business practices and decision making.

Qualifications

• Bachelor's degree in Business, Engineering, Computer Science, or Information Systems, or equivalent work experience.
• 2 years of experience in similar or related job functions (Business, IT, or Engineering fields) that could be substituted by an advanced degree.
• Continuous education in IT and business-specific areas.
• Proficient in Microsoft programs including Power BI, DAX, SQL, Excel advance Power Query, Xlookup, pivot tables, as well as data Modeling and normalization.

Preferred Qualifications

• 4+ years of experience in similar or related job functions (Business or Information Technology)
• Detail-oriented, analytical, and strong communication skills.
• Knowledgeable about business requirements processes.
• General understanding of the utility business.

We are proud to offer a comprehensive health and welfare benefit package that includes:

• Medical Insurance
• Dental Insurance
• Vision Insurance

PEACE OF MIND

• Disability Insurance (STD/LTD)
• Flexible Spending Account
• Health Savings Account
• Basic Life/AD&D
• 401(k) plan + matching

WORK/LIFE BALANCE

• Paid Time Off
• Company Holidays
• Leave of Absence
• Flexible Work Schedules

ADDITIONAL PERKS

• Employee Referral Program
• Professional Development
• Charitable Contribution Match

Pay: $34 – $45/hour DOE and Education

More about us:
Celerity is an agile risk optimization company that helps public utility organizations convert complex data into precision, actionable intelligence to mitigate risk, optimize assets and maximize project results.

Blending extensive client experience with deep vendor-side acumen, Celerity data scientists orchestrate precision data analysis, strategic consulting, and project management services to solve complex energy challenges via acute listening, proactive thinking and relentless grit.

Based in Walnut Creek, CA with remote offices nationwide, Celerity energy engineers perform a critical, leadership role as strategic liaisons between data, assets and the teams that make projects happen in the field.

Applicants must be authorized to work for any US employer. We are unable to sponsor or take over sponsorship of an employment Visa at this time.