BI Data Analyst

• 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