Data warehouse and Modeling Expert - Giza Systems EG
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Description
Personal Skills
- Data Warehouse Development: Designing and implementing data storage solutions that integrate data from multiple sources. This often involves ETL (Extract Transform Load) processes to move data from source systems into the data warehouse.
- Data Modeling: Creating logical and physical data models that define how data is organized within the data warehouse. They develop both star and snowflake schemas depending on business needs ensuring models are optimized for querying and reporting.
- Performance Optimization: Ensuring that data retrieval is efficient and meets the performance requirements of the business by optimizing query execution indexing and partitioning strategies.
- Collaboration: Working closely with data analysts data scientists and business intelligence teams to understand reporting needs and translate them into technical specifications.
- Data Quality and Governance: Maintaining the quality consistency and accuracy of data stored in the warehouse by implementing data governance best practices.
- Tools and Technologies: Expertise in data warehousing tools like Amazon Redshift Snowflake Microsoft SQL Server and ETL tools like Informatica or Talend. Proficiency in SQL and sometimes Python or Java for handling data.
Technical Skills
Proficient in SQL and data modeling techniques.Experience with ETL processes and data integration.Strong knowledge of database management systems.Knowledge of big data frameworks (e.g. Hadoop Spark) is a plus.These engineers ensure that large volumes of data are processed efficiently for business intelligence and analytics purposes.
Job Details
Preferred Candidate
This job has been sourced from an external job board.
More jobs on
Employment Type
Full Time
