Business Intelligence Manager

4 weeks ago


القاهرة, Egypt Santechture Full time

**Company Description**

SANTECHTURE is a healthcare technology innovator based in Cairo, Egypt, focused on transforming Revenue Cycle Management in the Middle East, North Africa, and Asia through smart AI and cloud-based solutions. Established in 2019, SANTECHTURE operates across KSA, UAE, India, and Egypt, serving both public and private sector customers and helping them achieve RCM excellence.

**Role Summary**: Business Intelligence Manager will provide technical expertise to our data engineering practice, implement the roadmap for the Data Engineering practice, and deliver data products that will allow your business partners to make successful, timely, data-driven decisions. Will be responsible for building and maintaining data systems, constructing datasets that are easy to analyze, and supporting company requirements. They will implement methods to improve data reliability and quality. They combine basic information from different sources to create consistent and machine-readable formats. They also develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling

**Primary Responsibilities**:

- The primary objective is to create the data products and make sure they are delivered through reliable data pipelines.
- Design and develop database objects, tables, stored procedures, views, triggers, and SSIS packages.
- Analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
- Design a data pipeline and develop ETL processes to transform raw data, flat files, and xl spreadsheets into SQL Databases.
- Provide database support for developing and deploying database scripts in Development, Test, Pre-Production, and Production environments.
- Design and develop enterprise and departmental business intelligence and data warehousing solutions.
- Test programs or databases, correct errors, and make necessary modifications
- Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Develop methods for integrating different products, so they work properly together.
- Develop standards and guidelines to guide the use and acquisition of software and to protect changes to the database.
- Revise/write the company definition of data in the data dictionary.
- Train users and answer questions.
- Approve, schedule, plan, and supervise the installation and testing of new products and computer system improvements, such as installing new databases.
- Identify and evaluate industry trends in database systems to serve as a source of
- information and advice for upper management.

**Job Requirements**:

- **10+ years of experience in data management with 4+ years in a leadership role.**:

- **5+ years experience in SSIS, SSRS, SSAS.**:

- Experience coding complex stored procedures (using T-SQL).
- Experience with developing SSIS packages.
- Software engineering background specializing in big data.
- Work experience as a DevOps Engineer or similar software engineering role.
- Have exceptional SQL Server programming skills
- Advanced Business Intelligence experience
- Uses SQL Server Analysis Services to enhance existing or develop new OLAP cubes used in the EDW system.
- Extensive experience with reporting using Power BI.
- Performs ad-hoc analysis using a process-oriented approach using T-SQL query language within the database systems.
- Understands the concept of Data marts, Data warehouses, and Data lakes and has experience migrating legacy systems to data marts/warehouses/lakes.
- Uses other cloud technologies (e.g., understands the concept of Cloud services like Azure SQL server).
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.
- Excellent leadership and communication skills.
- Experience in mentoring other developers in terms of processes and practices.
- Good data modeling concepts.
- Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
- In-depth knowledge of standard concepts, practices, and procedures related to
- database management.
- Proven analytical problem-solving and debugging skills.
- Preferred knowledge of healthcare data and processes (USA and Australian standards).
- Knowledge of Python and R is a plus.
- Present extensive knowledge of database design and modeling.

Pay: E£1.00 - E£2.00 per month

Application Question(s):

