Data Warehouse Analyst (B. Intermediate)

Job ID: FDOT Job 3430



Client: Florida Department of Transportation (FDOT)



Employment Type: Full Time / Contract



Duration: 09/01/2026 06/30/2027 (with potential for renewal based on performance and budget)



Work Location: Strictly ONSITE (Barry Building, 3185 S. Blair Stone Rd., Tallahassee, FL 32311).

• Requirement: Candidate must currently reside in Tallahassee or the surrounding area and report to the office 5 days per week.
  
  
  
  Interview Format: In-Person

The Florida Department of Transportation (FDOT) is seeking a Data Warehouse Analyst to develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake.

Primary Job Duties:

• Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
• Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
• Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
• Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
• Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
• Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
• Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.
• Troubleshoot performance issues across DAX, SQL, and Snowflake compute layers.
• Translate business requirements into structured semantic models and actionable reports.

Education:

• Bachelor's degree in Computer Science, Information Systems, or a related field. (Equivalent work experience may substitute for the educational requirement).

Required Experience & Technical Skills:

• 5+ Years: IT work experience in business intelligence tools and systems.
• 3-5 Years: 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).
• Advanced SQL: Query writing including CTEs, window functions, and analytical queries with optimization.
• Data Modeling: Strong understanding of dimensional modeling, star schema design, and fact/dimension modeling for semantic model development.
• Snowflake: Proficient in Snowflake tuning, clustering keys, compute optimization, cost control, and RBAC security concepts (roles, warehouse sizing, data governance).
• Power BI: Proficient in building Power BI semantic models with strong DAX and clean dimensional design. Proficiency in Power BI Report Builder, workspace management, and performance optimization.
• Integration: Experience integrating Power BI with Snowflake and connection modes.
• Documentation: Experience with metadata management, data lineage, and documentation.
• Embedding: Experience embedding Power BI reports into web or internal applications.

Preferred Experience:

• Knowledge of CI/CD for Power BI and version control is a plus.

General Skills & Abilities:

• Initiative & Problem Solving: Ability to identify, evaluate, and use sound judgment to generate alternative actions. Must be able to organize workload and meet deadlines with little direction.
• Communication & Collaboration: Excellent verbal and written communication skills to convey information effectively to project teams, management, and stakeholders.
• Customer Service & Flexibility: Works well with clients and adapts to new processes, changing conditions, or unexpected obstacles while maintaining effective relationships.