BI Data Analyst

Boardroom Appointments; Sandton; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A recruitment agency seeks an experienced BI Developer who will design, publish, and maintain Power BI data models while collaborating with teams to ensure integration of dashboards. The ideal candidate has at least 5 years of relevant work experience, must pass internal assessments, and provide references for previous BI projects. Responsibilities include applying DAX for data filtering and automating dashboard updates with relevant data. Additionally, skills in SQL and Power Query are highly beneficial.

Qualifications

• Min 5 years work experience in business intelligence roles.
• Pass internal assessments and tests.
• Provide references of prior BI work.

Responsibilities

• Design, publish and maintain Power BI data models.
• Merging/Joining Queries using M Language.
• Implementing measures in DAX to filter values.
• Setting up automated data refresh for dashboards.
• Translating business needs into technical specifications.

Skills

Power BI Power Query concepts

DAX

Data model relationships

SQL

AI builder experience

RPA experience

Job description

Qualifications

• Min 5 years work experience in this type of role
• Will have to pass internal assessments and tests
• References of prior BI work

Technical Skills

• Power BI Power Query concepts (query steps and M syntax, transforming data including pivoting, aggregating, and joins)
• DAX (knows basic functions offhand, understands concept of measures and behavior of aggregate calculations in context)
• Data model relationships including implications on visual filtering behavior and RLS
• Nice to have: MS Fabric features (e.g., Data warehouses, lake houses, data pipelines)
• Nice to have: AI builder experience
• Nice to have: RPA and/or software testing automation experience SQL
• Knowledge of basic SQL language and concepts including: SELECTs, JOINs, GROUP BYs, Views
• Nice to have: Stored procedures, basic database management

Responsibilities

• Design, publish and maintain Power BI data models with over 45 interrelated tables connected Implementing a data model that works seamlessly in Direct Query or Import mode
• Merging/Joining Queries (M Language) in order to filter useful data to make visuals on a high granular level
• Establishing dynamic table relations with desired Cross filtering directions.
• Implementing measures in DAX that filter out values from different tables to display calculations
• Visuals with Level Filters that maintain data consistency across interactive/dynamic pages
• Setup automated data refresh of dashboards to show the updated values from source data
• Slicer Selections and Syncing across report pages
• Translate business needs to technical specifications
• Creation of external facing live dashboards
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate dashboards Performs other duties as required