Data Warehouse and Modeling Expert

Job description / Role

Data Warehouse and Modeling Expert - KSA

Job Description
- Design, develop, and maintain scalable data warehouse solutions to support business intelligence and analytics.
- Develop and implement data models to ensure efficient data storage and retrieval.
- Optimize data warehouse performance and manage ETL processes for data integration.
- Collaborate with stakeholders to understand business requirements and translate them into data models and architecture.
- Ensure data accuracy, consistency, and quality across the data warehouse.
- Manage data migration and integration projects, including data cleansing and transformation.
- Develop and enforce best practices for data modeling, data governance, and data management.
- Monitor and troubleshoot data warehouse issues, providing effective solutions to maintain performance.
- Stay updated with industry trends and advancements in data warehousing and modeling technologies.
- Mentor and provide guidance to junior team members on data warehousing and modeling best practices.

Personal Skills
- Excellent communication skills
- Flexibility to work under pressure and in different environments.
- Problems solving skills.
- Leadership skills.
- Excellent organizational and administrative skills.

Technical Skills
- Data Warehousing: Expertise in designing, developing, and managing data warehouse solutions.
- Data Modeling: Advanced skills in creating and maintaining data models, including dimensional and normalized models.
- ETL Processes: Proficiency with ETL tools and processes for data integration and transformation.
- SQL and Database Management: Strong skills in SQL for querying and managing large-scale databases.
- Performance Optimization: Ability to optimize data warehouse performance and manage large data volumes.
- Data Integration: Experience with data integration techniques and tools for consolidating data from various sources.
- Data Governance: Knowledge of data governance frameworks, data quality, and compliance standards.
- Cloud Platforms: Familiarity with cloud-based data warehousing solutions such as AWS Redshift, Google BigQuery, or Snowflake.
- Data Migration: Skills in planning and executing data migration projects, including data cleansing and transformation.
- Analytical and Problem-Solving Skills: Strong analytical skills for troubleshooting data issues and implementing effective solutions.

About the Company

Giza Systems, a leading systems integrator in the MEA region, designs and deploys industry-specific technology solutions for asset-intensive industries such as the telecoms, utilities, oil and gas, hospitality and real estate among other market sectors. We help our clients streamline their operations and businesses through our portfolio of solutions, managed services, and consultancy practice. Our team of 1000 professionals are spread throughout the region with anchor offices in Cairo, Riyadh, Dubai, Doha, Nairobi, Dar-es-Salaam, Abuja, Kampala and New Jersey, allowing us to service an ever-increasing client base in over 40 countries.