GDOT - Power BI Sr. Developer

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 bestpractice 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 Bachelors 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. Skills SkillRequired / DesiredAmountof ExperienceExpertise RatingMoveBachelors degree in Computer Science, Information Systems, Data Analytics, or related field.Required4YearsSolid SQL development experience in both Oracle and SQL Server.Required5YearsIT development experienceRequired5YearsExperience with Power BI administration, including gateways, RLS/OLS, workspace governance, and capacity managementRequired5Yearsexperience as an Oracle BI development using OBIEE Semantic model (RPD), interactive reports and dashboardRequired5YearsExperience working with large, complex data sets in a multi-system environmentRequired5Years Questions Question 1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question 2 Please list candidate's email address that will be used when submitting E-RTR. Question 3 Candidate must be paid the rate of • • • if selected for engagement therefore the SRP rate cannot exceed • • • The contractor can be paid more, however the SRP rate cannot exceed 73.50. Do you accept this requirement? Question 4 The maximum mark-up for this engagements SRP rate is • • • %. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%? Question 5 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. Do you accept this requirement? Question 6 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the clients selection date. Do you accept this requirement? Question 7 This position is Hybrid (Remote and Onsite). The candidate first day is onsite and onsite on demand basis. Preference will be given to candidates local to Atlanta Metro area/ • • • . Indicate if candidate has full time residency within the Atlanta Metro area, within the • • • , or if the candidate resides outside of the • • • . Do you accept this requirement? Question 8 Preference will be given for candidates who are US Citizens, Permanent Residence Card (aka Green Card) or have Employment Authorization Document (EAD). Indicate if candidate citizenship or visa status is a US Citizen, Permanent Residence card, EAD, H1B, or other.. Do you accept this requirement? Question 9 GDOT will not be providing any raises within the first 2 years. After that point, the rate increase will be based on performance and budget dependent. Question 10 This Position is in Atlanta GA Your consultant is required to travel to Atlanta for their first day for onboarding. Travel will be at no expense to GDOT in order to obtain your candidate's computing equipment and ID/Security badge. Do you accept this requirement? Agency Interview Type No Interview Required Work Arrangement Hybrid