Consultant, Automation & Analytics

Posted 13 June 2022
Location Houston, United States of America
Job type Contract

Job Description

Consultant, Automation & Analytics

Location: Tulsa, OK or Houston, TX


As the Automation and Analytics Consultant, you will provide data analytics expertise by interpreting and transforming SAP-PRA (Production Revenue Accounting) data to assist Financial Services in reporting, analysis, decision making, and predictive modeling.

Your responsibilities may include:

  • Develop SQL code to retrieve large amounts of data from various databases (Teradata, Oracle, and Azure)

  • Build data visualizations and dashboards using Power BI and Spotfire

  • Analyze large amounts of SAP PRA data to generate effective solutions and make timely decisions

  • Effectively communicate with all levels of the organization

  • Collaborate with Finance and IT

  • Design and development of data integration solutions, data connections and interfaces

  • Troubleshoot support tickets for operational issues related to data analytics and reporting



    • Bachelor's degree or higher in Accounting, Business Admin/Mgmt, Finance, Information Technology, Data Science, other related technical discipline, or foreign equivalent

    • 5+ years of experience in the oil & gas industry

    • 3+ years of experience working in SAP Production Revenue Accounting (PRA)

    • Advanced knowledge of SAP Production Revenue Accounting (PRA) terminology, data, and tables

    • Intermediate proficiency in Data Analytics Tools


    • Expert knowledge of SAP Production Revenue Accounting (PRA) terminology, data, and tables

    • Comfortable querying and manipulating data using SQL

    • Knowledge of visualization techniques, dashboard design, and decision support tools

    • Data-driven mindset and a proven history of continuous self-development

    • Analytical/technical skills with a practical approach to problem solving

    • Ability to deliver with high quality projects, on time and according to expectations

    • Delivers positive results through realistic planning to accomplish goals

    • Takes ownership of actions and follows through on commitments by holding others accountable and standing up for what's right

    • Builds positive relationships based on trust and seeks collaboration across organizational boundaries to achieve goals

    • Drives thoughtful and pragmatic change, encourages innovative thinking and continuous improvement, and models adaptability through resourcefulness, flexibility, and positivity