Service Readiness Program Manager

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

We are looking for a hands-on Power BI Developer to own and evolve our Power BI reporting environment, which sits on top of Microsoft Dynamics. This role is highly collaborative, requiring someone who can sit directly with business stakeholders, understand their reporting needs, review and rationalize existing reports, and build custom, production-grade Power BI solutions from the ground up. This is not a hand-off role - the ideal candidate writes their own DAX, builds their own data models, and designs their own visuals, while also being a confident communicator who can translate business requirements into technical solutions and explain technical trade-offs back to non-technical stakeholders.

Key Responsibilities

• Partner directly with business stakeholders to gather, clarify, and prioritize reporting requirements — running working sessions rather than relying solely on written specs.
• Audit and assess the existing Power BI report portfolio to identify redundancies, performance issues, data quality gaps, and opportunities for consolidation or improvement.
• Design, build, and maintain custom Power BI reports and dashboards sourced from Microsoft Dynamics (e.g., Dynamics 365 CE/F&O) and related data sources.
• Develop and optimize data models, DAX measures, calculated columns, and Power Query (M) transformations for performance and maintainability.
• Own the end-to-end report lifecycle: requirements, data modeling, visualization design, testing, deployment, and post-release support.
• Establish and enforce report design standards, naming conventions, and governance practices across the Power BI environment.
• Manage Power BI Service administration tasks including workspace organization, dataset refresh scheduling, row-level security (RLS), and gateway configuration for Dynamics data sources.
• Troubleshoot data discrepancies, refresh failures, and performance bottlenecks, working closely with Dynamics functional/technical teams as needed.
• Provide training, documentation, and ongoing support to business users to promote self-service reporting adoption.
• Communicate project status, risks, and recommendations clearly to both technical and business audiences.

Required Skills/Experience

• 5+ years of hands-on Power BI development experience, including report/dashboard design, data modeling, and DAX.
• Proven experience building Power BI reports on top of Microsoft Dynamics (365 CE, F&O, or Business Central) data sources.
• Strong command of DAX, Power Query (M), and Power BI data modeling best practices (star schema, relationships, aggregations).
• Experience with Power BI Service administration - workspaces, gateways, scheduled refresh, RLS, and deployment pipelines.
• Solid understanding of SQL and relational databases; ability to write and troubleshoot queries independently.
• Strong analytical skills with the ability to interpret business processes and translate them into meaningful reporting solutions.
• Excellent verbal and written communication skills; comfortable leading requirement-gathering sessions directly with business users and leadership.
• Demonstrated ability to review, critique, and improve existing reports rather than only building net-new ones.
• Strong ownership mentality - able to work independently with minimal hand-holding while keeping stakeholders informed.

Preferred Qualifications

• Experience with Dynamics data export options such as Dataverse, Azure Synapse Link, or Data Export Service.
• Familiarity with Azure data services (Data Factory, Synapse, Azure SQL) supporting Power BI on Dynamics.
• Experience with Power BI Premium capacity management and deployment pipelines.
• Microsoft certifications such as PL-300 (Power BI Data Analyst) or Dynamics-related credentials.
• Experience in a consulting or client-facing services environment.