Madurai, Tamil Nadu

Job Summary

Key Responsibilities

Build robust semantic data models and implement star/snowflake schemas for optimal performance.

Excellent Data modeling capabilities in Power BI using star schema, power query, aggregated tables and converting 3NF tables to star schema tables.

Understanding of Warehouse Management Systems and ERP systems

Build Self Service Data models

Excellent SQL query writing skills and analyzing Snowflake Data.

Design, develop, and maintain Power BI dashboards , reports, and data visualizations.

Create complex DAX calculations , measures, and KPIs.

Develop and optimize SQL queries , stored procedures, and views to support BI reporting.

Collaborate with data engineers to integrate and model data in Snowflake .

Ensure data quality , model integrity, and adherence to BI governance standards.

Optimize Power BI datasets for performance, refresh cycles, and scalability.

Translate business requirements into technical BI solutions.

Required Skills & Qualifications

6+ years of experience in BI development,



with at least 4 years in Power BI .

Expert-level knowledge of:
Power BI Desktop (DAX, Power Query, M script)

Data modeling & star schema design

SQL (complex joins, CTEs, window functions, performance tuning)

Snowflake (data warehousing, data sharing, schema design)

Strong understanding of ETL/ELT processes and data pipelines.

Experience working with large and complex datasets.

Ability to translate business requirements into technical solutions.

Robust analytical and problem-solving skills.

Excellent communication and stakeholder management skills.

Preferred Qualifications

Experience with Power BI Service , gateways, Row-Level Security (RLS).

Knowledge of Snowflake , Complex query writing , or other cloud integration tools.

Background in Agile/Scrum methodologies.

Relevant certifications (e.g., Microsoft Power BI Data Analyst Associate ).

The Technical Lead for Microsoft PowerBI and SQL will be responsib

📌 Microsoft Power BI Technical Lead (Madurai)
🏢 HCLTech
📍 Madurai