Data Warehouse Analyst

For one of my direct client we are looking for an experienced Data Warehouse Analyst / Power BI Report Builder to develop and optimize enterprise-level Power BI reports, dashboards, and semantic models integrated with Snowflake.

The ideal candidate will have strong hands-on experience with Power BI, advanced DAX, SQL, Snowflake, and dimensional data modeling, along with the ability to work closely with data engineering teams and business stakeholders.

Key Responsibilities:

• Design and develop Power BI dataflows, semantic models, dashboards, and analytical reports.
• Build advanced DAX measures and analytical calculations.
• Develop user-friendly, scalable, and high-performance Power BI reports and dashboards.
• Create and optimize complex SQL queries, including CTEs, window functions, and analytical queries.
• Integrate Power BI with Snowflake using appropriate connection modes.
• Work with data engineering teams to ensure fact and dimension tables are structured and optimized for Power BI consumption.
• Apply dimensional modeling and star schema principles to semantic model development.
• Troubleshoot performance issues across Power BI, DAX, SQL, and Snowflake.
• Support Snowflake performance tuning, compute optimization, clustering, and cost control.
• Maintain metadata, data lineage, report specifications, and documentation.
• Collaborate with business stakeholders and SMEs to translate business requirements into actionable reporting solutions.
• Support Power BI workspace management and performance optimization.
• Develop and maintain paginated reports using Power BI Report Builder.
• Work independently in a dynamic environment with minimal supervision.

Required Qualifications & Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
• 5+ years of IT experience working with business intelligence tools and systems.
• 3–5+ years of hands-on Power BI experience developing enterprise-level reports, dashboards, and data models.
• Strong experience with advanced DAX and Power BI semantic models.
• Advanced SQL skills, including CTEs, window functions, analytical queries, and query optimization.
• Strong understanding of star schema, dimensional modeling, and fact/dimension design.
• Hands-on experience with Snowflake, including performance tuning, compute optimization, clustering keys, and cost management.
• Understanding of Snowflake RBAC, roles, warehouse sizing, and data governance.
• Experience integrating Power BI with Snowflake.
• Experience with Power BI Report Builder and paginated reports.
• Strong understanding of Power Query and Power BI performance optimization.
• Experience with metadata management, data lineage, and technical documentation.
• Ability to translate business requirements into structured semantic models and effective reporting solutions.
• Strong communication, analytical, problem-solving, and stakeholder collaboration skills.

Preferred / Plus

• Experience embedding Power BI reports into web or internal applications.
• Knowledge of CI/CD for Power BI.
• Experience with version control for Power BI solutions.

Ideal Candidate

We are looking for someone who can work across the complete analytics lifecycle:

If you are a strong Power BI Developer / BI Developer / Data Warehouse Analyst with hands-on Snowflake experience and enjoy building enterprise reporting solutions, we would like to hear from you.