Uhi - Business Intelligence and Automation

The Business Intelligence and Automation Specialist will play a key role in supporting the business needs by creating and managing reports, building automation solutions, and ensuring seamless integration with MySQL, PowerBI, and Microsoft Power Platform. They will act as a bridge between the technical team and business units, analysing and optimizing existing reporting and automation processes.

As a critical role, the Business Intelligence and Automation Specialist will assist the SVP Commercial and Technology in managing the development and maintenance of all reporting and automation solutions, including but not limited to PowerBI reports, Power Apps, and Power Automate workflows, and keep track of the progress.

**J**ob Title**:Business Intelligence and Automation Specialist

**Department**:Commercial

**Location (primary)**:Cairo

**Key Responsibilities**:
The Business Intelligence and Automation Specialist will be responsible for managing the creation and maintenance of reports, building automation solutions, and ensuring seamless integration with MySQL, PowerBI, and Microsoft Power Platform. Additionally, they will act as a bridge between the technical team and business units, analyzing and optimizing existing reporting and automation processes. The key responsibilities of the Business Intelligence and Automation Specialist are outlined below:

- Report Design and Development: Manage the design, development, and maintenance of reports using PowerBI and other reporting Collaborate with business units to understand requirements, and take ownership of the report creation process, ensuring alignment with business goals.
- Automation & Integration Management: Act as the lead in building automation solutions using Microsoft Power Platform, including Power Apps and Power Automate. Liaise between the technical team and business, diagnose issues with existing automations, and propose relevant solutions. Work with cross
- functional teams to resolve complex issues.
- Database Management: Manage the utilization of Data for database management, ensuring data integrity and accuracy. Analyse and define the requirements, translate them into functional requirements for the development team, and own the implementation, providing ongoing support, testing, and troubleshooting.
- Improve Business Efficiency: Optimize the business processes through focused analysis and implementation of automation solutions to help UHI Review technical performance (including data accuracy, automation efficiency, and system integration), understand the opportunities, and propose relevant solutions.

**Key Measures**:

- Report Accuracy Metrics: Data Integrity, Error Rate, Alignment with Business Goals.
- Automation Efficiency Review: Execution Time, Error Rate, User Adoption.
- Database Management Metrics: Query Performance, Security Compliance, Data Integrity.
- Time to Implement Solutions: From Requirement Gathering to Deployment.
- Business Process Improvement Metrics: Efficiency Gains, Time Saved, Cost Reduction.

**Essential **Qualifications & Knowledge**:

- A proven track record of Business Intelligence, Automation, or other relevant experience in managing complex reporting and automation projects.
- Experience and strong knowledge of MySQL, PowerBI, Microsoft Power Platform (including Power Apps and Power Automate).
- 2+ years of experience in a related field or industry is a must.
- Technical background and knowledge of database management, reporting tools, and automation solutions are essential.
- Proficiency in the English language is a must, and knowledge of other Arabic is a plus.
- Experience in cross-functional collaboration and liaising with development teams.
- Strong technical skills to provide first-line support and training to end-users.
- Experience in conducting functional and technical testing of reports and automation solutions.

**Essential **Experience, Skills and Behavioural Requirements**:

- Analytical Skills: The ability to analyse complex data and translate it into actionable insights is crucial for this role as it involves creating and managing reports that drive business decisions.