SQL & Reports Developer

Found in: Talent ZA 2A C2 - 2 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

  • SQL Developer

    Found in: Talent ZA 2A C2 - 5 days ago


    Sandton, South Africa Samaha Consulting Full time

    Required Minimum Education / Training- Grade 12- Microsoft SQL Server Certification or higher- Diploma or degree in line with job requirements will count highly in favor.Required Minimum Work Experience- 3 - 5 years SQL development experience Intermediate.- 5 - 8 years or more SQL development experience Senior- SQL Server 2008 2017 experience.- Experience...

  • SQL Developer

    Found in: Adzuna ZA B C2 - 5 days ago


    Sandton, South Africa Adzuna ZA B C2 Full time

    Required Minimum Education / Training- Grade 12- Microsoft SQL Server Certification or higher- Diploma or degree in line with job requirements will count highly in favor.Required Minimum Work Experience- 3 - 5 years SQL development experience Intermediate.- 5 - 8 years or more SQL development experience Senior- SQL Server 2008 2017 experience.- Experience in...

  • SQL Developer

    Found in: Whatjobs ZA C2 - 5 days ago


    Sandton, South Africa Samaha Consulting Full time

    Required Minimum Education / Training - Grade 12- Microsoft SQL Server Certification or higher- Diploma or degree in line with job requirements will count highly in favor.Required Minimum Work Experience - 3 - 5 years SQL development experience Intermediate.- 5 - 8 years or more SQL development experience Senior- SQL Server 2008 2017 experience.-...

  • C#, SQL JavaScript Developer

    Found in: Talent ZA C2 - 2 weeks ago


    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 

  • Senior Analyst

    1 day ago


    Sandton, South Africa Medipath Healthcare Recruitment Full time

    **11th January, 2023**: **Responsibilities** - Scoping / strategy sessions with the customer base / technical team and MIS to determine the longer term strategy and other complimentary platforms within the global corporation that fit the Enterprise Architecture. - Assist with technical guidance and on-the-job training of less experienced staff, and check...

  • Systems & SQL Administrator

    Found in: Talent ZA C2 - 2 weeks ago


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

  • Snr SQL Server Database Administrator

    Found in: Talent ZA C2 - 2 weeks ago


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

  • BI Developer

    Found in: Adzuna ZA B C2 - 1 week ago


    Sandton, South Africa Adzuna ZA B C2 Full time

    Minimum Requirement:Solid understanding of data warehousing concepts and the Kimball methodology.ETL processes, and BI best practices.Azure technologies (Data Factory, Data Fabric, Data Lake) Experience with designing and implementing scalable and reliable data solutions in Azure.Proficient in Microsoft SQL Server, SSIS, SSAS)Must be willing to work in the...

  • BI Developer

    Found in: Whatjobs ZA C2 - 5 days ago


    Sandton, South Africa Green Marble Recruitment Consultants Full time

    Minimum Requirement: Solid understanding of data warehousing concepts and the Kimball methodology. ETL processes, and BI best practices. Azure technologies (Data Factory, Data Fabric, Data Lake) Experience with designing and implementing scalable and reliable data solutions in Azure. Proficient in Microsoft SQL Server, SSIS, SSAS) Must be willing to work...

  • BI Developer

    Found in: Talent ZA 2A C2 - 1 week ago


    Sandton, South Africa Green Marble Recruitment Consultants Full time

    Minimum Requirement:Solid understanding of data warehousing concepts and the Kimball methodology.ETL processes, and BI best practices.Azure technologies (Data Factory, Data Fabric, Data Lake) Experience with designing and implementing scalable and reliable data solutions in Azure.Proficient in Microsoft SQL Server, SSIS, SSAS)Must be willing to work in the...


  • 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 Project Manager

    1 day ago


    Sandton, South Africa CA Global Headhunters Full time

    Our client, a diversified mining company, is seeking an IT Project Manager who will be responsible for analysing and interpreting large data sets, developing reports and visualizations, and providing insights to key stakeholders across the organization. **Responsibilities**: Collect and analyse large data sets to identify trends and patterns. Develop...

  • IT Project Manager

    1 day ago


    Sandton, South Africa CA Global Headhunters International Full time

    **Job Description**: Our client, a diversified mining company, is seeking an IT Project Manager who will be responsible for analysing and interpreting large data sets, developing reports and visualizations, and providing insights to key stakeholders across the organization. **Responsibilities**: - Collect and analyse large data sets to identify trends and...

  • Senior Developer-

    Found in: Talent ZA C2 - 2 weeks ago


    Sandton, South Africa Dimension Data Full time

    FunctieomschrijvingOur client requires a Senior Developer with Java, Go, JavaScript, HTML, CSS and C# .Net. SQL React, Angular and NodeJS are also required. ·      5+ Years of experience as a senior developer.·      Excellent knowledge of various programming languages. Requirements Develop, analyse and maintain web and user specific...

  • Business Intelligence Developer III

    Found in: beBee jobs ZA - 2 weeks ago


    Sandton, South Africa Capitec Bank Ltd Full time

    Purpose StatementTo design, develop and deploy reporting and analytical solutions to support and enhance business decisions through processing and converting data into actionable insights, delivered in report form, using the Capitec reporting and analytical tools (software) of choice. ExperienceMinimum:At least 6 years' experience implementing innovative BI...

  • Business Intelligence Developer III

    Found in: beBee S ZA - 2 weeks ago


    Sandton, South Africa Capitec Bank Ltd Full time

    Purpose Statement To design, develop and deploy reporting and analytical solutions to support and enhance business decisions through processing and converting data into actionable insights, delivered in report form, using the Capitec reporting and analytical tools (software) of choice. ExperienceMinimum: At least 6 years' experience implementing innovative...

  • Developer --- JHB Sandton

    Found in: Talent ZA 2A C2 - 2 weeks ago


    Sandton, South Africa Dynamic Outsourced Solutions Full time

    DUTIES:• Integrations (socket, restful, ISO, soap webservices)• Web Portal design and page structures.• PC Applications and Windows Services.• Mobile Applications a bonus• Software and code management. KNOWLEDGE OF THE FOLLOWING:• Visual studios a must with, Java and any other dev platform a bonus• SQL databases and T-SQL experience•...

  • Developer --- JHB Sandton

    Found in: Whatjobs ZA C2 - 5 days ago


    Sandton, South Africa Dynamic Outsourced Solutions Full time

    DUTIES: • Integrations (socket, restful, ISO, soap webservices) • Web Portal design and page structures. • PC Applications and Windows Services. • Mobile Applications a bonus • Software and code management. KNOWLEDGE OF THE FOLLOWING: • Visual studios a must with, Java and any other dev platform a bonus • SQL databases and T-SQL...

  • Senior IT Developer

    Found in: Talent ZA C2 - 1 week ago


    Sandton, South Africa Sanlam Full time

    Who are we? Sanlam Specialised Finance (SanFin) is responsible for creation of shared value for Sanlam, its shareholders, policy holders, and societies with in which it operates by managing financial risk, developing financial products, and balance sheet optimisation, pursuing investments and financing opportunities in assets, sectors, markets,...