Power BI Data Warehouse Analyst

Business Intelligence & Informatics Consultant Services, Inc. (BIICS, Inc) | Full time

Tallahassee, United States

Business Intelligence & Informatics Consulting Services, Inc.(BIICS, Inc) is a business and information management solutions company serving clients in both the public and private sector. With access to new opportunities every day, BIICS, Inc is a premier source for placing highly-skilled individuals with the most sought-after career opportunities and salaries.

BIICS, Inc is looking to fill a PowerBI Data Warehouse Analyst position. The position is located in Tallahassee, Florida and work is onsite
.

Power BI Data Warehouse Analyst

The Data Warehouse Analyst / Report Builder will developandoptimize

Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creating advanced DAXcalculations, 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, andoperateeffectively in adynamic environment with minimal oversight.

Responsibilities:

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

• Designand develop
  
  Power BI dataflows and semantic models using dimensional modeling practices.
• Build advanced DAXmeasures 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 andoptimizecomplex 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 structuredandoptimizedfor Power BI consumption.
• Integrate Power BIwith Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
• Documentdatalineage, metadata, and report specifications to support maintainability,governance, and transparency across analytics assets.

Potential candidate must possess the following:

• Required minimum of 5years of IT work experience in business intelligence tools and systems.
• A minimum of 3 to 5 yearsof hands-on experience developing enterprise-level analytical reports,dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, andDAX.
• Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
• Strong understanding ofstar schema design and fact/dimension modeling.
• Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
• Familiarity with SnowflakeRBAC, 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 PowerBI 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.
• Skillin writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption.
• Skillin creating high-performance Power BI reports withclean DAX logic and intuitive visual design.
• Abilityto translate business requirements into structured semantic models and actionable reports.
• Abilityto troubleshoot performance issues across DAX, SQL,and Snowflake compute layers.
• Abilityto collaborate effectively with data engineers, SMEs,and stakeholders to deliver enterprise-ready reporting solutions.