Description

You design and develop enterprise-level Power BI semantic models, dashboards, and data flows while optimizing Snowflake data architectures for analytics.

This role is on-site.

Responsibilities

• Design and develop Power BI semantic models using dimensional modeling best practices (star schema, fact/dimension tables).
• Write and optimize complex SQL queries, including CTEs, window functions, and analytical queries for data retrieval and transformation.
• Develop advanced DAX measures and Power Query logic to build intuitive, high-performance reports and paginated outputs.
• Integrate Power BI with Snowflake, managing connection modes, query folding, and data reliability.
• Troubleshoot performance issues across Power BI, DAX, SQL, and Snowflake compute layers while maintaining data lineage and metadata documentation.

Required Skills

• 5+ years of IT experience with Business Intelligence tools and systems.
• 3–5 years of hands-on Power BI experience, including semantic models, DAX, Power Query, and Report Builder for paginated reports.
• Advanced SQL development skills, specifically CTEs, window functions, and query optimization.
• Hands-on Snowflake experience: performance tuning, clustering keys, compute/cost optimization, RBAC, and warehouse sizing.
• Strong understanding of dimensional modeling, star schema design, and fact/dimension modeling.
• Experience integrating Power BI with Snowflake and embedding reports in web-based applications.
• Bachelor's degree in Computer Science, Information Systems, or a related technical field (equivalent work experience accepted).

Preferred Skills

• Experience with CI/CD practices and version control for Power BI/BI solutions.
• Background supporting enterprise-scale analytics or government/public-sector reporting environments.

Key Skills

Education

Bachelor's degree