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 Dev Ops 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.

Job Type: Full-time
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?