IT Data & Analytics Specialist/ Senior Specialist

Company: Abu Dhabi Islamic Bank – Egypt
Location: Cairo, Egypt
Employment Type: Full-time
Description:
Data Warehouse Related Responsibilities

Collaborate with cross-functional teams, including data engineers, business analysts, and data scientists, to understand data requirements and design optimal data warehouse solutions that align with business objectives.

Develop and implement end-to-end ETL (Extract, Transform, Load) processes to ingest, transform, and load data from various sources into the data warehouse. Utilize industry-leading ETL tools to automate and streamline these processes.

Design and maintain comprehensive data models, schemas, and structures that accommodate current and future data needs. Ensure data accuracy, integrity, and performance by implementing best practices in data modelling and management.

Monitor and maintain data quality within the data warehouse, proactively identifying and resolving data anomalies, inconsistencies, and errors. Implement data cleansing and transformation techniques to enhance data accuracy.

Collaborate with database administrators… to optimize query performance, identifying and resolving bottlenecks through query optimization, indexing strategies, and data partitioning.

Work closely with business analysts, data scientists, and other stakeholders to understand data consumption patterns and provide support for their analytical initiatives. Translate business requirements into effective data solutions.

Create and maintain comprehensive documentation for data warehouse processes, including data lineage, transformations, business rules, and metadata. Ensure knowledge sharing and continuity within the team.

Stay up-to-date with industry best practices, emerging technologies, and trends in data warehousing and analytics. Continuously evaluate and recommend new tools, techniques, and methodologies to enhance the data warehouse infrastructure.

Collaborate with IT security and compliance teams to ensure data security, privacy, and compliance with relevant regulations.

Process Governance

Document, and track, case histories, issues, and actionable steps taken

Improve documentation of data services policies and procedures related to hisher area.

Help in building system requirements and RFP for new solutions.

Build troubleshooting guides for SW systems in hand and perform on the job training for service desk teams to act as 1st line support and mentor Jr Application specialists

Recommend changes to policies, procedures, systems and products to add value to ADIB service offering.

Ensure keeping departmental procedures and documentation related to development and maintenance of all banking applications.

Follow up to get all documentation related to new applications/CR

Maintaining development releases and source backup.

Provide the direct manager with performance reports periodically.

Provide risk assessments in supporting new projects

Service Availability Management

Ensure systems availability, patching, performance, 2nd level support (24×7) and release management.

Ensure that support, resources and procedures are available and executed according to agreed service levels.

Participate in daily operations of the support team, manages key metrics, service delivery and is responsible for execution of tasks related to testing of any projects that support goals and address operational challenges.

Review Service Availability reports ensuring that KPIs are performed and agreed upon targets are met.

Participate in preparing and validate Bank Business Continuity and Disaster Recovery Plans.

Patching – Participate and ensure quality development of patches that are deployed to the production environment

And any other assigned tasks.

Minimum Qualifications (Specialist):
• Bachelor’s degree in Computer Science, Information Technology, or a related field;
• Proven experience as a Data Warehouse Specialist or similar role, with expertise in data warehousing concepts, methodologies, and best practices.
• Prior Experience in ETL tools such as Informatica, Talend, or Apache NiFi, and data integration techniques for handling structured and unstructured data is a plus.
• Experience with SQL and database systems such as SQL Server, Oracle, or PostgreSQL. Familiarity with NoSQL databases is advantageous.
• Prior experience with SAP Business Objects (BO) is a plus.
• Understanding of data modelling, dimensional modelling, and data normalization techniques.
• Excellent problem-solving skills and attention to detail, with the ability to analyse complex data challenges and devise effective solutions.
• Effective communication skills to collaborate with technical and non-technical stakeholders, translating technical concepts for a diverse audience.
• Experience with cloud-based data warehousing solutions (e.g., Amazon Redshift, Google BigQuery, Snowflake) and their associated services is a plus.
• Knowledge of programming languages such as Python, Java, or Scala for scripting and automation.
• Certifications in data warehousing technologies (e.g., AWS Certified Data Analytics, Google Cloud Professional Data Engineer) are advantageous.
• 0 – 3 years of experience.

Minimum Qualifications (Senior Specialist):
• Minimum 3 years of experience.
• Experience in banking/ bank applications is a plus.
• Prior Experience in ETL tools such as Informatica, Talend, or Apache NiFi, and data integration techniques for handling structured and unstructured data
• Bachelor’s degree in Computer Science, Information Technology, or a related field; Master’s degree is a plus.
• Prior experience with SAP Business Objects (BO) is a plus.

Proficiency in ETL tools such as Informatica, Talend, or Apache NiFi, and data integration techniques for handling structured and unstructured data.

Strong experience with SQL and database systems such as SQL Server, Oracle, or PostgreSQL. Familiarity with NoSQL databases is advantageous.

In-depth understanding of data modelling, dimensional modelling, and data normalization techniques.

Job specific Skills:
• Fair knowledge of building system interfaces and systems integration
• Fair knowledge of Banking systems
• Fair understanding of business cycles
• Enthusiastic and fast learner
• Ability to execute multiple projects and initiatives balancing department and organizational demands and resources.
• Delivery of timely and accurate information for decision making.
• Good presentation skills.
• Highly organized and detail oriented.
• Self-motivated and independent

Source: LinkedIn

——————————————————————————

Tadawul Academy (www.tadawul.academy) is the highest rated CISI training academy in the world. Over 7000 students are enrolled on our eLearning platform. Our portfolio of qualifications includes: CISI ICWIM (Int. Certificate in Wealth and Investment Management), CISI UAE Financial Rules and Regulations, CISI Risk in Financial Services, CISI IISI (Int. Introduction to Securities and Investment), CISI Corporate Finance Technical Foundations, CISI Combating Financial Crime, CISI Global Financial Compliance, etc.

×