Senior Data Warehouse Analyst / Power BI Report Developer

Location: Tallahassee, FL Work Arrangement: Onsite Industry: Information Technology / Business Intelligence

Position Overview

We are seeking an experienced Senior Data Warehouse Analyst / Power BI Report Developer to design, develop, and optimize enterprise-level business intelligence solutions using Microsoft Power BI and Snowflake.

This role will focus on developing high-performing Power BI semantic models, dashboards, analytical reports, and paginated reports while leveraging advanced DAX and SQL to deliver reliable, actionable insights. The ideal candidate will have a strong understanding of dimensional modeling, star schema design, Snowflake architecture, and Power BI performance optimization.

The Analyst will work closely with data engineers, business stakeholders, subject matter experts, and technical teams to translate business requirements into scalable reporting solutions. This position requires strong analytical and problem-solving skills, the ability to work independently, and the ability to manage multiple priorities in a dynamic environment.

Key Responsibilities

• Design and develop Power BI semantic models, dataflows, dashboards, and analytical reports using dimensional modeling and star schema best practices.

• Develop advanced DAX measures, calculations, and analytical logic to support enterprise reporting requirements.

• Build intuitive, user-friendly, and high-performance Power BI dashboards and reports.

• Develop and maintain paginated reports using Power BI Report Builder.

• Write, analyze, and optimize complex SQL queries, including CTEs, window functions, and analytical queries.

• Work with Snowflake datasets to optimize query performance, compute utilization, warehouse sizing, and overall cost efficiency.

• Collaborate with data engineers to ensure fact and dimension tables are properly structured and optimized for Power BI consumption.

• Integrate Power BI with Snowflake using appropriate connection modes and ensure reliable, efficient data retrieval.

• Troubleshoot and resolve performance issues across Power BI, DAX, SQL, and Snowflake.

• Maintain metadata, data lineage, report specifications, and technical documentation to support data governance and long-term maintainability.

• Support Power BI workspace management and reporting environments.

• Translate business requirements into structured semantic models and actionable reporting solutions.

• Collaborate with stakeholders to understand reporting needs and recommend effective BI solutions.

• Support the embedding of Power BI reports into web or internal applications.

• Work independently with minimal supervision while effectively managing priorities, deadlines, and deliverables.

• Contribute to continuous improvement of reporting processes, data models, and analytics solutions.

Required Qualifications

Education

• Bachelor's degree in Computer Science, Information Systems, Business Intelligence, or a related field preferred.

• Equivalent professional experience may substitute for the education requirement.

Experience

• 5+ years of IT experience working with business intelligence tools and systems.

• 3–5+ years of hands-on experience developing enterprise-level Power BI reports, dashboards, semantic models, and analytical solutions.

• Advanced experience with Microsoft Power BI, including:

• DAX

• Power Query

• Data modeling

• Semantic models

• Paginated reports

• Report Builder

• Performance tuning

• Workspace management

• Advanced SQL skills, including CTEs, window functions, analytical queries, and query optimization.

• Strong understanding of dimensional modeling, star schemas, and fact/dimension table design.

• Hands-on experience with Snowflake, including performance tuning, clustering, compute optimization, and cost management.

• Understanding of Snowflake RBAC, roles, warehouse sizing, and data governance.

• Experience integrating Power BI and Snowflake, including knowledge of connection modes and performance considerations.

• Experience with metadata management, data lineage, and technical documentation.

• Experience troubleshooting performance issues across Power BI and Snowflake environments.

• Experience embedding Power BI reports into web or internal applications is preferred.

Preferred Qualifications

• Experience with CI/CD processes for Power BI.

• Experience with version control and deployment processes for BI solutions.

• Experience working in enterprise or large-scale data warehouse environments.

• Experience collaborating with data engineers and business stakeholders on complex reporting initiatives.

Technical Skills

The successful candidate should have strong knowledge and experience in:

• Microsoft Power BI

• Power BI Report Builder

• DAX

• Power Query

• Power BI Semantic Models

• Snowflake

• Advanced SQL

• Dimensional Modeling

• Star Schema Design

• Fact and Dimension Modeling

• Dataflows

• Paginated Reports

• Data Lineage & Metadata Management

• Performance Optimization

• Data Governance

• RBAC / Security Concepts

• CI/CD and Version Control

Core Competencies

Analytical & Problem Solving

Ability to analyze complex technical and business problems, identify root causes, evaluate alternatives, and recommend effective solutions.

Communication

Ability to clearly communicate technical information to both technical and non-technical audiences through written documentation, presentations, meetings, and day-to-day collaboration.

Initiative & Independence

Ability to understand assignments, organize workloads, manage competing priorities, meet deadlines, and take initiative with minimal direction.

Customer Focus

Ability to understand stakeholder needs, provide effective solutions, resolve issues, and maintain a high level of customer service.

Collaboration

Ability to work effectively with data engineers, developers, subject matter experts, business stakeholders, and other members of the project team.

Adaptability

Ability to adjust to changing priorities, new technologies, evolving business requirements, and process improvements.

Decision Making

Uses sound judgment, critical thinking, and analysis to make informed technical and business decisions.

Leadership

Demonstrates the ability to influence, guide, and support team members while contributing to shared project goals.

Ideal Candidate

The ideal candidate is a hands-on Power BI and Snowflake expert who understands both the technical and business sides of analytics. They can take a business requirement, design the appropriate dimensional model, develop the semantic layer, write optimized SQL and DAX, and deliver a polished report or dashboard that performs well in an enterprise environment.

This individual should be comfortable working independently, collaborating with technical teams and stakeholders, troubleshooting complex performance issues, and delivering high-quality reporting solutions with minimal oversight.