Power BI Developer

247Hire; Burbank (CA); On-site; USD 120,000 - 150,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. You will sit with business stakeholders, translate needs into production-grade BI solutions, write your own DAX, model data, and design visuals end-to-end.

You will audit existing reports, optimize data models, manage security roles, and oversee deployment pipelines while ensuring data quality and performance.

Qualifications

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

Responsibilities

• Partner with business stakeholders to gather and prioritize reporting requirements.
• Audit and optimize the current Power BI report portfolio.
• Design, build, and maintain Power BI reports and dashboards from Dynamics data sources.
• Develop and optimize data models, DAX measures, and Power Query transformations.
• Own end-to-end report lifecycle from requirements to post-release support.
• Enforce report design standards, governance, and naming conventions.
• Manage Power BI Service tasks: workspaces, gateways, RLS, and refresh schedules.
• Troubleshoot data discrepancies and performance bottlenecks with cross-functional teams.
• Provide training and documentation to promote self-service reporting.

Skills

Power BI development

DAX

Power Query (M)

SQL

Data modeling

Dynamics data sources

RLS

Deployment pipelines

Communication

Tools

Power BI Service

Azure Synapse

Dataverse

Job description

Job Description – add details here

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.

Skills and Requirements – add details here

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.

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.