Posted on :
3 Feb, 2022
3 Feb, 2022
Posting Country: Ghana
Date Posted: 27-Jan-2022
Full Time / Part Time: Full Time
Contract Type: Permanent
At Vodafone, we’re working hard to build a better future. A more connected, inclusive, and sustainable world. As a dynamic global community, it’s our human spirit, together with technology, that empowers us to achieve this.
Job Title: BI Data Warehouse Specialist
We challenge and innovate in order to connect people, businesses, and communities across the world. Delighting our customers and earning their loyalty drives us, and we experiment, learn fast and get it done, together.
With us, you can truly be yourself and belong, share inspiration, embrace new opportunities, thrive, and make a real difference.
The Data Warehouse Specialist is responsible for the daily performance, scalability, security and support of the BI Data Warehouse and will be involved in the design, planning and development of the Data Warehouse, as well as troubleshooting system issues. Sourcing for data and ensuring the completeness, accuracy and consistency of data in the data warehouse through daily Daily Dara Quality and completeness checks and resolve any data quality issues. Develop, manage, schedule, and document data warehouse operations and tasks, including archival, security, backup, and aggregate table creation. Provide guidance to database administrators, for troubleshooting escalated issues and support regular/emergency requests during production issues. Collaborate with data modeller, metadata specialist, business analysts and ETL team members to resolve complex data design issues/provide optimal solutions that meet business requirements/benefits system performance.
•Ensure the correctness and consistency of data in the data warehouse
•Perform Daily Dara Quality checks and resolve any data quality issues.
•Perform daily loading and completeness check of data into the Data Warehouse.
•Daily Monitoring of jobs and ensuring successful running of processes and procedures in the DWH.
•Liaising with the regulatory bodies and security agencies as well as third parties to deliver their data needs in accordance with the company policy.
•Develop deep knowledge and implement Data Warehouse Model changes in line with the BI Architecture.
•Champion continuous improvement and optimization of the Data Warehouse.
•Translate user data requirements into a logical database design.
•Creating databases and database objects such as the tables, tablespaces, synonyms, views, triggers, stored procedures, defaults, domains, and indexes. Maintain the tables as necessary for optimization.
•Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse
•Develop & manage deep engagement with relevant stakeholders
•Coach junior team members in relevant areas through deep knowledge in one or more technology areas.
Monitor and Diagnose
Automation and Robotics
Data Analytics and Insights
Professional / Technical Skills
Degree in Engineering / Computer Science
Excellent SQL skills & Good knowledge of relational and object database models.
More than 3 years’ work experience in a business and technology focused IT environment
Over 5 years’ experience in BI DWH and Architecture support.