Specialist - Data Warehousing

Role Overview

Specialist - Data Warehousing at Ejqa. This role focuses on designing, building, and maintaining data warehouse and business intelligence systems.

Role Purpose

Design, build, and maintain data warehouse (DWH) and business intelligence (BI) systems by developing data architecture, data models, and ETL processes to ensure efficient data integration, quality, and accessibility for analytics and reporting. The position requires gathering business requirements, translating them into technical solutions, and collaborating with stakeholders to deliver scalable and secure data solutions.

Key Responsibilities

Data Warehouse Architecture & Design

• Plan, create, coordinate, and deploy data warehouses.
• Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
• Design and build cubes while performing custom scripts.
• Perform the design and extension of data marts, metadata, and data models.
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
• Consolidate and optimize available data warehouse infrastructure.
• Ensure all data warehouse architecture codes are maintained in a version control system.

ETL Development & Implementation

• Develop and implement ETL routines according to the DWH design and architecture.
• Create best practices for data loading and extraction.
• Design and implement ETL procedures for intake of data from both internal and outside sources.
• Design and implement ETL processes and data architecture to ensure proper functioning of analytics lab, as well as client's or third-party's reporting environments and dashboard.
• Ensure data is verified and quality is checked.

Requirements & Stakeholder Management

• Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers.
• Liaise extensively with external or internal customers, analyzing customers' existing systems and business models.
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Ability to blend data from various data sources to produce actionable information.
• Document proposed changes to the requirements and solution to enable impact analysis and revised business case, specifications, budgets, timescales and plans to be prepared and authorized.

Testing, Validation & Implementation

• Support the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse.
• Demonstrate application functionality, solicit feedback and ensure that project sponsor requirements are met.
• Work with business and IT staff to enable thorough testing and successful implementation of the solution.
• Analyse testing results to ensure the solution meets the needs of the business.
• Raise Service Requests with Application Support/SI for different issues and follow up till resolution.

Performance Monitoring & Maintenance

• Monitor the DWH and BI systems performance and integrity.
• Provide corrective and preventative maintenance as required.

Documentation & Training

• Develop the processes necessary to efficiently operate the proposed solution including user guides, manuals, training materials and implementation and data conversion aids.

Operations & Coordination

• Meet regularly with internal team to update on work statuses and deliverable and discuss work progress and obstacles.
• Liaise with other IT staff such as Technical Support and Application Service Delivery to produce new systems.
• Configure users access rights to applications according to policies and procedures for applications access.
• Perform other job-related duties as assigned.

Qualifications & Experience

• University degree in Statistics, Mathematics, Computer Science, Information Management, or a related field.
• At least 8 years of relevant professional experience in data warehousing, ETL development, Business Intelligence, data analytics, data visualization and data communication.
• At least 5 years of experience performing data warehouse architecture development and management.
• Related certifications desirable.

Skills & Competencies

Technical Skills

• Knowledge of programming languages: SQL, Python, R, and Scala.
• Expertise with ETL tools such as ODI or SSIS.
• Expertise with Data Warehouse using Oracle or Microsoft DB.
• Expertise in Data integration and transformation using ODI or SSIS.
• Substantial hands-on experience working with at least two of the following software solutions: Oracle HCM Cloud Service, Oracle Financials Cloud Service, and Oracle EPM Cloud Service.
• Fluent with Microsoft Excel, Word, PowerPoint, and Outlook.
• Experienced with MS Projects and SQL.
• Familiar with Oracle Implementation Methodologies.

Professional & Analytical Skills

• Strong data visualization skills for story-telling through data.
• Solid analytical and problem-solving skills.
• Ability to analyze current situations with new requirements to synthesize into creative solutions.
• Ability to interpret and explain complex information to a range of audiences and build consensus among different stakeholders.
• Strong analytical skills and the ability to accurately reflect and translate business ideas into functional requirements.
• Ability to work independently on defining solutions for midsize, complex projects or contribute to solution of a program.
• Depth and breadth of technical, functional and domain knowledge.
• Ability to represent the practice or domain in deal with End Users, support cycle, or lead delivery issue resolutions when required.

Interpersonal & Organizational Skills

• Excellent communication and interpersonal skills.
• Ability to maintain effective partnerships and working relations in a multi-cultural environment with sensitivity and respect for diversity.
• Excellent organizational skills, with the ability to work within strict time constraints and to meet deadlines.
• High level of client-orientation, listening to and developing awareness for client needs with the ability to flexibly react to changing demands.
• Ability to provide direction and mentor less experienced teammates and business stakeholders.
• Competent user of Microsoft Office applications and the internet.
• Ability to quickly adapt to new software, applications, and systems.

Methodological Knowledge

• Knowledge of Waterfall and Agile development methodologies.
• Knowledge of software quality assurance and release management processes.

Additional Information

• Business fluent English language skills required.