Job Title: Data Warehouse Analyst (Intermediate) - Power BI
Location: Tallahassee, FL (100% Onsite - 5 Days/Week)
Duration: 09/01/2026 - 06/30/2027 (Possible Extension)
Interview Process: In-Person Interview Only
Work Schedule: Monday-Friday | Must be available between 7:00 AM - 7:00 PM as needed
Position Overview
The Florida Department of Transportation (FDOT) is seeking an experienced Intermediate Data Warehouse Analyst / Power BI Developer to support enterprise reporting and analytics initiatives. The selected candidate will design, develop, and maintain Power BI dashboards, reports, semantic models, and data solutions integrated with Snowflake data warehouse environments.
The ideal candidate will have strong hands-on experience with Power BI, DAX, SQL, Snowflake, dimensional data modeling, and enterprise business intelligence reporting. This role requires the ability to translate business requirements into scalable analytical solutions while collaborating with data engineering and business teams.
Primary Responsibilities
Location: Tallahassee, FL (100% Onsite - 5 Days/Week)
Duration: 09/01/2026 - 06/30/2027 (Possible Extension)
Interview Process: In-Person Interview Only
Work Schedule: Monday-Friday | Must be available between 7:00 AM - 7:00 PM as needed
Position Overview
The Florida Department of Transportation (FDOT) is seeking an experienced Intermediate Data Warehouse Analyst / Power BI Developer to support enterprise reporting and analytics initiatives. The selected candidate will design, develop, and maintain Power BI dashboards, reports, semantic models, and data solutions integrated with Snowflake data warehouse environments.
The ideal candidate will have strong hands-on experience with Power BI, DAX, SQL, Snowflake, dimensional data modeling, and enterprise business intelligence reporting. This role requires the ability to translate business requirements into scalable analytical solutions while collaborating with data engineering and business teams.
Primary Responsibilities
- Design, develop, and maintain enterprise-level Power BI dashboards, reports, and visualizations.
- Build and optimize Power BI semantic models using dimensional modeling techniques.
- Develop advanced DAX calculations, measures, KPIs, and business logic.
- Create and maintain Power BI Paginated Reports and Report Builder solutions.
- Develop complex SQL queries using:
- Common Table Expressions (CTEs)
- Window Functions
- Analytical Functions
- Query Optimization techniques
- Integrate Power BI solutions with Snowflake data warehouse environments.
- Collaborate with data engineers to optimize Snowflake tables, views, and data structures.
- Perform Power BI dataset optimization and report performance tuning.
- Design efficient star schema models with fact and dimension tables.
- Support metadata management, data lineage, and documentation efforts.
- Troubleshoot Power BI, SQL, and Snowflake performance issues.
- Develop reports based on business requirements and stakeholder needs.
- Ensure data accuracy, usability, and scalability of reporting solutions.
- Work independently while managing multiple priorities in a fast-paced environment.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent professional experience).
- Minimum 5+ years of Business Intelligence / Data Analytics experience.
- Minimum 3-5 years of hands-on Power BI development experience.
- Strong experience developing enterprise reporting solutions using:
- Microsoft Power BI
- Power BI Service
- Power BI Report Builder
- Power BI Semantic Models
- Power Query
- DAX
- Paginated Reports
- Strong SQL development skills with experience in:
- Complex SQL queries
- CTEs
- Window Functions
- Analytical Queries
- Query Performance Tuning
- Strong understanding of:
- Data Warehouse Concepts
- Star Schema Design
- Fact and Dimension Modeling
- Dimensional Data Modeling
- Semantic Layer Development
- Hands-on experience with Snowflake, including:
- Performance Optimization
- Warehouse Sizing
- Compute Optimization
- Clustering Keys
- Cost Optimization
- RBAC Security
- Data Governance
- Experience integrating Power BI with Snowflake.
- Experience with metadata management and data lineage concepts.
- Experience embedding Power BI reports into applications or internal portals.
- Strong communication and analytical skills.