BI Data Modeller-Developer

InfyStrat Software Services; Johannesburg; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading software services company in Johannesburg is seeking a BI Data Modeller-Developer for a 1-year contract. The successful candidate will build and support Microsoft BI solutions, requiring 5+ years of BI experience and strong skills in SQL and Microsoft BI tools. Knowledge of Python and R is a plus. This role is fully onsite with an hourly rate of 400-450ZR.

Qualifications

• 5+ years Business Intelligence experience.
• 5+ years of database design or integration experience with SQL Server databases.

Responsibilities

• Build, implement, and support Microsoft BI solutions.
• Work through all stages of BI project work.
• Use Microsoft BI Azure Stack for implementation.

Skills

Relational Database and SQL Language

Power BI

Extraction, Transformation, and Loading (ETL)

Dimensional Modeling

SSAS Tabular Development

Education

Microsoft data management and analytics BI certification

Job description

Job title - BI Data Modeller-Developer

Job type - 1-year extended contract role, fully onsite

Salary budget 400-450ZR per hour

The Business Intelligence (BI) Data Modeller/Developer is responsible for building, implementing, and supporting Microsoft BI solutions. The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing, and deployment). The BI Analyst/Developer should have a firm grasp of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Azure Stack (Azure Data Factory, Synapse analytics, Gen2 data lake).

To qualify for the BI Analyst/Developer position position, the candidate should possess the following:

Technical Skills

The BI Analyst/Developer should understand and have expertise in the various technologies needed to implement Microsoft BI solutions. The developer must have experience with the Microsoft BI stack, and exposure to other technologies is a plus (Python, R).

Specific technical skills desired include:

• Relational Database and SQL Language
• Power BI, Power Pivot, M, T-SQL, PL SQL, DAX
• Extraction, Transformation, and Loading (ETL) (Azure Data Factory)
• Data Warehouse / Solution Design
• Dimensional Modeling (Kimball Methodology)
• SSAS Tabular Development (Microsoft SSAS and DAX, M)

Other Requirements

• 5+ years Business Intelligence experience
• 5+ years of database design or integration experience with SQL Server databases
• Microsoft data management and analytics BI certification, advantageous