GDOT – Power BI Sr. Developer

Job 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.

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.