Specialist - Data Warehousing
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
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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).