- How many years work experience using SSIS?
- How many years work experience using SSRS?
- What is your expected salary in EGP?
- What is your notice period?



  • القاهرة, Egypt Souq.com for E-Commerce LLC Full time

    Amazon is a highly data driven company highly obsessive about metrics. BIE plays a crucial role, can build and analyze data systems, spot important business pattern, create metrics that measure success and develop ways to validate our findings. BIE will work closely with the ICQA, Learning and Finance departments to provide analytical support for the...


  • القاهرة, Egypt Money Fellows Full time

    **Are You Ready to Take the Lead in Data-Driven Insights?** At Money Fellows, we’re redefining the FinTech landscape, and we need a passionate and innovative **Senior Business Intelligence Engineer** to join our enthusiastic team! In this exciting role, you will: - **Transform Data into Stories**: Dive into data analysis to uncover trends and insights...


  • القاهرة, Egypt Souq.com for E-Commerce LLC Full time

    Amazon is a highly data driven company highly obsessive about metrics. BIE plays a crucial role, can build and analyze data systems, spot important business pattern, create metrics that measure success and develop ways to validate our findings. BIE will work closely with the ICQA, Learning and Finance departments to provide analytical support for the...

  • Security Intelligence

    4 weeks ago


    القاهرة, Egypt IBM Full time

    Introduction In this role, you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of...


  • القاهرة, Egypt Abbott Laboratories Full time

    **Job title** **Commercial Artificial Intelligence Engineer** **About Abbott** Abbott is a global healthcare leader, creating breakthrough science to improve people’s health. We’re always looking towards the future, anticipating changes in medical science and technology. We’re empowering smarter medical and economic decision making to help...


  • القاهرة, Egypt Orange Business Full time

    **Votre rôle**: Main activities Lead the relationship with existing and future partners (Voice, Data, Mobiles), in order to achieve the commercial objectives relating to the partners concerned with its two major components: Business development, Internal and external communication. Analyze technological and market trends and their impacts on the ranges...


  • القاهرة, Egypt Mastercard Full time

    **Our Purpose** - Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation,...


  • القاهرة, Egypt Teradata Full time

    Our Company At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The...

  • Market Intelligence

    1 week ago


    القاهرة, Egypt NielsenIQ Full time

    This position is both a developmental and client support role. Whilst the individual is developing their skills in Retail Market Research, Account Management, Product and Retailing Knowledge they will also support a commercial team, working across a range of clients. - Support a well-defined list of clients and retailers, as specified by the line manager -...


  • القاهرة, Egypt Orange Business Full time

    **Votre rôle**: The Orange Wholesale Division is the Orange Group division that brings together all wholesale sales and purchases of telecoms products, services and supplies for third-party operators and content providers in the French domestic market and internationally. Orange Wholesale also builds infrastructures for Orange Group networks, to develop new...


  • القاهرة, Egypt Santechture Full time

    **Role Summary**: Data Lead plays a crucial role in providing high-level creative vision for a suite of digital products. They will be responsible for building and maintaining data systems, constructing datasets that are easy to analyze, and supporting company requirements. They will implement methods to improve data reliability and quality. They combine...

  • Program Manager

    1 week ago


    القاهرة, Egypt Orange Business Full time

    **Votre rôle**: A Strategic Value Proposition (SVP) is a **critical growth area for Orange Business** where we can significantly accelerate enterprises digital transformation programs. We begin with building a **Digital Infrastructure**, which serving as the foundation, empowering customer transformations across the digital landscape. Then we focus on the...


  • القاهرة, Egypt NielsenIQ Full time

    The Market Intelligence Consultant position is both a developmental and client support role. Whilst the individual is developing their skills in Retail Market Research, Account Management, Product and Retailing Knowledge they will also support a commercial team, working across a range of clients. **RESPONSIBILITIES** - Support a well-defined list of clients...

  • Program Manager

    1 week ago


    القاهرة, Egypt Orange Business Full time

    **Votre rôle**: A Strategic Value Proposition (SVP) is a **critical growth area for Orange Business** where we can significantly accelerate enterprises digital transformation programs. We begin with building a **Digital Infrastructure**, which serving as the foundation, empowering customer transformations across the digital landscape. Then we focus on the...


  • القاهرة, Egypt Ethics HR Full time

    Lead the development and creation of strategic people plans for the allocated business areas to enable the delivery and implementation of business strategy. - Own and drive the implementation of the HR strategic initiatives, and cyclical HR initiatives, to enable the business to deliver their people plans across the business areas of accountability. -...


  • القاهرة, Egypt Orange Business Full time

    **Votre rôle**: The Orange Wholesale Division is the Orange Group division that brings together all wholesale sales and purchases of telecoms products, services and supplies for third-party operators and content providers in the French domestic market and internationally. Orange Wholesale also builds infrastructures for Orange Group networks, to develop new...


  • القاهرة, Egypt AXA Egypt Full time

    **Key Responsibilities**: - Lead the development and creation of strategic people plans for the allocated business areas to enable the delivery and implementation of business strategy. - Own and drive the implementation of the HR strategic initiatives, and cyclical HR initiative, to enable the business to deliver their people plans across the business areas...


  • القاهرة, Egypt LSEG (London Stock Exchange Group) Full time

    Are you a high-reaching sales professional eager to make a difference? London Stock Exchange Group (LSEG) is committed to creating an environment where varied perspectives thrive, and everyone feels empowered to achieve their full potential. Our Risk Intelligence Division is seeking a Sales Associate to drive growth and uncover new opportunities in untapped...


  • القاهرة, Egypt Orange Business Full time

    **Votre rôle**: **Job purpose** The CTIO department is in charge of decision-making information systems, serving Orange Business different line of businesses such as marketing, pre-sales, sales, production, after-sales services, and customer-service for both France and international domains. In this context, the **ServiceNow development Cairo Team** is a...


  • القاهرة, Egypt Orange Business Full time

    **Votre rôle**: In this compelling role you will be an integrated part of European Business Operation, and you will gain a wide range of interesting tasks providing our key stake holders an overall business view of our business in Europe and specific territories. **Revenue forecasting** Providing monthly input to forecasting exercise extracting data from...