Data and BI Manager - Sandton, South Africa - Just Gym

Just Gym

Verified Company

Sandton, South Africa

1 week ago

Posted by:

Thabo Mthembu

beBee Recruiter

Description

Overview

Reference
BIM-PF001

Salary
ZAR/month

Job Location:

South Africa
Johannesburg Metro
Sandton

Job Type
Permanent

Posted
Tuesday, May 30, 2023

Closing date
30 Jun :59

Overview

Planet Fitness continues its exciting growth trajectory, and this growth unlocks the need to place within the Digital Technology and Transformation Team a Big Data and BI Manager.

This role will focus on integrating various systems; building and maintaining Planet Fitness's big data warehouse; designing and creating master data records; designing and implementing intelligence reporting; and designing and maintaining Planet Fitness's data, system and integration architectures.

Seniority and Reporting Structure
This role is mid management role and will report into the Chief/Head of Digital Transformation. It will be responsible for leading a team.

Work Break Down Responsibilities
The incumbent will be responsible for the following job functions:

Systems Integration and Architecture (15%)
Designing (where applicable), maintaining and updating all system architectures
Designing, maintaining and proposing integration architectures and strategies
Designing, maintaining and proposing database and warehouse architectures and strategies
Database, Warehouse and Master Data Management (40%)
Designing, building and maintaining a Planet Fitness database warehouse
Designing, building and maintaining analytical services and cubes
Designing, building and maintaining a meta data layer/schema
Designing, building and maintaining lead and member master data records
Intelligence & Knowledge Reporting (15%)
Lead and manage analysts and report designers
Design and implement with the team dashboards, drillinto and various critical business reports
Formulate single views of multiple data sources and data feeds through intelligence and knowledge reports
Build loss prevention intelligence
Consolidate the plethora of digital sources i.e. Google Analytics, Facebook Analytics, Website clicks, etc to derive marketing intelligence and reporting
Project Management (20%)
Plan, scope and execute large transformational projects
Budget and cost large transformational projects
Deliver projects on time and in scope
Partner cross functionally to deliver successful projects
Vendor and Team Management (10%)
Manage and drive accountability with software, database and implementation partners/vendors
Lead the team to ensure delivery of all KPI's and planned results
Grow, nurture and develop talent by sharing knowledge, technical skill and expertise

Experience and Exposure
The following minimum experience and exposure is needed for this role:

Ten (10) years experience working with Extract, Transform and Load tools likes Microsoft's SSIS
Ten (10) years experience working with Analytical/Meta Data Schema's and Structures which must include Microsoft's SSAS
Ten (10) years experience working with (implementation and maintenance) Microsoft's SQL Server including warehousing
Experience integrating various datasources i.e. MySQL, XML files, Google BigQuery, Google Analytics, etc.
Experience and exposure with any of the following or all of the following products Tableau, Power BI, Microsstrategy and Qlik
Experience with market basket analysis, sales analysis, loss prevention, digital (world of social and clicks) reporting

Education