SQL & Reports Developer

SUMMARY:
Planet Fitness continues its exciting growth trajectory, and this growth unlocks the need to place w

POSITION INFO:

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 Fitness’s Data Science partner’s 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 spec’ed 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 Microsoft’s 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