Data Warehouse Specialist

***ICT Applications DWH Senior Specialist***

**ICT Department**

**Job Summary:**

We are seeking a highly skilled and experienced ICT Data Warehouse Senior Development Specialist to join our team. The candidate will be responsible for designing, developing, and maintaining our data warehouse systems, ensuring efficient data storage, retrieval, and analysis to support business intelligence and decision-making processes through reports developments.

**Key Responsibilities:**

- Design, develop, and maintain data warehouse solutions to meet business requirements.
- Collaborate with business analysts, data architects, and IT teams to understand data needs and deliver high-quality data solutions.
- Develop ETL (Extract, Transform, Load) processes to efficiently manage data from various sources.
- Optimize and tune data warehouse performance for efficient data retrieval and processing.
- Troubleshoot and resolve data-related issues and provide ongoing support for data warehouse operations.
- Create and maintain documentation for data warehouse processes, designs, and operations.
- Design, develop, and maintain reporting solutions using appropriate tools and technologies.
- Create and optimize complex SQL queries and stored procedures to support reporting needs.
- Develop interactive dashboards and reports using BI tools (e.g., Power BI, Oracle BIP).
- Ensure data accuracy and integrity in all reports and dashboards.
- Provide support and troubleshooting for reporting-related issues.
- Lead and mentor junior developers, providing technical guidance and support.

**Qualifications:**

- Bachelor's degree in Computer Science, Information Technology, or a related field. A Master's degree is a plus.
- At least 4 years of experience in data warehouse development and management.
- At least 4 years of experience in reports development and business intelligence.
- Proficiency in SQL and experience with data warehousing tools and technologies
- Experience with database management systems
- Strong understanding of ETL processes and tools
- Hands-on experience with BI and reporting tools (e.g., Power BI, BIP, BusinessObjects)
- Familiarity with data modeling concepts and techniques.
- Strong problem-solving skills and attention to detail.
- Ability to work independently and as part of a team.