MSBI + PowerBI Developer

General Skills

Good Interpersonal skill and ability to manage multiple tasks with enthusiasm.

Interact with clients to understand the requirements.

4 to 8 years of total IT experience, with min 3+ Power BI

Technical Skills

Understand business requirements in MSBI context and design data models to transform raw data into meaningful insights.

Awareness of star and snowflake schemas in DWH and DWH concepts

Should be familiar and experienced in T-SQL

Have good knowledge and experience in SSIS (ETL)

Creation of Dashboards & Visual Interactive Reports usingPower BI

Extensive experience in both Power BI Service & Power BI On-Premise environment

Create relationships between data sources and develop data models accordingly

Experience in implementing Tabular model implementation and row level data security.

Experience in writing and optimizing DAX queries.

Experience in Power Automate Flow

Performance tuning and optimization of Power BI reports

Good understanding of Data warehouse concepts.

Knowledge of Microsoft Azure analytics is a plus.

Good to have

Azure BI skills (ADF, ADB, Synapse)

Good UI/UX experience / knowledge

Knowledge in Tabular Models

Knowledge in Paginated Reports

General Skills

\u2219 Good Interpersonal skill and ability to manage multiple tasks with enthusiasm

\u2219 Interact with clients to understand the requirements

\u2219 Up to date knowledge about the best practices and advancements in Power BI

\u2219 Should have an analytical and problem solving mindset and approach

\u2219 6 to 10 years of total IT experience, with min 3+ years in Power BI

Technical Skills

\u2219 Understand business requirements in BI context and design data models to transform raw data into meaningful insights

\u2219 Good knowledge on all variants of Power BI (Power BI Embedded, Power BI Service, Power BI Report Server)

\u2219 Strong SQL skills and SQL Performance tuning

\u2219 Provide expertise in Data Modeling and Database Design and provide recommendations

\u2219 Make suggestions / best practices in implementing data models, ETL packages, OLAP cubes, and Reports

\u2219 Experience working with direct query and import mode

\u2219 Expertise in implementing static & dynamic Row level security

\u2219 Knowledge to integrate Power BI reports in external web applications

\u2219 Should have experience setting up data gateways & data preparation

\u2219 Creation of Dashboards & Visual Interactive Reports using Power BI

\u2219 Experience working with third party custom visuals like Zebra BI etc.

\u2219 Create relationships between data sources and develop data models accordingly

\u2219 Have good knowledge of the various DAX functions and ability to write complex DAX queries

\u2219 Awareness of star and snowflake schemas in DWH and DWH concepts

\u2219 Knowledge in Tabular Models

\u2219 Be familiar with creating TSQL objects, scripts, views, and stored procedure