Job Opportunities in Egypt
September 19, 2024
Advansys
السادس من أكتوبر
Senior BI/DWH Extraction
- Design and develop BI (Business Intelligence) and DWH (Data Warehouse) extraction processes to gather, transform, and load data from various sources into the data warehouse environment.
- Collaborate with business stakeholders to understand reporting requirements and the necessary data to support business needs.
- Utilize ETL tools to build robust and efficient data pipelines that ensure data integrity and accuracy throughout the extraction process.
- Implement data quality checks and validation rules to maintain the high standard of data being processed.
- Conduct performance tuning of data extraction processes for optimal efficiency and speed.
- Create and maintain documentation for data extraction processes, including data flows and transformation logic.
- Participate in design and code reviews to ensure best practices are followed in BI/DWH development.
- Monitor and troubleshoot data extraction processes, resolving issues as they arise.
- Stay updated with new BI technologies, methodologies, and industry best practices to continuously improve the BI/DWH architecture.
- Bachelor's Degree in Computer Science, Information Systems, or a related field (a combination of education and experience will be considered).
- Minimum of 3 years of experience in BI/DWH extraction, ETL development, and data modeling.
- Strong hands-on experience with ETL tools like Informatica, Talend, or SSIS.
- Proficient in SQL and experience with relational databases such as Oracle, SQL Server, or My SQL.
- Knowledge of data warehousing concepts and practices, including dimensional modeling and star/snowflake schemas.
- Experience with data quality tools and practices.
- Strong analytical skills to evaluate data extraction impacts on performance.
- Excellent problem-solving skills and attention to detail.
- Good communication skills, capable of interacting with both technical and non-technical stakeholders.
- A team-oriented approach with the ability to work independently on projects.
Latest Job Opportunities
Similar Jobs
September 9, 2024
United Nations High Commissioner for Refugees (UNHCR)
Senior Registration Assistant
الإسكندرية
View Details
New Jobs from This Company