Senior PowerBI Developer

TECKpert; Tallahassee (FL); On-site; USD 120,000 - 160,000; Full time

Job summary

TECKpert is seeking a Senior PowerBI Developer to design, build, and maintain PowerBI dashboards for a state transportation client in Tallahassee, FL. The role involves semantic modeling, DAX calculations, and Power Query transformations from SQL/Oracle sources.

Responsibilities include securing data with RLS, optimizing T-SQL queries, and collaborating with business owners and IT staff. This is a full-time, 40-hour onsite engagement with great growth potential.

Qualifications

• Bachelor's degree or equivalent in CS/IS or related field.
• 5+ years of production experience developing enterprise Microsoft PowerBI reports and dashboards.
• Advanced proficiency in DAX for complex measures, time intelligence, and calculated tables.
• Advanced proficiency in Power Query (M) for data ingestion and transformation.
• Strong experience with semantic model design using star schemas and dimensional modeling best practices.
• Strong T-SQL skills, including writing performant queries, views, and stored procedures against SQL Server or Oracle.
• Experience administering PowerBI Service artifacts (workspaces, dataflows, deployment pipelines, gateways, refresh scheduling).
• Experience implementing Row-Level Security (RLS) in PowerBI.
• Authorized to work in the United States without sponsorship
• Ability to pass an FBI Level II background check

Responsibilities

• Design, build, and maintain PowerBI reports and dashboards for financial and operational reporting.
• Build performant semantic models using star schemas, calculated tables, and DAX measures.
• Author Power Query (M) transformations to ingest and shape data from SQL Server, Oracle, or other sources.
• Manage PowerBI Service artifacts including workspaces, dataflows, datasets, deployment pipelines, and gateways.
• Implement Row-Level Security (RLS) policies for controlled data access.
• Write and optimize T-SQL against source databases to support PowerBI data flows.
• Collaborate with business stakeholders to gather reporting requirements and translate them into working dashboards.
• Document data lineage, refresh schedules, semantic model definitions, and end-user guides.
• Provide production support, refresh troubleshooting, and enhancement work on existing dashboards.
• Follow secure coding, data governance, and change management practices in line with state IT policies.

Skills

PowerBI

DAX

Power Query

T-SQL

Semantic Modeling

SQL Server

Oracle

Stakeholder Collaboration

Education

Bachelor's degree in CS/IS or related

Tools

PowerBI Service

Azure Data Factory

Azure Synapse

Report Builder

PowerBI Premium

Job description

We are looking for a Senior PowerBI Developer to support our client based in Tallahassee, FL.

US BASED CANDIDATES ONLY.

Candidates must be located in Tallahassee, FL or the surrounding area.

*No third parties and no sponsorship*

Who we are

Founded in 2009 and headquartered in beautiful Miami, FL, TECKpert is a tech consulting and staff augmentation firm. At TECKpert, we offer a contingent workforce built for any size digital transformation project. Experts in design, development, IT, analytics and marketing, provide innovative digital solutions to achieve success in our new economy. Our leaders identify the technical talent best suited to bolster our client's capabilities, across all industries, including, healthcare, government, finance, legal, real estate, and startups.

The Opportunity

TECKpert is seeking a Senior PowerBI Developer to support our client, a state transportation agency in Tallahassee, FL, on financial and operational reporting for the Office of the Comptroller. This role will design, build, and maintain PowerBI dashboards, semantic models, and refresh pipelines that surface state accounting and operational data to executives, managers, and program staff.

The developer will work directly with business owners, financial analysts, and IT staff to translate reporting requirements into performant PowerBI solutions. Responsibilities include semantic model design (star schemas, calculated tables), DAX authoring, Power Query transformations from SQL and other source systems, report design and visualization best practices, and PowerBI Service administration (workspaces, dataflows, gateways, row-level security).

Job duties include, but are not limited to:

• Design, develop, and maintain Microsoft PowerBI reports and dashboards for financial and operational reporting
• Build performant semantic models using star schemas, calculated tables, and DAX measures
• Author Power Query (M) transformations to ingest and shape source data from SQL Server, Oracle, or other enterprise sources
• Manage PowerBI Service artifacts including workspaces, dataflows, datasets, deployment pipelines, and gateways
• Implement Row-Level Security (RLS) policies for controlled data access
• Write and optimize T-SQL and views against source databases to support PowerBI data flows
• Collaborate with business stakeholders to gather reporting requirements and translate them into working dashboards
• Document data lineage, refresh schedules, semantic model definitions, and end-user guides
• Provide production support, refresh troubleshooting, and enhancement work on existing dashboards
• Follow secure coding, data governance, and change management practices in line with state IT policies

Compensation and Term

This opportunity is for a full-time, contract position with possible extensions and pay commensurate with experience up to $80 per hour or $160,000 per year. The initial engagement runs approximately one year with possible renewal, and is 40 hours per week onsite in Tallahassee, FL.

Qualifications you need

A successful candidate has the following experience:

• Bachelor's degree or technical institute degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent professional experience
• Minimum 5 years of production experience developing enterprise Microsoft PowerBI reports and dashboards
• Advanced proficiency in DAX for complex measures, time intelligence, and calculated tables
• Advanced proficiency in Power Query (M) for data ingestion and transformation
• Strong experience with semantic model design using star schemas and dimensional modeling best practices
• Strong T-SQL skills, including writing performant queries, views, and stored procedures against SQL Server or Oracle
• Experience administering PowerBI Service artifacts (workspaces, dataflows, deployment pipelines, gateways, refresh scheduling)
• Experience implementing Row-Level Security (RLS) in PowerBI
• Strong communication and collaboration skills for working with business owners, analysts, and IT staff
• Ability to work 5 days per week onsite in Tallahassee, FL
• Authorized to work in the United States without sponsorship
• Ability to pass an FBI Level II background check

Preferred Qualifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300) or Microsoft Certified: Data Analyst Associate (DA-100)
• Microsoft Certified: Azure Data Engineer Associate (DP-203)
• Experience with PowerBI Premium capacity administration
• Experience with financial or state government reporting environments
• Familiarity with FLAIR (Florida Accounting Information Resource), Florida PALM, or comparable state accounting systems
• Experience with Azure Data Factory, Azure Synapse, or comparable modern data pipeline tools
• Experience with paginated reports (Report Builder) and PowerBI embedded scenarios

Working with us

Working with TECKpert means more options. As new opportunities arise, you tell us what you think is a good fit for you. What industries interest you most? Do you prefer an on-location, 9-5? Or would you want a flexible schedule and remote work? We proudly offer a wide variety of roles. Many of our TECKperts enjoy coworking and skills training coupled with the stability of full-time employment. We believe TECKpert gives today's digital professionals an agile path to start and advance their career. All of our opportunities require at least 20 hours per week and can be one to twelve months in length. Choose the opportunity that matches your interest and desired cadence.