SQL & Reports Developer

7 days 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 PRR Recruitment Services Full time

    This company based in Sandton is looking for a a C#/SQL/JavaScript candidate. This candidate will be working on the Microsoft Dynamics side. Strong experience in Finances, SQL and Excel is needed. BSc Degree would be pref. Min of 3 years working experience is required. Send your CV to marinda@prrrecruitment.co.za 


  • 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

    5 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 PRR Recruitment Services Full time

    This software house based in Rivonia is looking for a System & SQL Administrator The ideal candidate will have a min of 3 years experience in: The ideal candidate will need to have the following skills and experience:Cloud Environments:???? Backups & Redundancy of cloud data o Ensurecontinuityofsolution o Continuous improvement???? Performance /...


  • 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 PPS Recruitment Full time

    Job SummaryWe are seeking a highly skilled Junior SQL Developer to join our team at PPS Recruitment. As a key member of our Application Support team, you will be responsible for providing dedicated support to our business by managing data and system exceptions on both a technical and business front.Main Responsibilities:Develop, test, and release business...


  • 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 PPS Recruitment Full time

    Reporting to Team Manager: Application Support, the role will be responsible to produce business intelligence solutions, with Self-Help BI being the focus.To design, develop, implement and optimize data-driven solutions as well as to support BI and Data solutions.Provide detailed accurate and timely reporting to facilitate fact-based decision making as well...


  • Sandton, South Africa Dimension Data Full time

    Job Summary:We are seeking a highly skilled and experienced Senior SQL Server Database Administrator to join our team at Dimension Data. As a key member of our Data Services Business Unit, you will be responsible for providing expert-level support and guidance to our clients in achieving their strategic objectives.Key Responsibilities:Provide database...


  • Sandton, South Africa vonq-organic Full time

    Job Title: Senior SQL Server Database AdministratorWe are seeking a highly skilled Senior SQL Server Database Administrator to join our team at vonq-organic. 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...


  • Sandton, South Africa Dimension Data Full time

    Job Title: Senior SQL Server Database AdministratorAt Dimension Data, we are seeking a highly skilled Senior SQL Server 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...


  • 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...

  • IT Developer

    6 days 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 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 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 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...