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 detailoriented Senior Data Analyst to develop data analytics scripts automated analyticsapplications 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 crossfunctional teams to understand their data needs and develop customized BI reports.
- Advanced Analytics & AIGPT 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 GPTAPI)
- 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 :
Remote Work :
No