Talent Pool: Full Stack Data Warehouse Developer MMH251006-9

Guardrisk; Sandton; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Guardrisk is seeking a BI/Data Engineer to design and develop ETL, data integration, data warehouse and BI reporting solutions. You will mentor junior members, tune databases, and ensure standards are met while delivering high-quality analytics capabilities.

The role requires 6 years in IT with core BI/Data Analytics experience, plus Azure Data Factory/Synapse Pipelines, SSIS/SSAS, SQL Server and Power BI proficiency. Collaboration with DevOps and architecture teams is essential.

Qualifications

• Experience with BI development life cycle from design to deployment.
• 6 years in IT with 4 core experience in Data Analytics/BI or related.
• Azure Data Factory or Synapse Pipelines experience essential.
• Experience with SSIS, SSAS, and SQL Server required.
• Power BI skills required.

Responsibilities

• Participate in analysis, design, development, troubleshooting and support of analytics platform.
• Design and implement reporting, dashboards with drill-down capabilities.
• Develop BI solutions using SQL, ETL scripting with ADF/Synapse Pipelines and MS BI stack.
• Integrate with diverse source systems including On-prem, Cloud, and Office 365.
• Collaborate with DevOps on testing DB-related changes and updates.
• Handle day-to-day database development and admin tasks including queries and views.
• Maintain data model schema and data warehouse hierarchies.
• Apply database tuning to improve performance.
• Mentor junior/intermediate team members and coordinate team efforts.
• Drive new technology implementations in data space with EA team.

Skills

Power BI

Azure Data Factory

Synapse Pipelines

SQL Server

SSIS

SSAS

Data Modelling

ETL scripting

BI Development Life Cycle

Data Analytics

Education

3/4 year IT qualification in Software Development

Microsoft certification in the Data Space

Tools

SQL Server

SSIS

SSAS

Power BI

Azure Data Factory/Synapse

Job description

Role Purpose

you will be responsible for designing and developing ETL, data integration, data warehouse, performance tuning, Data Modelling and business intelligence reporting modules to deliver quality Business Intelligence solutions to the business while ensuring that quality and standards are realised and met by junior team members.

Requirements

• 3/4 year IT qualification in Software Development
• Relevant Microsoft certification in the Data Space

Experience

• Exposure to the full BI development life cycle.
• 6 years experience in the IT Field with 4 core experience in Data Analytics/Business Intelligence or related.
• Experience managing Data Projects.
• Azure Data Factory/Synapse Pipelines Experience Essential.
• The successful candidate should have experience with SSIS and SSAS, SQL Server
• Power BI required.

Duties and Responsibilities

• Participate in the analysis, design, development, troubleshooting and support of the enterprise reporting and analytics platform.
• Design, construct, test and implement reporting, visualization, and dashboard processes that present reporting at summary level with functionality to drill down into detail.
• Develop BI solutions using SQL, ETL scripting using ADF/Synapse Pipelines, business intelligence tools, database programming and reporting tools on the Microsoft BI Stack.
• Integrate with diverse source systems (including but not limited to: In-House, Vendor-based, On-prem and Cloud-based, and Office 365).
• Work with DevOps team and participate in testing of all database-related changes and application updates.
• Responsible for the day to day database development/administrative tasks which include the development of queries, views, and other database schema objects.
• Maintain data model schema, hierarchy within data warehouse, and reporting systems.
• Applying database tuning techniques to improve the performance of current solutions.
• Assist lead developer in Coordinate team efforts to achieve business objectives (Strategic and operational).
• Ensure business continuity documentation through Azure DevOps.
• Enforce database security standards and ensure adherence by junior team.
• Review code implementations by the Data team.
• Oversee quality of BI solutions by junior team members.
• Mentor Junior and Intermediate team members.
• Drive implementation of innovative and latest technology implementations relating to the Data space through the Lead Developer and Enterprise Architecture team.
• Utilize junior members in achieving large scale project developments and implementations in consultation with the lead developer.