Description
Job Summary:
A professional to write SQL scripts, translate business problems into analytical solutions, develop fraud indicators and automations, and support internal audits using Power BI.
Key Highlights:
1. Writing SQL scripts for data extraction and analysis (mandatory).
2. Developing fraud indicators and alert automation.
3. Supporting the execution and documentation of internal audits using Power BI.
* Writing data extraction/analysis scripts based on SQL language (mandatory);
* Strong ability to translate business problems into analytical solutions;
* Creating fraud indicators;
* Automating alerts from indicators for immediate action;
* Experience building corporate dashboards \- Power BI;
* Supporting execution of the Internal Audit Plan, aligned with the Organization’s strategic planning;
* Supporting follow-up of completed work;
* Supporting preparation of documentation for tests performed during audits, as well as audit recommendations and reports.
* Presenting and discussing audit findings with audited departments.
* Continuous interaction with Technology teams, Data technical teams, and Information Security teams to identify and map key risks and controls in audited processes
Requirements:
* Bachelor’s degree in Information Technology, Computer Science, Information Systems, Information Security, Computer Engineering, or related field;
* Proficiency and practical experience with SQL-based data analysis tools (mandatory), PYTHON and/or similar;
* Knowledge of Big Data tools (PySpark and Cloudera) is desirable;
* Advanced PL/SQL knowledge;
* Familiarity with metrics and dashboards in Power BI;
* Advanced proficiency in Microsoft Office suite;
* Experience with automation tools, e.g., “Power Automate”;
* Basic knowledge of various cloud platforms (Google Cloud, Oracle, Azure, etc.) is a plus;
* Understanding of data modeling for analytical solutions;
* Knowledge of defining architectures and security solutions for environments, systems, and applications is a plus;
* Postgraduate studies and/or specialization in Information Security, Networks, Databases, and/or Technology and Data Protection topics is a plus.