Full Stack Data Warehouse Developer

Be Different SA (PTY) LTD; Johannesburg; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A prominent analytics firm in Johannesburg seeks a seasoned Data Analytics/Business Intelligence professional with over 6 years of IT experience. The ideal candidate should excel in managing data projects and demonstrate proficiency in SQL, Power BI, and the Microsoft BI stack. Responsibilities include developing BI solutions and mentoring team members. This role offers a chance to innovate and contribute to high-level data strategies within the organization.

Qualifications

• 6+ years’ experience in IT with 4+ years in Data Analytics/Business Intelligence.
• Experience managing Data Projects.
• Must have experience with mobile deployment of business intelligence.
• Understanding of the financial services industry desired, especially Insurance.

Responsibilities

• Participate in the analysis and design of enterprise reporting and analytics.
• Design and implement reporting and dashboard processes.
• Develop BI solutions using SQL and ETL scripting.
• Maintain data model schema and hierarchy within data warehouse.
• Mentor Junior and Intermediate team members.

Skills

Data Analytics

Business Intelligence

SQL

Power BI

Azure Data Factory

SSIS

SSAS

Education

3- or 4-year IT qualification in Software Development

Tools

Microsoft BI stack

SQL Server

Job description

In order to be considered the following is required:

• 3- or 4-year IT qualification in Software Development
• Relevant Microsoft certification in the data space
• 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
• Must have prior experience developing business intelligence solutions in large or midsize companies
• Must have experience in reporting and business intelligence solutions
• Must have development experience with relational database structures, multi-dimensional database, and data warehouse design architecture.
• Experience with mobile deployment of business intelligence desired
• Must have experience with SQL
• Must be able to develop, maintain, review and explain data models
• Understanding of the financial services industry desired, especially Insurance.
• Development experience with Microsoft BI stack (Including SSIS, SSRS, SSAS, Data Management)
• Experience with dashboard design and delivery
• Experience using Power BI to analyze data and report conclusions

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