Internal Audit –Data Mining Analyst

Main Purpose Provides data mining skills and reporting capability to Puma Energy’s Internal Audit, and especially to Continuous Auditing, on all in-scope IT environments: currently Business Central / Excel Power Query, SQL, Alteryx, Tableau.

Key Responsibilities: Work closely with the Puma Energy Continuous Auditing Team Leader and with the global Internal Audit Manager to identify priorities and deliverables.

Gets familiar with the data structure of the relevant IT tools (e.g. SQL database for TMS, Databricks, Azure, Alteryx, Tableau) and keeps apprised of developments and updates.

Is able to establish, correct and update data extraction programs (including but not limited to Power Query / Alteryx) for Internal Audit use.

Validates with the Continuous Auditing Team Leader the proper design and functioning of data mining tools before they can be released to Production (for Internal Audit or for a wider audience).

Stays informed of new program releases to assure a consistent service ability: the main programs (e.g. updates to Navision, e-Puma initiative) and the associated data mining tools.

Maintain Internal Audit’s BI framework in order to provide Data Analytics and Business intelligence tools to the Internal Audit function.

When feasible and advisable, suggests data mining procedures or improvements to the Audit Dept. for continuous improvement purposes.

SKILLS & COMPETENCIES: 2 to 4 years of experience in Auditing, Data Analysis and Data Mining support.

Must have experience with SQL.

Must have experience with Python

Excellent Communication skills.

Alteryx experience in data mining programs would be a plus.

Knowledge and Skills: Data extraction and transformation capability for ERP systems. 

Capable of working and communicating in English (written and spoken).

Ability to work with limited supervision, addressing a pool of internal customers from varying cultural / language environments.

Experience in using data visualization products, data mining tools and technologies (e.g. Alteryx, Databricks, Python, Tableau, Power BI).

Reporting Structure: Reports to the Puma Energy Internal Audit Team Leader

Key relationships: Works with Puma Energy’s Internal Audit, with Navision experts and Tableau developers, and with TMS, Workday specialists.