Power BI Lead

DICE is the leading career destination for tech experts at every stage of their careers. Our client, Ledgent Technology, is seeking the following. Apply via Dice today!

Power BI Lead

90 Day Contract

Denver, Colorado (I-25 and Colorado Blvd.)

Onsite

$55 to $65 per hour (depending on experience)

A seasoned Power BI Lead is needed for a focused 90 day engagement. This person will assess the current BI environment, drive a structured cleanup effort, and lead a small team to improve reporting quality, governance, and reliability. The ideal candidate is a hands‑on technical leader with strong BI project management experience and the ability to self‑start and execute with minimal oversight.

Lead and deliver a targeted cleanup and standardization of the existing Power BI ecosystem including reports, datasets, dataflows, refresh processes, and governance. This role will also coordinate and guide team members to execute a prioritized improvement backlog and establish a sustainable BI operating model moving forward.

The current Power BI environment requires rationalization and structure. Reports and datasets may be duplicated, performance issues are likely, ownership may be unclear, and multiple versions of truth may exist. The team needs a Power BI expert who can map the current state, build a practical plan, and manage contributors to deliver measurable improvements quickly.

• Discovery and Assessment
• Inventory all Power BI assets including reports, datasets, dataflows, gateways, RLS rules, work spaces, and refresh schedules
• Identify owners and current usage patterns
• Surface key issues such as performance bottlenecks, broken refreshes, redundant datasets, security gaps, and ungoverned work spaces
• Prioritization and Planning
• Build a short, ranked improvement backlog based on usage and executive visibility
• Create a 90 day delivery plan with weekly sprints and a clear Now, Next, Later roadmap
• Cleanup and Standardization
• Consolidate and standardize semantic models and shared datasets
• Implement consistent naming conventions, folder structures, and documentation standards
• Apply standardized DAX formatting and centralized shared measures
• Introduce standardized report themes and UX elements
• Fix dataset and dataflow refreshes and improve performance where needed
• Governance and Operating Model
• Define workspace strategy including Dev, Test, and Prod
• Establish roles, permissions, and consistent RLS or OLS approaches
• Set up change control processes, deployment pipelines, and PBIX source control
• Clarify ownership of datasets, reports, and refresh responsibilities
• Team Leadership and Enablement
• Run standups, manage sprint execution, and unblock team members
• Coach analysts on modeling, DAX, and performance tuning best practices
• Produce runbooks, playbooks, and complete handover documentation

• Priority reports load in under 5 to 10 seconds
• Scheduled refresh success rate at 99 percent or higher for Tier 1 content
• One certified dataset per major subject area with reduced redundancy
• Fully documented Dev, Test, Prod work spaces with clear RBAC and RLS
• Standardized report navigation, themes, and guidance notes
• Increase in adoption and satisfaction for certified reports
• Complete handover documentation and clearly assigned ongoing ownership

• Power BI Technical Leadership
• Expertise in data modeling, star schema design, DAX, Power Query, and Performance Analyzer
• Experience building and managing semantic models and shared datasets
• Strong knowledge of RLS or OLS, workspace setups, certification, and governance
• Ability to troubleshoot refresh failures, gateway issues, and incremental refresh
• Project and People Leadership
• Ability to run a structured 90 day plan with sprints and standups
• Experience coordinating analysts, engineers, and SMEs
• Strong communication skills with executives and business stakeholders
• Self Starter Mindset
• Able to independently assess an environment and build a plan from scratch
• Skilled at stakeholder discovery and determining priorities
• Comfortable driving clarity even with…