Power BI and SQL Developer - Lead

Over 8 + years of experience in developing BI applications utilizing SQL server/ SF/ GCP/ PostgreSQL, BI stack, Power BI, and Tableau.

Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.

Ability to translate the business requirements into workable functional and non-functional requirements.

Capable of taking ownership and communicating with C Suite executives & Stakeholders.

Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints, and Indexes using various DDL and DML commands.

Experienced in creating SSAS based OLAP Cubes and writing complex DAX.

Ability to work with external tools like Tabular Editor and DAX Studio.

Understand complex and customize Stored Procedures and Queries for implementing business logic and process in backend, for data extraction.

Hands on experience in Incremental refresh, RLS, Parameterization, Dataflows and Gateways.

Experience in Design, development of Business Intelligence Solutions using SSRS and Power BI.

Experience in optimization of PBI reports implementing Mixed and Direct Query modes.