Seeking an experienced Power BI Developer with a strong background in semantic data modeling, advanced DAX programming, data visualization, and Power BI administration.
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.