GDOT - Power BI Sr. Developer

Expedite Talent Solutions; Glenwood (GA); On-site; USD 85,000 - 110,000; Full time

Job summary

A leading staffing agency is seeking an experienced Power BI Developer in Glenwood, Georgia, to join the Georgia Department of Transportation. The role requires extensive knowledge in DAX programming, semantic data modeling, and Power BI administration. Candidates should have a Bachelor's degree in a related field and at least 5 years of hands-on Power BI experience. This position offers an opportunity for long-term engagement, subject to annual budget reviews, with responsibilities including the design and development of BI solutions and stakeholder collaboration.

Qualifications

• 4 years of Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• 5+ years of hands-on Power BI development experience.
• Strong expertise in advanced DAX programming, semantic modeling and Power Query.
• Solid SQL development experience in both Oracle and SQL Server.

Responsibilities

• Design and optimize Power BI semantic models using best practices.
• Develop complex DAX measures and calculated columns for business logic.
• Build intuitive Power BI dashboards and implement data visualization techniques.
• Manage Power BI Service components and support governance initiatives.

Skills

Power BI development

DAX programming

Data visualization

Semantic modeling

SQL development

Collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI Desktop

Power BI Service

SQL Server

Oracle

Job description

Short Description

Seeking an experienced Power BI Developer with a strong background in semantic data modeling, advanced DAX programming, data visualization, and Power BI administration.

Complete Description

Agency: Georgia Dept. of Transportation (GDOT)

While the intent may be a long‑term tenure, this position is subject to annual budget restrictions. The initial contract is through the end of this fiscal year and is anticipated to be renewed July 1st, 2026.

Semantic Modeling & Data Architecture

• Design, develop, and optimize Power BI semantic models using best‑practice dimensional modeling techniques (star schema, snowflake, dataflows, shared datasets).
• Build enterprise‑grade datasets with proper relationships, hierarchies, calculation groups, and incremental refresh.
• Collaborate with data engineering teams to define data requirements, improve data quality, and ensure model scalability and maintainability.
• Implement data modeling standards that support self‑service analytics and governed data access.

Advanced DAX Programming

• Develop complex DAX measures, calculated columns, and tables to support business logic, KPIs, and analytical insights.
• Optimize DAX for performance, readability, and maintainability across large datasets.
• Troubleshoot calculation issues and ensure accuracy and consistency across reports and dashboards.
• Implement row‑level and object‑level security (RLS/OLS) within the semantic model.

Visualization & Dashboard Development

• Build intuitive, visually compelling Power BI dashboards that communicate insights clearly and effectively.
• Apply data visualization best practices and data storytelling techniques to support decision‑making.
• Create interactive features such as drill‑throughs, bookmarks, custom visuals, and parameterized reports.
• Ensure dashboards meet accessibility, usability, and design standards.

SQL Development (Oracle & SQL Server)

• Write efficient, well‑structured SQL queries, stored procedures, and views to support BI data pipelines.
• Perform data profiling, validation, and transformation using SQL in both Oracle and SQL Server environments.
• Collaborate with DBAs and data engineers to optimize query performance and ensure data integrity.

Power BI Administration & Governance

• Manage Power BI Service components including workspaces, datasets, data gateways, refresh schedules, and capacity utilization.
• Support governance initiatives such as dataset certification, naming conventions, documentation, and version control.
• Monitor performance, troubleshoot refresh failures, and optimize dataset size and gateway performance.
• Assist with tenant‑level administration including user access, licensing, and compliance with organizational policies.

Collaboration & Stakeholder Engagement

• Work closely with business stakeholders to gather requirements and translate them into scalable BI solutions.
• Provide guidance and support to self‑service BI users across the organization.
• Document data models, DAX logic, SQL scripts, and report specifications.
• Participate in Agile or project‑based workflows to support continuous improvement of BI capabilities.

Required Qualifications

• 4‑years Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
• 5+ years of hands‑on Power BI development experience.
• Strong expertise in: semantic modeling (star schema, dataflows, composite models); advanced DAX programming; Power Query (M language); Power BI Desktop and Power BI Service.
• Solid SQL development experience in both Oracle and SQL Server.
• Experience with Power BI administration, including gateways, RLS/OLS, workspace governance, and capacity management.
• Strong understanding of relational and dimensional modeling concepts.
• Ability to communicate complex technical concepts to non‑technical audiences.

Preferred Skills

• Familiarity with Oracle Business Intelligence (OBIEE) Semantic model (RPD), interactive reports and dashboard.
• Knowledge of enterprise data governance frameworks.
• Experience working with large, complex data sets in a multi‑system environment.