Full Stack BI Developer MMH250304-3

GuardriskSandton, Gauteng, South Africa

30+ days ago

Job description

Design and develop ETL processes, data integration, data warehousing, performance tuning, data modelling, and business intelligence reporting modules to deliver high-quality Business Intelligence solutions.

Role Purpose

Requirements

Appropriate 3 / 4 year IT qualification
Relevant Microsoft certification within the Data Space
Exposure to the full BI development life cycle
At least 4 – 6 year experience in the BI / Data Engineering Data / Analytics Field
Experience managing Data Projects
Data Engineering Experience in Azure preferred
Azure Data Factory / Synapse Pipelines experience essential
The successful candidate should have experience with SSRS, SSIS and SSAS, SQL Server, Synapse Pipelines, Physical & Logical Database architecture knowledge.
Power BI required
Proficiency in SQL
Experience with Big Data and Data Science beneficial
Understanding of insurance / accounting principles will be highly beneficial
Knowledge of Data Transformation Services, File Transfer Protocol
Good understanding of Data Warehouse architectures and supporting areas (Data Transformation, Modelling and Reporting)
Intensive troubleshooting and problem-solving skills
Comfort with managing business stakeholders
Experience in developing business intelligence solutions in large or midsize companies
Development experience with the Microsoft BI stack (including SSIS, SSRS, SSAS, Data Management)
Experience using Power BI to analyze data and report conclusions

Duties & 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 summary-level reporting with functionality to drill down into details.

Develop BI solutions using SQL, ETL scripting with ADF / Synapse Pipelines, business intelligence tools, database programming, and reporting tools on the Microsoft BI Stack.

Integrate with diverse source systems, including in-house, vendor-based, on-premises, cloud-based, and Office 365 systems.

Collaborate with the DevOps team and participate in testing all database-related changes and application updates.

Handle day-to-day database development / administrative tasks, including the development of queries, views, and other database schema objects.

Maintain data model schema, hierarchy within the data warehouse, and reporting systems.

Apply database tuning techniques to improve the performance of current solutions.

Ensure business continuity documentation through Azure DevOps.

Enforce database security standards and ensure adherence by team members.

Review code implementations by the Data team.

Oversee the quality of BI solutions developed by team members.

Mentor junior and intermediate team members.

Drive the implementation of innovative and latest technology solutions related to the data space through collaboration with the Lead Developer and Enterprise Architecture team.

Utilize junior members in achieving large-scale project developments and implementations in consultation with the lead developer.

Additional Skills

Ability to manage multiple tasks simultaneously and react quickly to problems

Skill in translating concepts and directions into practical solutions

Proficiency in reporting and business intelligence solutions

Development experience with relational database structures, multi-dimensional databases, and data warehouse design architecture

Experience with mobile deployment of business intelligence (desired)

Ability to develop, maintain, review, and explain data models

Excellent verbal and written communication skills

Strong team player

Understanding of the financial services industry, especially insurance (desired)

Experience with dashboard design and delivery

#J-18808-Ljbffr

Create a job alert for this search

Bi Developer • Sandton, Gauteng, South Africa