Full stack bi developer mmh250304-3 at Guardrisk – Sandton | Jobyssey

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

Explore more jobs