Power BI Developer
Power BI Developer — VMS/MSP Reporting & Dashboards Area of Focus: Technical — Business Intelligence & Data Visualization Location: Remote (US) Engagement Type: Contract, $60/hour Reports to team supporting: BI Team, North America Main Purpose of Role We're looking for a Power BI Developer to build and maintain reporting and dashboards that turn VMS/MSP program data into clear, actionable metrics for internal and client-facing use. This role pulls data from a variety of sources — including VMS platforms, manual inputs, and existing systems — and works toward reducing manual effort through automation over time. You'll work collaboratively with the BI team and business stakeholders, translating reporting requests into reliable, well-structured Power BI solutions.
Key Responsibilities
Design, build, and maintain Power BI dashboards and reports, including data modeling, DAX, and visual layer development. Support VMS report configuration and data integration (e.g., Fieldglass, Beeline, VNDLY), including validating data pulled via API connections. Pull and consolidate metrics from multiple sources — including manual calculations — for recurring (typically monthly) reporting. Build and optimize SQL queries and data structures to support dashboard and reporting needs. Identify and implement automation opportunities for recurring reports and refresh workflows to reduce manual effort, working toward a fully automated solution. Troubleshoot Power BI, DAX, Power Query, and data issues as they arise. Partner with internal stakeholders (and, as needed, clients) to gather reporting requirements and walk through completed dashboards. Apply staffing/MSP industry context — SLA/KPI metrics, cost-savings methodology, rate benchmarking — so outputs are business-relevant, not just technically correct. Document builds and processes clearly enough for others on the team to maintain or extend the work. Skills Required Solid working proficiency in Power BI: DAX, Power Query, data modeling, and dashboard/report design. SQL proficiency for querying and validating source data. Strong Excel and MS Office skills, with comfort doing metrics/numbers calculations. Experience with at least one VMS platform (Fieldglass, Beeline, or VNDLY) preferred, or willingness to ramp up quickly. Familiarity with data warehouse concepts and working with multiple, disparate data sources. Clear written and verbal communication — able to explain reporting logic to non-technical stakeholders. Self-motivated and comfortable working within a project-based environment with moderate autonomy. Nice to have: exposure to Microsoft Fabric, Azure, Databricks/Snowflake, AWS, or Python for automation/analysis. Educational Requirements Bachelor's degree in Business Analytics, Data Science, Computer Science, Information Systems, Statistics, Mathematics, or equivalent practical experience. Experience 5+ years of experience in business intelligence, reporting, or data analysis roles, with meaningful hands-on Power BI development experience. Experience working with or supporting an MSP program, or exposure to a major VMS platform (Fieldglass, Beeline, or VNDLY), preferred. Experience in staffing, recruitment, or talent acquisition environments is a plus, but not required.
Compensation
Pay rate: $60/hour, contract. Rate reflects a hands-on Power BI Developer role focused on dashboard build/maintenance and reporting automation, rather than an architecture-owning or team-lead level position. Brand: Impellam