Senior Analyst, Financial Planning & Reporting for Capital Projects

LUMA Energy; San Juan (PR); On-site; USD 90,000 - 130,000; Full time

Job summary

LUMA Energy is seeking a Senior Financial Analyst to prepare advanced financial analyses, portfolio insights, and performance reporting using Power BI, Power Apps, and Excel.

You will support budgeting, forecasting, KPI monitoring, and executive decision making while ensuring compliance with internal policies, data governance standards, and regulatory requirements. Collaboration across cross-functional teams is essential.

Qualifications

• Bachelor’s degree in Accounting, Finance, or related field; Master’s preferred.
• Experience in data analysis, reporting, and forecasting.
• Strong knowledge of Power BI, Power Apps, and advanced Excel.

Responsibilities

• Analyses financial reporting and performance, preparing management reports and assessments.
• Produces budgeting and forecasting insights, supporting annual plans and scenario analyses.
• Develops automated reporting tools and dashboards to enhance decision making and data accuracy across portfolios.
• Ensures data integrity by extracting, transforming, validating, reconciling, and documenting large datasets from Oracle EBS and other systems.

Skills

Power BI

Power Apps

Excel

Data analysis

Forecasting

Regulatory compliance

Cross-functional collaboration

Oracle EBS

Financial reporting

KPI monitoring

Education

Bachelor’s degree in Accounting/Finance/Business

Master’s degree preferred

Tools

Power BI

Power Apps

Power Automate

Excel

Oracle EBS

Job description

Job Summary

Prepares advanced financial analysis, portfolio insights, and performance reporting using Power BI, Power Apps, and advanced Excel to support budgeting, forecasting, KPI monitoring, and executive level decision making. Interprets complex financial and operational data to deliver actionable insights for senior leadership and cross functional partners while ensuring compliance with internal policies, data governance standards, and regulatory requirements.

Job Summary

Prepares advanced financial analysis, portfolio insights, and performance reporting using Power BI, Power Apps, and advanced Excel to support budgeting, forecasting, KPI monitoring, and executive level decision making. Interprets complex financial and operational data to deliver actionable insights for senior leadership and cross functional partners while ensuring compliance with internal policies, data governance standards, and regulatory requirements.

Job Description

• Analyzes financial reporting and performance by preparing accurate management reports, evaluating portfolio results, investigating variances, identifying trends, and highlighting risks and opportunities.
• Prepares budgeting and forecasting insights by supporting annual plans, reforecasts, financial modeling, scenario analysis, and monitoring actuals versus budget/forecast with timely stakeholder communication.
• Develops and compiles automated reporting tools, including advanced Excel models, Power Query, Power Pivot, and Power BI dashboards, to enhance visibility, decision‑making, and data accuracy across portfolios.
• Reviews and ensures data integrity by extracting, transforming, validating, reconciling, and documenting large datasets from Oracle, Asset Suite, and other internal systems while resolving data issues with IT/Finance.
• Corroborates cross‑functional metrics and reporting needs by partnering with Engineering, Operations, Finance Business Partners, Technology, and other teams to align definitions, governance standards, and regulatory or audit requirements.
• Provides strategic insights and communication through clear executive‑level presentations, interpreting financial and operational data into recommendations that support business strategy and continuous improvement.
• Documents and supports governance and operational excellence by contributing to regulatory reviews, process improvements, and business initiatives that strengthen reporting transparency and organizational alignment.
• Follows established company policies, procedures, and standards to ensure full compliance with applicable laws and industry regulations.
• Participates in storm restoration tasks and assigned drills to contribute to the safe and reliable recovery of services.
• Performs additional tasks aligned with role expectations and qualifications to support team goals and operational flexibility.

Education

• Bachelor’s degree in Accounting, Finance, Business Administration or related field.
• Master's degree preferred.

Experience

• 5 years’ experience in data analysis, reporting, process improvement, and business strategic support (interpreting key performance indicators (KPIs), metrics, forecasting, and statistical results) and other analytical functions, with demonstrated experience leading complex analytical projects or mentoring junior analysts.
• 6 years’ experience in financial analysis, accounting or related fields.
• Experience in Utility or regulated industry environment.
• Experience using business systems or analytic platforms required.
• Experience with Oracle EBS and capital project accounting.
• Advanced experience in Power BI, Power Apps, Power Automate, and Excel.

Additional experience may substitute for required education when it aligns with the competencies and knowledge necessary for the role:

• Associate’s degree in Accounting, Finance, Business Administration or related field may substitute when accompanied by a minimum of 7 years of experience performing similar functions and at least 5 years of experience performing a previous Analyst role.
• High School diploma or equivalent (GED) when accompanied by a minimum of 10 years of experience performing similar functions and at least 7 years of experience performing a previous Analyst role.

Competencies (Skills)

• Capital Project & Financial Expertise: Applies strong knowledge of capital project accounting, budgeting, forecasting, financial reporting, and Oracle EBS‑based project accounting.
• Analytical & Data Interpretation Skills: Performs complex calculations, reconciliations, and data assessments to interpret large data sets and convert them into actionable recommendations.
• Advanced Reporting & Visualization Tools: Builds data models and dashboards using advanced Excel and Power BI to support clear, accurate financial reporting.
• Communication & Cross‑Functional Influence: Communicates financial impacts clearly and collaborates effectively with non‑financial partners across diverse functions.
• Deadline & Volume Management: Manages high reporting volume and multiple deadlines within fast‑paced, recurring reporting cycles.

Preferred

• Certificate in Analytics, Automation, Power App, Power BI, BI Tools, KPI Reporting, Excel Advanced or Data Management.

Travel Requirements

• Not Required

Physical Demands

• Stationary Position: Constantly
• Pushing/ Pulling/ Reaching: Seldom
• Kneel: Seldom
• Grab: Seldom
• Bend: Seldom
• Lift/Carry over: 0 - 15 pounds

Working Conditions

• Wet or humid: Seldom
• Working near or on moving mechanical parts: Never
• Working near or on heavy machinery: Never
• Working in high places: Never
• Exposed to fumes or airborne particles: Never
• Frequency of working in outdoor weather conditions: Never
• Work with electricity: Never
• Loud noise conditions: Seldom

LUMA Energy is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, military status, disability, or any other characteristic protected by federal or local laws.