Consultant – Senior SQL Server Developer, Local (HQ Gaza);

IT & Telecom Information Management

Overview

Lead database development and data transformation projects

You have:

• A university degree or master's degree in information technology, information management, Information systems, computer science, computer engineering, Software engineering, Business Administration, or Management.
• A minimum of 4 years of experience with a bachelor's degree in Microsoft SQL.
• A minimum of 2 years of experience with a master's degree in Microsoft SQL.
• Previous experience as an ETL developer with strong data architecture knowledge around data warehousing.
• Experience with SQL Server databases as a developer.
• Strong complex SQL knowledge; able to write, read and diagnose non-performing complex SQL.
• Fluent in spoken and written English.
• Striving for results and managing multiple priorities on time.
• Strong analytical and problem-solving skills.
• Strong interpersonal and communication skills, both verbal and written.

Result of Service UNRWA is an equal opportunity employer and welcomes applications from both women and men. UNRWA encourages applications from qualified women. Only those applicants shortlisted for an interview will be contacted. UNRWA is a non-smoking environment.

Work Location Gaza

Duties and Responsibilities ¿ Provide support for existing dashboards and ETLs and apply changes if needed. ¿ Provide first-line support to active users of the current system and coordinate required changes with third parties ¿ Analyze new business requirements, provide possible solutions, and develop data models accordingly. ¿ Design and development of the Data warehouse dimensional model according to the provided business requirements ¿ Design and development for the OLAP Database using SSAS database objects. ¿ Oversee design and development for reports, dashboards, and KPI scorecards using MS Power BI. ¿ Build Analysis Services reporting models. ¿ Develop tabular and multidimensional models that are compatible with warehouse standards. ¿ Create technical documentation, training materials, and conduct training sessions when needed. ¿ Understand the business requirements and develop data models accordingly. ¿ Performs other related duties as required.

Qualifications/special skills Academic Qualifications:

¿ A university degree or master's degree from an accredited educational institution in information technology, information management, Information systems, computer science, computer engineering, Software engineering, Business Administration, Management, or other related disciplines;

Experience:

¿ A minimum of 4 years of experience for a bachelor's degree and a minimum of 2 years for a master's degree in Microsoft SQL. ¿ Bachelor’s Degree in Computer Science is highly desirable ¿ Previous experience as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models. ¿ Experience with SQL Server databases as developer. ¿ Strong complex SQL knowledge; able to write and read as well as diagnose non performing complex SQL. ¿ Knowledge of indexing and explain plans.

Competency:

¿ Applying technical expertise. ¿ Strong ability to drive for results, to manage and deliver against multiple priorities on time. ¿ Strong analytical and problem-solving skills. ¿ Strong interpersonal and communication skills; verbal and written. ¿ Excellent planning and organizing skills. ¿ Flexibility and adaptability.

Service conditions:

¿ The duration of the consultancy is 6 to 11 months, extendable according to performance and availability of funds. ¿ Remuneration for this consultancy will be $1.490.30 and depend on fund availability, qualifications, and relevant experience. ¿ The incumbent will be only in Gaza.

Languages ¿ Fluent in spoken and written English.

Additional Information UNRWA Information Management and Technology Department (IMTD) is seeking a Senior SQL Server Developer: to be responsible for automating data transformation using SQL server, designing the data acquisition, staging, loading, and transformation of data through ETL processes. This is an opportunity to make a significant impact and get lots of ownership. We are looking for someone who thrives in the ownership of the product and is self-driven.

¿ Please indicate if you are a Palestinian Refugee and provide your registration card number if applicable.

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.

Apply now

Potential interview questions

Added 3 years ago - Updated 1 year ago - Source: careers.un.org