Job Opportunities in Egypt
September 13, 2024
Santechture
القاهرة
FULL TIME
Manager Data Engineering
Role Summary: A Manager of Data Engineering 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:
Pay: E£1.00 - E£2.00 per month
Application Question(s):
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 datawarehousing 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.
- 10+ years of experience in data management with 4+ years in a leadership role.
- 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 as follows:
- Advanced Business Intelligence experience
- BIML scripting, SSIS, SSRS, SSAS, Power BI
- Extensive experience with reporting using Power BI.
- Experience coding complex stored procedures (using T-SQL).
- Experience with developing SSIS packages.
- 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).
- Uses SQL Server Analysis Services to enhance existing or develop new OLAP cubes used in the EDW system.
- 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.
- Demonstrate experience with Microsoft data technologies.
- Show us your fluency in Java (Python is a plus).
- Impress us with your analytical and troubleshooting skills.
Pay: E£1.00 - E£2.00 per month
Application Question(s):
- What is your current salary in EGP?
- What is your expected salary in EGP?
- What is your notice period?
Latest Job Opportunities
Similar Jobs
September 7, 2024
Asia Petrochemical
Sales & Business Development Manager
الإسكندرية
FULL TIME
View Details