Power BI Data Warehouse Analyst

BIICS, Inc is looking to fill a Power
BI Data Warehouse Analyst position. The position is located in Tallahassee, Florida
and work is onsite. If you or someone in your network meet the
qualifications and are interested in the position, please contact us at the
link below.

Power BI Data Warehouse Analyst

The
Data Warehouse Analyst / Report Builder will develop
and optimize Power BI semantic models, dashboards, and analytical
reports integrated with Snowflake. Services include creating advanced DAX
calculations, writing and tuning complex SQL queries, and ensuring
Snowflake datasets are modeled and structured for reliable Power BI
consumption. The resource will work with data engineers to support dimensional
modeling, maintain metadata and data lineage documentation, and ensure accurate,
high-performance reporting. The Analyst will collaborate with stakeholders to
translate business needs into actionable reports, troubleshoot performance
issues across Power BI and Snowflake, and operate effectively in a
dynamic environment with minimal oversight. 

Responsibilities:

The
activities the candidates will be tasked with include, but are not limited to,
the following: 

• 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. 
  

Requirements

Potential candidate must possess the following:

• 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 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. 
  

Benefits