Specialist - Data Warehousing

**Description**

**Key Roles & Responsibilities**
- Plan, create, coordinate, and deploy data warehouses
- Create best practices for data loading and extraction. Develop data architecture, data modeling, and ETFL mapping solutions within structured data warehouse environment
- Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers
- Design and build cubes while performing custom scripts
- Develop and implement ETL routines according to the DWH design and architecture
- 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
- Monitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as required
- Liaise extensively with external or internal customers, analyzing customers’ existing systems and business models
- 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.
- Develop the processes necessary to efficiently operate the proposed solution including user guides, manuals, training materials and implementation and data conversion aids.
- Raising Service Requests with Application Support/SI for different issues and following up till resolution
- Analyse testing results to ensure the solution meets the needs of the business
- Meet regularly with internal team to update on work statuses and deliverable and discuss work progress and obstacles and enable thorough testing and successful implementation of the solution
- Liaise with other IT staff such as Technical Support and Application Service Delivery to produce new systems
- Consolidate and optimize available data warehouse infrastructure
- Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
- Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
- Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard
- Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
- Perform the design and extension of data marts, meta data, and data models
- Ensure all data warehouse architecture codes are maintained in a version control system.
- Perform other job-related duties as assigned

**Qualifications**

**Education & Professional Qualification**:
University degree in Statistics, Mathematics, Computer Science, Information Management, or a related field.
Related Certifications is desirable
**Professional Experience**:

- At least 8 years of relevant professional experience, which includes several or all the following areas: 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
- Knowledge of programming languages like SQL, Python, R, and Scala.
- Expertise with ETL tools such ODI or SSIS
- Expertise with Data Warehouse using Oracle or Microsoft DB
- Expertise in Data integration/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.

**Geographic Experience**:
N/A
**Computer Skills**:
Fluent with Microsoft Excel, Word, PowerPoint, and Outlook; experienced with MS Projects and SQL
**Language Skills**:
Business fluent English
**Market/Industry/Functional Knowledge**:

- Knowledge of Waterfall and Agile development methodologies
- Knowledge of software quality assurance and release management processes
- Uses solid analytical and problem solving skills, and is able to analyze current situations with new requirements to synthesize into creative solutions
- Should be able to work independently on defining solution for a midsize, complex projects or contribute to solution of a program.
- Should have depth and breadth of technical / functional/ domain know-how
- Familiar with Oracle Implementation Methodologies.
- Represents the practice/domain in deal with End Users, support cycle, or lead delivery issue resolutions when required.
- Ability to blend data from various data sources to produce actionable information.
- Strong data visualization skills for story-telling through data.
- 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