Specialist - data warehousing

Job OverviewThis 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.Why Join Milaha?By continuously challenging the status quo, Milaha today is a large, diversified holding company with core interests in maritime transport, logistics, port management, and offshore marine services.Milaha is a genuinely diverse company in respect of its offering portfolio and, most importantly, our dedicated colleagues. Although we come from different backgrounds and cultures, our values are what we have in common and keep us connected.Key Roles & ResponsibilitiesPlan, create, coordinate, and deploy data warehousesCreate best practices for data loading and extraction. Develop data architecture, data modeling, and ETFL mapping solutions within structured data warehouse environmentFacilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long‑term needs of business customersDesign and build cubes while performing custom scriptsDevelop and implement ETL routines according to the DWH design and architectureSupport the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouseMonitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as requiredLiaise extensively with external or internal customers, analyzing customers’ existing systems and business modelsDocument 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 resolutionDemonstrate 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 solutionAnalyse testing results to ensure the solution meets the needs of the businessMeet 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 solutionLiaise with other IT staff such as Technical Support and Application Service Delivery to produce new systemsConfigure users access rights to applications according to Milaha’s Policies and Procedures for Applications AccessConsolidate and optimize available data warehouse infrastructureConceive analytics and business intelligence platform architecture for clients, including internal and third‑party clientsDesign and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checkedDesign 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 dashboardCollaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilizationPerform the design and extension of data marts, meta data, and data modelsEnsure all data warehouse architecture codes are maintained in a version control system.Perform other job‑related duties as assignedQualificationsEducation & Professional Qualification:University degree in Statistics, Mathematics, Computer Science, Information Management, or a related field.Related Certifications is desirableProfessional 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 managementKnowledge of programming languages like SQL, Python, R, and Scala.Expertise with ETL tools such ODI or SSISExp