Title:  Technical Specialist-BI

Area(s) of responsibility

Role : Power BI Lead

Experience 6 to 8 years of experience.

Responsibilities

----------------------------------------------------------------

•            Experience in data design with respect to dataset, and data visualization

•            Proficient at data visualization using Power BI

•            Implementation of Row Level Security by defining various constraints for each defined ROLE

•            Create data models on the backend- this includes doing data transformations, writing DAX scripts, choosing the best schema that suits the data etc

•            Must have hands on experience on SQL

•            Manage report security, folder security, database row level security, report schedules and distribution

•            Create and maintain Power Pivot models, datasets and dataflows using best practices

•            Hands on experience in creating calculated columns/ Measures using DAX

•            Excellent communication skills

Mandatory Skillset:

5+ years of Business Intelligence, Data Warehouse experience.

2+ years experience with data modeling with Power Query and Power Pivot

4+ years experience and a deep technical knowledge of Power BI Desktop / Pro / Premium

2+ years experience with advanced MDX and DAX expressions

Strong SQL development experience with the ability to write complex and nested SQL queries

Senior level skills in building Reports, Dashboards, Scorecards and Reports using Power BI