Business Intelligence Manager

7 days 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 Giza Systems EG Full time

    As a Business Intelligence Analyst, you will be Responsible for transforming raw data into actionable insights that enable critical decision making and leads to Positive Customer Experience, Business growth and efficiency improvement. Your Key Responsibilities will include: **Data Collection and Preparation**: *Gathering data from various sources (CRM,...


  • القاهرة, Egypt Giza Systems Full time

    The Role Job Description As a Business Intelligence Analyst, you will be Responsible for transforming raw data into actionable insights that enable critical decision making and leads to Positive Customer Experience, Business growth and efficiency improvement. Your Key Responsibilities will include: Data Collection and Preparation: - Gathering data from...


  • القاهرة, 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 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...

  • IT Business Analyst

    2 weeks ago


    القاهرة, 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. **Key Tasks and Responsibilities** The business Analyst will be...


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

    **Date posted**:Sep 3, 2024**City**:Cairo**Country/Region**:EG**Type of Contract**:Unlimited contract**Job Requisition ID**:6789Business Insights Manager - .- The Business Insights Manager is responsible for evolving our analytics model into a reliable and self-service framework. This role involves collaborating with departments to identify their needs,...


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

    **Votre rôle**: At the crossroads of the key issues for the success of the cloud (security and reliability), the Business Security Officer is involved in a wide variety of activities, for which the qualities of analysis and flexibility are essential. - Carry out expert assessment and consultancy work (risk analysis, pentesting, vulnerability audits,...


  • القاهرة, 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**: - Intervene in any escalated incident and outage providing clear actions for resolution on behalf of the incident management team in a timely manner. - Provide continuous guidance and knowledge transfer for team members - Analyze team's progress and spot any weak areas and accordingly design training for the team. - Perform ticket audit to...


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

    **Votre rôle**: - Working effectively with peers and leaders across the company and manages multiple functions/BUs/countries to ensure the selection process results in quality hires. Meeting regularly with leaders to understand growth plans and recommend effective and tailored recruiting strategies. - Uses data and metrics, and an understanding of the...

  • Marketing Offer

    3 weeks ago


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

    **Votre rôle**: You will be primarily responsible for designing, developing and managing the Business Talk product, in collaboration with other product managers. The strategic objective is to accompany our customers in their cloud transformation. You will contribute to rolling-out local voice services in additional geographies faster, and integrating our...


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

    **Votre rôle**: Project scope management: - Responsible for delivering the agreed outcomes required from the project. - Conduct stakeholder analysis, define and manage customer expectations both stated and un-stated. Project Time management: - Estimate times for all activities and prepare delivery schedule. - Control performance to meet the deadlines...


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

    **Votre rôle**: The Orange Business IT Service Desk will be supporting the int'l subsidaries/business partners/ B&D and OCD globally. They receive the requests through a web tool or by phone and try to solve them using the documentation available in the knowledgebase and their IT skills and knowledge, if not, it will be escalated to the next level of...

  • Senior Analyst

    2 weeks ago


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

    **Company Description** NIQ is the world’s leading consumer intelligence company, delivering the most complete understanding of consumer buying behavior and revealing new pathways to growth. In 2023, NIQ combined with GfK, bringing together the two industry leaders with unparalleled global reach. With a holistic retail read and the most comprehensive...


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

    **Votre rôle**: - Holds accountability for the Quality of solutions provided to Customer - Acts as the customers' primary point of contact and an escalation point - Has awareness of overall and service management profitability of their customers - Proactively identify existing Customer needs, and opportunities and grow the customer relation with Orange -...


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

    **Votre rôle**: - Holds accountability for the Quality of solutions provided to Customer - Acts as the customers' primary point of contact and an escalation point - Has awareness of overall and service management profitability of their customers - Proactively identify existing Customer needs, and opportunities and grow the customer relation with Orange -...


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

    **Votre rôle**: **Mission / Role purpose** Lead and manage projects for Orange Cloud for Business while developing, managing, and adhering to Project Management best practice & processes. Support the OCB Project management team in resolving issues on product or service delivery as part of their projects and programs to provide a smooth and reliable...


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

    **Votre rôle**: Orange Business' strategy of developing its activities in the field of integration applied to growing technological areas (Cybersecurity, Cloud, Connectivity, Data/IA) requires us to structure our approach to skills development in order to support and adapt the employability of our employees. Relying on a proven training structure, Orange...


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

    **Votre rôle**: **Leadership and Management**: - Team Development: Set team objectives, manage performance, facilitate training and development, oversee recruitment, and balance workloads to ensure high team efficiency. Ensure culture of resilience and continuous learning within the team, encouraging open communication and collaboration. - Empowerment**:...