Data Warehouse Analyst / Power BI Developer

Location: Tallahassee, FL (Onsite)
Job Type: Contract
Experience Level: Intermediate/Senior

Job Summary

We are seeking an experienced Data Warehouse Analyst / Power BI Developer to develop and optimize enterprise analytics solutions using Microsoft Power BI and Snowflake. This role involves building semantic models, dashboards, and analytical reports; developing advanced DAX and SQL; optimizing data warehouse performance; and collaborating with data engineers and business stakeholders to deliver reliable, scalable, and actionable business intelligence solutions.

Responsibilities

• Design and develop Power BI semantic models and dataflows using dimensional modeling and star schema principles.
• Build advanced DAX measures and analytical logic for enterprise reporting.
• Create intuitive, high-performance Power BI dashboards and reports based on business requirements.
• Develop paginated reports using Power BI Report Builder.
• Write and optimize complex SQL queries, including CTEs, window functions, and analytical queries.
• Prepare and optimize Snowflake datasets for Power BI consumption.
• Collaborate with data engineering teams to ensure fact and dimension tables are properly structured and optimized.
• Integrate Power BI with Snowflake using appropriate connection modes while maintaining performance and data reliability.
• Monitor and troubleshoot performance issues across Power BI, DAX, SQL, and Snowflake environments.
• Support Snowflake performance tuning, compute optimization, clustering, and cost management.
• Apply Snowflake security concepts, including roles and role-based access control (RBAC).
• Document metadata, data lineage, report specifications, and analytical assets.
• Translate business requirements into structured data models and actionable reports.
• Support Power BI workspace management and report optimization.
• Collaborate with business stakeholders, subject matter experts, and technical teams to deliver enterprise reporting solutions.
• Support continuous improvement of analytics, reporting, and data warehouse processes.

Required Qualifications

• Bachelor''s degree in Computer Science, Information Systems, or a related field (or equivalent professional experience).
• Minimum 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, and data models.
• Advanced Power BI experience, including DAX, data modeling, Power Query, and report design.
• Strong SQL skills, including CTEs, window functions, analytical queries, and query optimization.
• Strong understanding of dimensional modeling, star schemas, and fact/dimension design.
• Hands-on experience with Snowflake performance tuning and optimization.
• Experience developing Power BI semantic models using dimensional design principles.
• Experience integrating Power BI with Snowflake.
• Experience with Power BI Report Builder and workspace management.
• Experience with metadata management, data lineage, and technical documentation.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with Power BI embedded analytics.
• Experience embedding Power BI reports into web or internal applications.
• Experience with Snowflake RBAC, warehouse sizing, clustering keys, and cost optimization.
• Knowledge of CI/CD practices for Power BI.
• Experience with version control for analytics solutions.
• Experience supporting enterprise data warehouse environments.
• Ability to work independently with minimal supervision while collaborating effectively with data engineers, SMEs, and business stakeholders.

Work Environment

• Full-time contract
• 100% onsite in Tallahassee, Florida
• Primarily standard business hours, with flexibility to support business needs when required.

Direct applicants only. No third-party vendor or staffing firm submissions will be considered.