Requirement :

We are looking for a highly skilled Senior Analytics Specialist with solid 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)
Solid unders

📌 Senior Analytics Specialist Noida
🏢 Birch Tree Consulting
📍 Noida