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

📌 Senior Analytics Specialist (Noida)
🏢 Birch Tree Consulting
📍 Noida