Budget Analysis Associate II

Sempra:

Where opportunity powers impact​ ​At Sempra, a better world begins with better energy—and with people who want to make a difference. That's why we're tackling the biggest challenges facing our industry while building ahigh‑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 bigger—helping shape a better energy future for all. Primary PurposeThis 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 an 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
• A financial forecast is an estimate of future financial outcomes for a company or project, usually applied in budgeting, capital budgeting and / or valuation. Depending on context the term may also refer to listed company (quarterly) earnings guidance. Financial Regulatory Reporting
• Financial reporting is a standard accounting practice that uses financial statements to disclose a company's financial information and performance over a particular period, usually on an annual or quarterly basis. Financial Modeling and Variance Analysis
• Designing mathematical models and analyzing data to estimate the financial performance and value of a company or investment, involves analyzing historical financial data, projecting future scenarios, and measuring the variance between projections and actual performance. 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
• Financial statements are 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