Senior Analytics Specialist - Power BI + Snowflake

Requirement :

We are looking for a highly skilled Senior Analytics Specialist with strong expertise in Power BI and Snowflake. The candidate will be responsible for designing scalable BI solutions, building optimized data models, and developing high-performance dashboards. The role requires deep technical proficiency in SQL, DAX, data warehousing, and cloud-based analytics.

Key Responsibilities

Design and develop enterprise-grade dashboards and reports using Power BI (Power BI Desktop & Service)

Build and optimize tabular data models, including relationships, hierarchies, calculated columns, and measures

Develop advanced DAX calculations (CALCULATE, FILTER, ALL, time intelligence functions, etc.)

Perform data transformation and cleansing using Power Query (M language)

Extract and integrate data from Snowflake using native connectors and optimize query performance

Write complex SQL queries, CTEs, window functions, and analytical queries in Snowflake

Design and implement data warehouse architectures (Star Schema, Snowflake Schema, SCD Type 1 & 2)

Optimize Snowflake performance using: clustering keys, query pruning, result caching, and virtual warehouse sizing

Implement incremental data loads and ETL/ELT pipelines

Configure and manage Power BI Gateways, scheduled refresh, and row-level security (RLS)

Perform performance tuning of reports (query folding, aggregations, minimizing cardinality)

Collaborate with data engineers and business teams to translate requirements into scalable solutions

Required Skills & Qualifications

5+ years of experience in Power BI and Analytics

Strong expertise in:

Power BI (DAX, data modeling, Power Query, report optimization)

Snowflake (architecture, performance tuning, data sharing, secure views)

Advanced SQL skills:

Joins, subqueries, CTEs, window functions (ROW_NUMBER, RANK, LEAD/LAG)

Experience in data modeling techniques:

Fact/Dimension tables

Slowly Changing Dimensions (SCD)

Strong understanding of:

ETL/ELT pipelines

Data warehousing concepts

OLAP vs OLTP systems

Experience with query optimization and execution plans

Knowledge of data security:

Row-Level Security (RLS)

Data masking

Role-based access

Nice to Have

Certifications:

Microsoft Power BI Certification

Snowflake Certification .