Senior Data & BI Analyst - Power BI & Snowflake

Requirement/Must Have: • Bachelor’s degree in computer science, Information Systems, or other related fields, or equivalent work experience. • Required minimum of 5+ years of IT work experience in business intelligence tools and systems. • A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX. • Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization. • Strong understanding of star schema design and fact/dimension modeling. • Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control. • Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance. • Proficient in building Power BI semantic models with strong DAX and clean dimensional design. • Experience in integrating Power BI with Snowflake and connection modes. • Proficiency in Power BI Report Builder, workspace management, and performance optimization. • Experience with metadata management, data lineage, and documentation. • Experience embedding Power BI reports into web or internal applications. • Knowledge of CI/CD for Power BI and version control is a plus. Responsibilities: • Design and develop Power BI dataflows and semantic models using dimensional modeling practices. • Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting. • Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements. • Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting. • Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption. • Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability. • Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets. Skills: • Knowledge of dimensional modeling and star schema design for semantic model development. • Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query. • Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts. • Skill in building optimized, scalable Power BI semantic models using strong dimensional design. • Skill in writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption. • Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design. • Ability to translate business requirements into structured semantic models and actionable reports. • Ability to troubleshoot performance issues across DAX, SQL, and Snowflake compute layers. • Ability to collaborate effectively with data engineers, SMEs, and stakeholders to deliver enterprise-ready reporting solutions.