Senior Data Analyst (Consulting firm) - Cairo - Back office for KSA 

• Job Code : CWDA/002
• Department/Division : Caseware Products and Data Analytics
• Reporting to :Consultancy Manager

Job Purpose

Aldar International for Governance Consultancy is seeking a highly motivated and detail-oriented Senior Data Analyst to develop data analytics scripts, automated analytics-applications, business intelligence dashboards and Continuous Control Monitoring solutions using Caseware IDEA.

Main Areas of Contribution and Responsibility

• Data Analysis & Reporting: Collect, analyze, and interpret large data sets to identify trends, patterns, and insights. Develop dynamic visualization dashboards using Power BI and other tools to effectively communicate findings to stakeholders.
• Scripts and Macros Development: Develop macros, scripts and automated apps using Visual Basic (VBA), IDEAscript, Power
• Query, Python, Power BI, and UiPath to automate data collection, analysis, and reporting processes.
• SQL Scripting: Write, maintain, and optimize SQL scripts to extract, manipulate, and analyze data from databases, ensuring data integrity and accessibility.
• Data Collection & Integration: Develop APIs to Integrate Caseware IDEA with a variety of data sources, including major ERP
• systems such as Oracle and SAP, ensuring accurate and timely availability of data.
• Developing Customized BI Dashboards: Work closely with cross-functional teams to understand their data needs and develop customized BI reports.
• Advanced Analytics & AI-GPT integration: Utilize advanced analytics and predictive models to interpret complex data sets.
• Integrate AI tools, including large language models like GPT, to enhance analytical accuracy and provide predictive insights that support strategic business decisions.
• Financial/Audit Expertise: Leverage business acumen and specialized knowledge in financial and audit information to enhance the relevance and impact of data analysis efforts.
• Continuous Learning: Stay abreast of emerging trends, tools, and technologies in the data analytics field, incorporating best practices and innovations into daily work to keep Aldar at the forefront of the industry.

Key Competencies

Behavioral Competencies, Attention to Detail, Analytical Thinking,  Communication,  Planning & Organizing, Problem Solving, Initiative, Learning Agility, Team Management,, Technical 

Competencies:

• Advanced SQL and Database Management, 
• Data Visualization, (Power BI),  
• Programming Languages (Python, Visual Basic- VBA, R)
• Data Structure and Algorithm
• RPA (UiPath)
• Project Management
• API Platforms
• Power Query
• Financial Analysis
• ERP Systems Integration (Oracle, SAP)
  
• AI Integration (Experience with GPT-API)
• Role Qualifications

Experience

• A minimum of 3 years of relevant experience.
• Strong understanding of databases and advanced proficiency in SQL.
• Strong proficiency in Visual Basic, Power Query and Power BI.
• Intermediate to Advanced knowledge in Python, R and UiPath.
• Demonstrated experience working with large data sets and using data visualization tools.
• Proven ability to develop automated solutions for data analysis and reporting.
• Experience in financial and audit data analysis is highly desirable.
• Extensive experience with data collection and integration from various ERP systems, including Oracle and SAP.
• Proven ability to integrate and apply AI and machine learning technologies in a business context.

Education

• Bachelors degree in data science, Computer Science, Information Technology, or a related field.
• Accreditations, Licensing, and Professional Certificates
• A Project Management/ Team Lead professional certificate is a plus.
• Advanced degree or certification in AI, Machine Learning, or related field is a plus. Previous Knowledge in Caseware Products is a plus
• Language and Computer Skills

Fluency in English

Advanced Microsoft Office and Database Management skills

Advanced Computer Skills

Key Interactions

Within : Consultancy Team,  IT Development Team,  Senior Quality Assurance , pecialist o Project Stakeholders,  Product/Project Manager(s)

Outside: Software Vendors Caseware ,  Clients On projects

More Vacancies on : https://www.careers-page.com/pillars