Result of Service

Under the direct supervision of the Head, Enterprise Architecture and Business Intelligence Unit, and in close collaboration with the EBI team.

Work Location

Jordan or Syria or Lebanon

Expected duration

up to 11 months

Duties and Responsibilities

Under the direct supervision of the Head, Enterprise Architecture and Business Intelligence Unit, and in close collaboration with the EBI team, the selected Business Intelligence Specialist will be responsible for the following tasks: • Analyze business requirements, provide possible solutions, and develop data models accordingly. • Develop multi-dimensional models according to business requirements compatible with warehouse standards. • Design and develop OLAP Databases using SSAS database objects. • Develop ETL packages. • Design and develop reports, dashboards, and KPI scorecards using MS Power BI. • Configure and deploy ETLs and Cubes. • Create and maintain documentation that includes design, requirements, and user manuals. • Performs other duties as may be assigned by the supervisor.

Qualifications/special skills

ISP – Business Intelligence Specialist • Analyze business requirements, provide possible solutions, and develop data models accordingly. • Develop multi-dimensional models according to business requirements compatible with warehouse standards. • Design and develop OLAP Databases using SSAS database objects. • Develop ETL packages. • Design and develop reports, dashboards, and KPI scorecards using MS Power BI. • Configure and deploy ETLs and Cubes. • Create and maintain documentation that includes design, requirements, and user manuals. • Performs other duties as may be assigned by the supervisor. Academic Qualifications: • University degree from an accredited educational institution in Information Systems, Computer Science, Software Engineering, or a related field. • At least 4 years of progressive experience as a senior Business Intelligence developer or in a similar role, with a strong focus on SSAS, SSIS, ETLs, Cubes, Power BI, DAX, and MDX. • Proven experience in developing and maintaining reports and dashboards using Microsoft Power BI and connecting to OLAP cubes or any other data sources. • Experience in designing and creating cubes for complex business requirements. • Experience in writing DAX and MDX expressions for Microsoft Analysis Services. • Experience in Microsoft Business Intelligence Architecture. • Previous experience as an ETL developer with strong data architecture knowledge around data warehousing concepts. • Experience with SQL Server databases as developer. • Strong analytical and problem-solving skills, with the ability to understand complex business requirements and propose effective technical solutions. • Excellent teamwork and communication skills, with the ability to collaborate effectively with diverse stakeholders. • Fluency in written and spoken English is required. DELIVERABLES • Functional Dashboards that meet the specified requirements and design specifications. (25%) • Data warehouse dimensional Model that aligns with the analytical data requirements. (25%) • Deliver well-organized and documented source code for the application, adhering to coding standards and best practices. (20%) • Testing and Quality Assurance Reports: Conduct thorough testing of the application to identify and fix bugs, ensuring a high level of quality and reliability. (20%) • Deployment Package that includes all necessary files and configurations for deploying the application to a production environment. (10%) Competency: • Analytical Thinking • Problem Solving • Programming Skills • Teamwork and Collaboration & Communication Skills • Continuous Learning • Creativity and innovation Contract Conditions • The selected candidate will be based in UNRWA HQA/JFO Amman – Jordan or Syria Field Office or Lebanon Field Office depends on the shortlisting and candidate location. • The duration of the Contract is 11 months and possibility of extension subject to the availability of funds and continuing need and satisfactory performance. • The selected candidate will receive monthly payments equivalent to the UNRWA salary scale of Grade 14 step 1. • At least 4 years of progressive experience as a senior Business Intelligence developer or in a similar role, with a strong focus on SSAS, SSIS, ETLs, Cubes, Power BI, DAX, and MDX .• Proven experience in developing and maintaining reports and dashboards using Microsoft Power BI and connecting to OLAP cubes or any other data sources. • Experience in designing and creating cubes for complex business requirements. • Experience in writing DAX and MDX expressions for Microsoft Analysis Services. • Experience in Microsoft Business Intelligence Architecture. • Previous experience as an ETL developer with strong data architecture knowledge around data warehousing concepts. • Experience with SQL Server databases as developer.

Languages

● Fluent in spoken and written English. ● Fluency in spoken and written Arabic.

Additional Information

UNRWA Digital Impact, Technology, and Innovation Department (DITID) is seeking an experienced Business Intelligence Specialist with expertise in SSAS, SSIS, ETLs, OLAP Cubes, Power BI, DAX, and MDX to work on Business Intelligence solutions. The consultant will report to Head, Enterprise Architecture and Business Intelligence Unit (HQ-Amman).

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.