Senior Data Warehouse Analyst / Power BI Report Developer

Private Label Staff•Tallahassee, FL

20h•Onsite

About The Position

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.

Requirements

Bachelor's degree in Computer Science, Information Systems, Business Intelligence, or a related field preferred. Equivalent professional experience may substitute for the education requirement.
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.
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.

Nice To Haves

Experience embedding Power BI reports into web or internal applications is preferred.
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.

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.