Senior Analytics Specialist – Power BI & Snowflake

Location:Noida

Experience:5+ Years

About the Role:

We are looking for a highly skilledSenior Analytics Specialistwith strong expertise inPower BI and Snowflaketo design scalable business intelligence solutions, build optimized data models, and develop high-performance dashboards.

The ideal candidate should have strong technical proficiency inSQL, DAX, data modeling, data warehousing, Snowflake, and cloud-based analytics, along with the ability to translate complex business requirements into effective technical solutions.

Key Responsibilities:

• Design and develop enterprise-grade dashboards and reports usingPower BI Desktop and Power BI Service.
• Build and optimize tabular data models, including relationships, hierarchies, calculated columns, and measures.
• Develop advancedDAXcalculations using functions such as CALCULATE, FILTER, ALL, and time-intelligence functions.
• Perform data transformation and cleansing usingPower Query/M language.
• Extract and integrate data fromSnowflakeusing native connectors and optimize query performance.
• Develop complex SQL queries using joins, CTEs, subqueries, window functions, and analytical functions.
• Design and implement data warehouse models includingStar Schema, Snowflake Schema, and SCD Type 1 & Type 2.
• Optimize Snowflake performance using clustering keys, query pruning, result caching, and appropriate virtual warehouse sizing.
• Implement incremental data loads andETL/ELT pipelines.
• Configure and managePower BI Gateway, scheduled refresh, and Row-Level Security (RLS).

Required Skills & Qualifications:

• 5+ years of experiencein Power BI and Analytics.
• Strong hands-on experience withPower BI, DAX, Power Query, SQL, and Snowflake.
• Advanced SQL knowledge, including CTEs, joins, subqueries, and window functions.
• Strong understanding ofdata modeling, data warehousing, ETL/ELT, OLAP, and OLTP.
• Experience with Snowflake performance optimization and query execution.
• Knowledge ofRLS, data masking, and role-based access control.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively with technical and non-technical stakeholders in anAgile/Scrum environment.

Good to Have:

• Experience withMicrosoft Fabric, Power Apps, Power Automate, and Dataverse.
• Power BI or Snowflake certification.
• Experience working with enterprise-scale analytics environments.
• Bachelor's/Master's degree inComputer Science, IT, or a related field.

If you have strong Power BI and Snowflake expertise and enjoy building scalable, high-performance analytics solutions, we encourage you to apply.

#ibexphtalentmobility

Work Location: Hybrid remote in Noida, Uttar Pradesh