Data Architect | Power BI

Preferred: Trivandrum / Cochin
Other Locations: Chennai, Bangalore

Additional Comments

Over 10+ years of experience in developing BI applications using SQL Server, Salesforce (SF), GCP, PostgreSQL, BI stack, Power BI, and Tableau.

Strong practical understanding of data modeling concepts—both Dimensional (Star Schema, Snowflake Schema) and Relational, including Fact and Dimension tables.

Skilled in translating business requirements into detailed functional and non-functional specifications.

Capable of taking ownership of deliverables and effectively communicating with C-suite executives and stakeholders.

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

Proficient in building SSAS-based OLAP Cubes and writing complex DAX expressions.

Hands-on expertise with external tools such as Tabular Editor and DAX Studio.

Strong ability to customize and optimize stored procedures and backend queries for complex data extraction and business logic.

Practical experience with Incremental Refresh, Row-Level Security (RLS), Parameterization, Dataflows, and Gateways.

Proven experience in designing and developing BI solutions using SSRS and Power BI.

Skilled in optimizing Power BI reports using Mixed Mode and DirectQuery.

Skills

Power BI

Power Tools

Data Analysis

Microsoft Fabric