> Markdown version of [/jobs/ext/1993240-data-warehouse-analyst-report-builder-power-bi-snowflake](https://www.wearedevelopers.com/jobs/ext/1993240-data-warehouse-analyst-report-builder-power-bi-snowflake). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Warehouse Analyst / Report Builder (Power BI & Snowflake)

- **Company:** KAIS ASSOCIATES LLC
- **Location:** Tallahassee, FL, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Information Systems, Information Engineering, Data Governance, Data Integrity, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, Performance Tuning, Role-Based Access Control, Power BI, Freeform SQL, Sql Optimization, Snowflake, Information Technology, Star Schema
- **Published:** August 8, 2026
- **Apply:** https://www.dice.com/job-detail/4dc49942-302a-4bec-8aa9-7687cd432a61

## About the Role

* Education: Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent hands-on work experience)^.
 * Overall BI Experience: Minimum 5+ years of IT experience in business intelligence tools and data warehousing^.
 * Power BI Expertise: 3-5 years of hands-on experience building enterprise-level dashboards, paginated reports (Power BI Report Builder), DAX calculations, and semantic models^.
 * Advanced SQL: Proven proficiency writing and optimizing complex SQL queries (CTEs, window functions, analytical queries)^.
 * Data Modeling: Deep expertise in dimensional modeling, star schema design, and fact/dimension structures^.
 * Snowflake Environment: Experience with Snowflake performance tuning, clustering keys, compute optimization, warehouse sizing, and Role-Based Access Control (RBAC)^.
 * Location Requirements: Must reside in or be willing to relocate to Tallahassee, FL and report to the office 5 days a week (In-person interview required)^.

## Description

* Power BI & Semantic Modeling: Design, build, and optimize Power BI dataflows and semantic models using star schema and dimensional modeling practices^.
 * DAX & Report Development: Write advanced DAX measures and construct user-friendly, high-performance dashboards and reports^.
 * Snowflake & SQL Optimization: Write and tune complex SQL queries (CTEs, window functions, analytical queries) to prepare Snowflake datasets for Power BI consumption^.
 * Data Engineering Collaboration: Partner with data engineers to ensure fact and dimension tables are properly structured, sized, and modeled^.
 * Integration: Connect Power BI with Snowflake using optimal connection modes, ensuring query folding, data reliability, and performance^.
 * Documentation & Governance: Maintain metadata, document data lineage, and construct clear report specifications to support enterprise data governance^.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)