Senior PowerBI Architect – Onsite in Tallahassee

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

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.