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

- Robust 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

📌 Senior Analytics Specialist - Power BI + Snowflake (Noida)
🏢 Birch Tree Consulting
📍 Noida