Senior Bi/dwh Extraction

2 weeks ago


السادس من أكتوبر, Egypt Advansys Full time

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.

**Requirements**:

- 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 MySQL.
- 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.



  • السادس من أكتوبر, Egypt Advansys Full time

    Assisting in the design and development of Business Intelligence (BI) and Data Warehouse (DWH) extraction processes. - Collaborating with senior developers to understand data requirements and help create efficient data extraction workflows. - Performing data extraction from various sources and transforming it into a format suitable for reporting and...

  • Senior BI Developer

    4 weeks ago


    السادس من أكتوبر, Egypt Advansys Full time

    **Requirements**: - Lead the design, development, and optimization of advanced dashboards and reports using Power BI and Tableau. - Develop and manage scalable, efficient data pipelines and ETL processes. - Write and optimize complex SQL queries to extract and manipulate large datasets. - Collaborate with stakeholders to gather requirements, provide...

  • Junior BI Developer

    4 weeks ago


    السادس من أكتوبر, Egypt Advansys Full time

    **Requirements**: - Design, develop, and maintain dashboards and reports using Power BI and Tableau. - Write and optimize SQL queries to extract, transform, and load data from various sources. - Analyze complex datasets to identify trends and provide actionable insights. - Collaborate with stakeholders to gather requirements and ensure BI solutions meet...


  • السادس من أكتوبر, Egypt On-Hire Full time

    A leading company in the tires industry is seeking a dynamic Supply & Demand Planning Senior Lead to join their team and play a pivotal role in our supply chain strategy. This position demands a strategic thinker who can effectively analyze data, forecast demands, and develop planning processes that align with our business goals. As a Senior Lead, you will...

  • Senior Demand Planner

    2 weeks ago


    السادس من أكتوبر, Egypt Shift EV Full time

    Who we are: Shift EV is a fast-growing electric vehicle technology company, based in Cairo, Egypt. Our vision is to accelerate the adoption of electric vehicles in Egypt and the region by developing state-of-the-art electric drivetrain solutions. You will work with world-class technology veterans from MIT, the University of Grenoble, Intel, and Corning to...