Power BI Specialist | Work from Home

Spoke; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

Spoke in the United States is seeking a Power BI Reporting Specialist to develop, customize, maintain, and optimize interactive dashboards and reports. This role partners with business stakeholders to translate reporting needs into clear visuals, ensure data accuracy, and deliver reliable insights for decision making.

A strong candidate will excel in data modeling, Power Query, and SQL, and will document processes while improving performance and usability.

Qualifications

• Bachelor's degree or equivalent practical experience required.
• Hands-on experience with Power BI report development and customization.
• Knowledge of Power Query for data transformation and preparation.
• Understanding of data modeling and basic database concepts.
• Experience with Excel and structured data sources; SQL preferred.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent attention to detail and commitment to data accuracy.
• Good communication with business stakeholders.

Responsibilities

• Develop, customize, and maintain interactive dashboards and reports using Microsoft Power BI.
• Create visually appealing, user-friendly dashboards.
• Connect Power BI reports to Excel, SQL databases, and other data sources.
• Perform data validation and quality checks to ensure accuracy.
• Optimize report performance, improve loading times, and troubleshoot issues with the report developer.
• Publish and manage reports and dashboards in the Power BI Service.
• Configure scheduled data refreshes, workspace access, and report permissions as appropriate.
• Maintain documentation for reports, data sources, calculations, and reporting processes.
• Collaborate with business teams, data analysts, and IT teams to improve reporting solutions.
• Provide user support and guidance on dashboard navigation, filters, and report functionality.
• Identify opportunities to automate manual reporting processes and improve efficiency.

Skills

Power BI development

Power BI customization

Power Query

Data modeling

SQL knowledge

Excel skills

Analytical thinking

Attention to detail

Communication skills

Education

Bachelor's degree or equivalent

Tools

Power BI

Excel

SQL

Job description

Department: Operations

Reports To: Director, Operations & Administrative Services

Job Summary

The Power BI Reporting Specialist is responsible for developing, customizing, maintaining, and optimizing interactive dashboards and reports using Microsoft Power BI. This role works closely with business stakeholders to understand reporting requirements, enhance existing reports, create user-friendly visualizations, and deliver accurate, reliable, and actionable insights to support business decision‑making.

The ideal candidate has strong analytical skills, attention to detail, and experience with Power BI report development, data visualization, and report customization.

Key Responsibilities

• Develop, customize, and maintain interactive dashboards and reports using Microsoft Power BI.
• Create visually appealing, user-friendly, and easy-to-understand dashboards.
• Connect Power BI reports to various data sources, including Excel, SQL databases, and other business systems.
• Perform data validation and quality checks to ensure report accuracy and consistency.
• Optimize report performance, improve loading times, and troubleshoot reporting issues alongside PGP’s report developer.
• Publish and manage reports and dashboards in the Power BI Service alongside our developer.
• Configure scheduled data refreshes, workspace access, and report permissions as appropriate.
• Maintain documentation for reports, data sources, calculations, and reporting processes.
• Collaborate with business teams, data analysts, and IT teams to improve reporting solutions.
• Provide user support and guidance on dashboard navigation, filters, and report functionality.
• Identify opportunities to automate manual reporting processes and improve reporting efficiency.

Required Qualifications and Skills

• Bachelor's degree in Information Technology, Computer Science, Business Analytics, Data Analytics, or a related field, or equivalent practical experience.
• Hands-on experience with Microsoft Power BI report development and customization.
• Knowledge of Power Query for data transformation and preparation.
• Understanding of data modeling, table relationships, and basic database concepts.
• Experience working with Excel and structured data sources.
• Familiarity with SQL and relational databases is preferred.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent attention to detail and commitment to data accuracy.
• Good communication skills and the ability to work with business stakeholders.

Preferred Qualifications

• Experience with Power BI Service, workspaces, dashboards, and scheduled refreshes.
• Familiarity with access management.
• Experience optimizing report performance and improving dashboard usability.
• Knowledge of data visualization best practices and reporting standards.
• Experience with reporting automation and integration with other Microsoft tools.

Key Performance Indicators (KPIs)

• Accuracy and reliability of reports and dashboards.
• Timeliness of report development and requested customizations.
• Report performance and data refresh reliability.Reduction in manual reporting effort through automation.
• Compliance with reporting standards, access controls, and documentation requirements.