BI Data Analyst

Minimum Requirements:

• 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