SQL & Reports Developer

4 weeks ago


Sandton, South Africa HR Genie Full time

Overview

Planet Fitness continues its exciting growth trajectory, and this growth unlocks the need to place within the Digital Technology and Transformation Team a SQL and Reports Developer. This role will focus on developing SQL Data Queries, Automation of SQL Queries using SSIS and developing SSRS Reports. It will also grow into a junior Power BI developer.

Seniority and Reporting Structure

This role is a junior to intermediate SQL and Reports developer and will report into the Big Data and BI Manager. It will also report into the Reporting Analyst when developing PowerBi reports and dashboards.

Work Break Down Responsibilities

The incumbent will be responsible for the following job functions:

  1. SQL Queries and Development (50%)
  • Develop SQL Queries as architected by the Big Data and BI Manager.
  • Automate SQL Queries using SSIS and ETL processes.
  • Maintain data structures, tables, indexing in line with MS SQL Warehouse best practices.
  • Build data integrations into Planet Fitnesss Data Science partners data layers
  1. Reports Development (25%)
  • Gather SSR Reporting needs from the Big Data and BI Manager and Reporting Analyst.
  • Build SSRS reports based on needs gathered.
  • Convert all traditional SQL Queries that produce Excel outputs into SSRS Reports.
  • Ensure POPIA compliance when producing SSRS reports.
  1. Power BI Dashboards (15%)
  • Develop PowerBI Dashboards that of a medium complexity as speced by the Reporting Analyst.
  • Develop knowledge and experience on the PowerBI platform.
  • Convert Flat file integrations into MetaData structures and architectures in PowerBI.
  1. Data Science and Project Management (10%)
  • Plan, scope and execute small to medium projects in line with the Big Data and BI Managers transformation agenda.
  • Partner cross functionally to deliver successful projects.
  • Research and develop Data Science best practices.
  • Research and propose scenario, statistical and best practice forecasting models.

Experience and Exposure

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

  1. Experience working with Extract, Transform and Load tools likes Microsofts SSIS.
  2. Experience working with Microsoft SQL Server and Microsoft SQL Server Warehousing.
  3. Experience using Structured Query Language.
  4. Experience developing Microsoft Reporting Services reports.
  5. Experience working with PowerBi and similar tool.

