Data warehouse and Modeling Expert

at  Giza Systems EG

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

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

Please refer the Job description for details