Budget Analysis Associate II

Sempra • San Diego, CA

4d • Onsite

About The Position

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.

Requirements

• Typically requires a 4-year degree in a relevant field, or equivalent combination of relevant education and experience.
• Typically requires 2 years of related experience.
• Must reside in Southern California or be willing to relocate upon hire.
• 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.

Nice To Haves

• 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.
• 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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level