Budget Analysis Associate II

Sempra: Where Opportunity Powers Impact

At Sempra, a better world begins with better energyand with people who want to make a difference. That's why we're tackling the biggest challenges facing our industry while building a high-performance culture where you can do your best work. Together, our teams support nearly 40 million consumers across the U.S., strengthening the communities we serve and creating impact that extends far beyond the workplace. Here, collaboration, inclusivity and shared purpose empowers you to grow your passion, build a rewarding career and contribute to something biggerhelping shape a better energy future for all.

Primary Purpose

This position contributes to effective financial planning by compiling and validating budget inputs and performing preliminary variance analysis. Enhances transparency and accuracy in departmental budgeting processes.

Duties and Responsibilities

• Supports budget, forecasting, and financial reporting activities across assigned functions, including related analysis, coordination, and process support.
• Applies and maintains financial structures, standards, and internal procedures to support data integrity, consistency, and effective budget administration.
• Supports audit, regulatory, and other compliance-related activities by researching data, preparing documentation, and assisting with reporting requirements.
• Understands how to collect, clean, visualize and analyze costs and expenditures to provide status, progress reports and variance analysis.
• Examines expenditure against budget for the various departments and determining patterns to elevate to senior team members.
• Compiles and reviews departmental budgets by gathering necessary financial data and organizing it in clear and intuitive budget templates.
• Creates and/or maintains new or existing dashboards and reports to track budget performance and financial metrics.
• Collaborates and coordinates with different departments to gather information required to prepare for budget review.
• Performs other duties as assigned.

Education

• Typically requires a 4-year degree in a relevant field, or equivalent combination of relevant education and experience.

Experience

• Typically requires 2 years of related experience.
• Understand and maintain knowledge of CPUC, utilities, and similar industry regulatory requirements is preferred.
• Working knowledge of Oracle Planning system, Hyperion Financial Management (HFM), Excel, and SmartView databases is preferred.
• Working knowledge of SAP Finance, SAP Business Warehouse (BW), SAP HANA, analytical reporting and automation tools such as Power BI, Alteryx, Power Automate, Co-pilot is preferred.
• Must reside in Southern California or be willing to relocate upon hire.

Skills and Abilities

Required:

• Budgetary Management - Estimates revenue and expenses over a specified future period of time, and re-evaluates these on a periodic basis.
• Financial Analysis - Analyzes the financial statements and data to provide insights about the financial performance and position of the organization over time.
• Financial Forecasting - An estimate of future financial outcomes for a company or project, usually applied in budgeting, capital budgeting and/or valuation.
• Financial Regulatory Reporting - A standard accounting practice that uses financial statements to disclose a company's financial information and performance over a particular period.
• Financial Modeling and Variance Analysis - Designing mathematical models and analyzing data to estimate the financial performance and value of a company or investment.
• Project Management - The process of leading the work of a team to achieve goals and meet success criteria at a specified time.
• Regulatory Compliance - Ensuring an organization's adherence to laws, regulations, guidelines and specifications relevant to its business processes.
• Financial Statements - Formal records of the financial activities and position of a business, person, or other entity.
• Technical Reporting - A form of subjective and formal report that presents the objectives, processes, and results of technical work.
• Data Analysis - Measuring and managing organization data, identifying methodological best practices and conducting statistical analyses.

Preferred:

• Customer Services & Communication Skills adapt communication style and content to diverse audiences, providing clear verbal and written communications. High quality and high-touch interaction.
• System Proficiency intermediate Excel capabilities, including complex Excel formulas, pivot tables, data lookup. Ability to quickly learn and navigate enterprise systems (e.g., SAP, Oracle), identify system or process gaps, and able to troubleshoot and/or partner with Financial Systems and Transformation team in troubleshooting and enhancing the systems.
• Documentation & Records Management Creating, distributing, using maintaining and disposition of recorded information maintained as evidence of business activities and transactions.