Power BI Program Lead – Dynamics Data & Dashboards

247Hire; Burbank (CA); On-site; USD 90,000 - 140,000; Full time

Job summary

247Hire is seeking a hands-on Power BI Developer to own and evolve our reporting environment built on Microsoft Dynamics data sources. You will write DAX, model data, and craft visuals while closely partnering with business stakeholders to translate requirements into production-grade solutions.

Lead end-to-end reporting including design, performance optimization, deployment, and user training. Strong communication skills are essential to explain technical trade-offs to non-technical audiences.

Qualifications

• 5+ years of hands-on Power BI development, including report/dashboard design and data modeling.
• Proven experience building Power BI reports on Microsoft Dynamics sources (365 CE/F&O/BC).
• Strong command of DAX, Power Query (M), and star schema data modeling best practices.

Responsibilities

• Partner with business stakeholders to gather, clarify, and prioritize reporting requirements—leading sessions.
• Audit existing Power BI reports to identify redundancies, performance issues, and data quality gaps.
• Design, build, and maintain custom Power BI reports and dashboards from Dynamics data sources.
• Develop data models, DAX measures, calculated columns, and M-transformations for performance.
• Own end-to-end report lifecycle: requirements, modeling, visualization, testing, deployment, support.
• Establish and enforce report design standards, naming conventions, and governance.
• Manage Power BI Service administration: workspaces, dataset refresh, RLS, gateways.
• Troubleshoot data discrepancies, refresh failures, and performance bottlenecks with cross-functional teams.
• Provide training, documentation, and ongoing support to promote self-service reporting.
• Communicate project status, risks, and recommendations to technical and business audiences.

Skills

Power BI

DAX

Power Query (M)

Data modeling

SQL

Dynamics data sources

Report design

Stakeholder communication

Governance & standards

Performance optimization

Job description

247Hire is seeking a hands-on Power BI Developer to own and evolve our reporting environment built on Microsoft Dynamics data sources. You will write DAX, model data, and craft visuals while closely partnering with business stakeholders to translate requirements into production-grade solutions.

Lead end-to-end reporting including design, performance optimization, deployment, and user training. Strong communication skills are essential to explain technical trade-offs to non-technical audiences.