Job Family: Finance/Controllers
Description
• Perform advanced or complex Data Analysis to support Project Accounting and Invoice payment processing activities.
• Medium to Advanced Data Analytical Skills including proficiency with advanced Excel, Power BI etc. are required
Job Responsibilities
Lead efforts to execute and/or oversee the following activities:
• Establish and maintain database/Workbook for reviewing heavy data supporting voluminous reimbursable invoices across various data sources, to determine accurate payments to contractor
• Collate and Organize Data from multiple data sources and format them into data types usable on power BI or similar Data analytical took
• Maintain Power BI or similar data analytical tool in a consistent format that would allow additional data to be added, formatted and analyzed with increasing speed.
• Establish periodic Reports/Charts from database as required by Management
• Represents Company to contractor and/or JV/CoV personnel or internal/External Auditors
• Support Project Controller in other activities requiring data analysis as requested.
• Establish processes to ensure compliance with Contract terms and oversight of invoice verification processes associated with EPC and other project Contracts including analyzing & reporting variances associated with contract terms & payments
• Seek to Understand Business/Project Cost Drivers, Propose/Establish Reference Tables/analysis that could be used to better understand Cost drivers, enhance easy Comparison against Contract Rates/Contractor cost proposals etc.
*Position is primarily handson data analysis
*Medium to advanced data analytics capabilities
*Advanced Excel skills
*Power BI proficiency, especially in deployment
*Strong data cleaning, data formatting, and reporting skills
*Ability to perform critical analysis (strong analytical mindset)
*5-10 years of experience with data analytics tools, ideally Power BI
*Data analysis experience is more important than accounting experience
*EPC / project experience is a plus, but not required
*Background in the energy or utility industry not required
*80% Data Analysis, 20% Project Accounting
*This is a Data Analyst role, not a Finance Analyst role
*Power BI is the preferred tool (used more than Tableau in this role)
• Continuous improvement team
• Candidates having some energy background is preferred
• Looking for strong analytical skills
• Experience with ETRM systems (such as Endur)
• Work in the Power Platform suite (Power BI, Power Apps, Power Automate)
• Looking for a technical background (coding experience, familiar with SQL or other query languages)
• 5-7 years of relative industry experience (oil/gas or energy is preferred but not required)
• Worked on complex data projects
• Flexible on education as long as the experience is there
• Will pass over someone who has less than 3 years of experience
• Intermediate to advanced skills in Power Bi
Similar tools (i.e., Tableau) can be considered