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 current 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.