Data Warehousing Specialist

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

• 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

• 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

• Configure users access rights to applications according to Milaha’s Policies and Procedures for Applications Access

• 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

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.

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 business ideas into functional requirements.

• Excellent communication and interpersonal skills and 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 (Word, Excel, Outlook, PowerPoint) and the internet, and the ability to quickly adapt to new software, applications, and systems.