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.

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.
Raise Service Requests with Application Support/SI for different issues and follow 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 deliverables 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

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 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.

#J-18808-Ljbffr

Specialist - Data Warehousing