Data Warehouse Analyst - Hybrid Tallahassee, FL

Data Warehouse Analyst - Hybrid Tallahassee, FL

Tallahassee, United States | Posted on 08/07/2026

• Actual Job Title PR1029455-R211624 - FDOT Job 3430:
  Data Warehouse Analyst (B. Intermediate) (RFQ)
• Job Type FT Contract
• Date Opened 08/07/2026
• Target Date 08/17/2026
• State/Province Florida
• Country United States
• Assigned Recruiter(s) Dinesh Mathi
• Number of Positions 1

The Data Warehouse Analyst / Report Builderwill develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creatingadvanced DAX calculations, writing and tuning complex SQL queries, and ensuring Snowflake datasets are modeled and structured for reliable Power BIconsumption. The resource will work with data engineers to supportdimensional modeling, maintain metadata and data lineage documentation, andensure 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, and operateeffectively in a dynamic environment with minimal oversight.

Bachelor’s degree in computer science, Information Systems, orother related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.

• 1.Required minimum of 5 years of IT work experience in business intelligence tools and systems.
• 2.A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX.
• 3.Advanced SQL query writing includes CTEs,window functions, and analytical queries with optimization.
• 4.Strong understanding of star schema designand fact/dimension modeling.
• 5.Proficient in Snowflake tuning, clusteringkeys, compute optimization, and cost control.
• 6.Familiarity with Snowflake RBAC, roles,warehouse sizing, and data governance.
• 7.Proficient in building Power BI semanticmodels with strong DAX and clean dimensional design.
• 8.Experience in integrating Power BI with Snowflake and connection modes.
• 9.Proficiency in Power BI Report Builder,workspace management, and performance optimization.
• 10. Experience with metadata management, data lineage, and documentation.
• 11. Experience embedding Power BI reports into web or internalapplications.
• 12.Knowledge of CI/CD for Power BI and version control is a plus.

• 1.
  Design and develop Power BI dataflows and semantic models using dimensionalmodeling practices.
• 2.
  Build advanced DAX measures and analytical logic to support enterprise-gradeend-user reporting.
• 3.
  Create user-friendly,high-performance Power BI reports and dashboards that meet defined business requirements.
• 4.
  Writeand optimize complex SQL queries (CTEs, window functions, analyticalqueries) to retrieve and prepare Snowflake data for reporting.
• 5.
  Collaborate with Snowflake data engineering teams to ensure fact/dimension tables arestructured and optimized for Power BI consumption.
• 6.
  Integrate Power BI with Snowflake using appropriate connection modes, ensuringperformance, query folding, and data reliability.
• 7.
  Document data lineage, metadata, and report specifications to supportmaintainability, governance, and transparency across analytics assets.

• 1.
  Knowledge of dimensional modeling and star schema design for semantic modeldevelopment.
• 2.
  Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query.
• 3.
  Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts.
• 4.
  Skill in building optimized, scalable Power BI semantic models using strongdimensional design.
• 5.
  Skill in writing advanced SQL queries and tuning Snowflake datasets for PowerBI consumption.
• 6.
  Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design.
• 7.
  Ability to translate business requirements into structured semantic models and actionable reports.
• 8.
  Ability to troubleshoot performance issues across DAX, SQL, and Snowflake…