This role focuses on designing, building, and maintaining data warehouse (DWH) and business intelligence (BI) systems. It involves 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. Responsibilities also include monitoring system performance, troubleshooting issues, and maintaining data integrity.
Additionally, the role involves creating documentation, training materials, and best practices, supporting testing and implementation, and ensuring smooth operation of data platforms. Strong coordination with internal teams, IT support, and external clients is essential to continuously improve systems and meet business needs.
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 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.
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.
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 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.