BI Data Analyst - Sandton, South Africa - Boardroom Appointments

Boardroom Appointments

Verified Company

Sandton, South Africa

1 week ago

Posted by:

Thabo Mthembu

beBee Recruiter

Minimum Requirements:

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