Posted in

Business Analyst – Facility Planning

Business Analyst – Facility Planning

CompanyTC Energy
LocationHouston, TX, USA
Salary$Not Provided – $Not Provided
TypeFull-Time
DegreesBachelor’s
Experience LevelMid Level, Senior

Requirements

  • 4-year college degree
  • 2 – 5 years of relevant work experience
  • Strong verbal and written communication skills as this role interfaces with a variety of business groups within the company
  • Ability to work independently within the framework of a team-oriented environment
  • Advanced knowledge of MS Excel, Excel/VBA code and/or Python scripts to perform complex data analysis tasks
  • Must be competent with top-level objects in Microsoft Access such as: tables, queries, forms, reports, macros, and modules
  • Hands on experience with MS Access databases and writing SQL queries
  • Previous experience developing analytics tools with Power BI to create interactive data-rich dashboards

Responsibilities

  • Work within an integrated team to approve, track, and manage new capacity requests and contracts.
  • Help facilitate open season sales, including documenting of available pipeline capacity, timing and EBB postings.
  • Routinely update complex contract databases to manage and track all firm contractual obligations, by pipeline asset, and provide such information to the pertinent stakeholders.
  • Update and provide available capacity reports to a variety of teams.
  • Track project reservations and associated impacts to available system capacity.
  • Maintain, program, and innovate the functionality of current data analysis tools.
  • Compile reporting data to complete annual reports that are submitted to the FERC.
  • Coordinate and collaborate with various teams to provide complex data analysis on an ad hoc basis.

Preferred Qualifications

  • Knowledgeable on natural gas industry fundamentals
  • Intermediate to advanced knowledge of database management systems such as Microsoft SQL server management studio, Microsoft Power Automate, Power Apps and Forms