Education

  1. Degree or Diploma in Information Technology (Programming focus)
  2. Grade 12


  • Sandton, Gauteng, South Africa HR Genie Full time

    Job SummaryHR Genie is seeking a skilled SQL & Reports Developer to join our Digital Technology and Transformation Team. This role will focus on developing SQL data queries, automating SQL queries using SSIS, and creating SSRS reports. The ideal candidate will also have experience with Power BI and be able to develop junior-level dashboards.Key...


  • Sandton, South Africa HR Genie Full time

    Job Summary:Planet Fitness is seeking a skilled SQL and Reports Developer to join its Digital Technology and Transformation Team. This role involves developing SQL data queries, automating SQL queries using SSIS, and creating SSRS reports. The ideal candidate will also have experience with Power BI and be able to develop junior-level Power BI...


  • Sandton, South Africa HRInsync Full time

    **Database Administrator - Hybrid position** The Database Administrator will take ownership of the databases across Company’s Azure SQL Server and On-Premises SQL Server. Their primary responsibility is to ensure the optimal performance of all database tables, stored procedures, and views. This role involves identifying issues and making recommendations...

  • Senior SQL Server Dba

    6 months ago


    Sandton, South Africa Mgiba Communications Full time

    The SQL Database Administrator (DBA) is responsible for providing technical support for the MS SQL database environment including the overseeing the deployment and organization of databases, assessment and implementation of new technologies. Alexander Forbes relies on the DBA to ensure that on-line processing database systems offer the highest reliability,...


  • Sandton, South Africa Dimension Data Full time

    Job OverviewWe are seeking a highly skilled Senior Microsoft SQL Database Administrator to join our team at Dimension Data.About the RoleThis is an exciting opportunity for an experienced Senior Microsoft SQL Database Administrator to work with our clients and internal teams to deliver high-quality database solutions.Key Responsibilities:Database...


  • Sandton, South Africa Total IT Recruitment Full time

    Leading Software House is looking for a AZURE SQL Database Administrator who will take ownership of the databases and the primary responsibility is to ensure the optimal performance of all database tables, stored procedures, and views. This role involves identifying issues and making recommendations for infrastructure changes as needed. It is a **remote...


  • Sandton, South Africa Dimension Data Full time

    Functieomschrijving The Senior SQL Database Administrator will support the business in achieving its strategic objectives within the Data Services Business Unit.As a Senior SQL Database Administrator in the Business Unit team, you will be responsible for consulting with clients on complex information technology challenges.Microsoft SQL database administrator...


  • Sandton, South Africa Dimension Data Full time

    Job Title: Senior SQL Database AdministratorDimension Data is seeking a highly skilled Senior SQL Database Administrator to join our team. As a key member of our Data Services Business Unit, you will play a critical role in supporting our business objectives and delivering exceptional service to our clients.Key Responsibilities:Perform database...


  • Sandton, South Africa BAEC Specialists Full time

    Database Administrator Role• We are looking for a highly skilled Database Administrator to join our team at BAEC Specialists. The ideal candidate will have a strong background in database administration, particularly with SQL Server environments.• The successful candidate will be responsible for the administration of database systems, including...


  • Sandton, South Africa Ivanhoe Mines Full time

    **IVANHOE MINES is looking for a Sage Reporting Specialist** **Ivanhoe Mines is a leading Canadian mining company committed to becoming a global leader in the supply of critical resources required to transition our world to a low-carbon, renewable future. Ivanhoe is focused on developing and expanding its four principal mining and exploration projects in...


  • Sandton, South Africa Redefine Properties Limited Full time

    **Data Reporting Analyst** **Key Performance Areas (KPA’s)**: - Managing master data on Owners, Properties and Rentable Units, including creation, updates and reclassification thereof. - Collect and maintain accurate records of property related information including building plans and other supporting documents to ensure correct records of history are...

  • IT Developer

    4 weeks ago


    Sandton, South Africa FirstRand Bank Limited Full time

    Job SummaryWe are seeking a highly skilled IT Developer to join our team at FirstRand Bank Limited. The successful candidate will be responsible for developing innovative, reusable, and competitive solutions, as well as contributing to a collaborative developer community.Key ResponsibilitiesDevelop and maintain high-quality software applications using C#,...


  • Sandton, South Africa The Flying Locksmiths South Bend Full time

    South Africa: Sql Database Administrator (Dba) posted by IOCO iOCO is seeking a highly skilled and experienced Database Administrator (DBA) to join our dynamic team. The ideal candidate will have a minimum of 5 years of hands-on experience in a multi-tiered and multi-client environment, with a strong focus on SQL Server databases. This individual will be...


  • Sandton, South Africa Misr Technology Services Full time

    Job Overview The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication...


  • Sandton, South Africa Dimension Data Full time

    Job Title: Senior Business Intelligence DeveloperWe are seeking a highly skilled Senior Business Intelligence Developer to join our team at Dimension Data. As a key member of our business intelligence team, you will be responsible for designing, building, and deploying data warehouse solutions using Microsoft SQL Server Business Intelligence technologies.Key...

  • Power BI Developer

    4 months ago


    Sandton, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time

    We are seeking an experienced Power BI Developer to join our analytics team. The ideal candidate will have a strong background in data analytics and business intelligence, with specific experience in extracting data from an Oracle Data Warehouse and other sources. Additionally, exposure to MicroStrategy and Informatica will be highly valuable. You will be...

  • Power BI Developer

    4 months ago


    Sandton, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time

    We are seeking an experienced Power BI Developer to join our analytics team. The ideal candidate will have a strong background in data analytics and business intelligence, with specific experience in extracting data from an Oracle Data Warehouse and other sources. Additionally, exposure to MicroStrategy and Informatica will be highly valuable. You will be...

  • Power BI Developer

    1 month ago


    Sandton, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time

    Job Title: Power BI DeveloperWe are seeking a highly skilled Power BI Developer to join our analytics team at LINKFIELDS INNOVATIONS (PTY) LTD. The ideal candidate will have a strong background in data analytics and business intelligence, with specific experience in extracting data from an Oracle Data Warehouse and other sources.Key Responsibilities:Design,...


  • Sandton, South Africa Absa Bank Limited Full time

    Empowering Africa’s tomorrow, together one story at a time. - With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group. Job...

  • C# Developer

    3 months ago


    Sandton, South Africa Boardroom Appointments Full time

    C # Developer - Sandton  Minimum Requirements: Matric (Grade 12)B-Degree in Computer Science or related technical field3+ years experience working in, C#, Visual Studio .NET, BlazorHTML / JavaScript knowledge preferred3+ years experience using .NET technology stack such as (Web API, MVC, .net4.5, .NET core, WCF)Good understanding of design principles such...