Senior Power BI Consultant (Contract)

## About the Role The Senior Power BI Consultant will play a key role in maintaining and enhancing Power BI reports and dashboards for an active client engagement. This is a hands-on Power BI role that requires a deep understanding of Power BI modeling, DAX, and SQL. The ideal candidate will have experience working in a consulting environment and be comfortable communicating with clients and stakeholders.

The role involves taking ownership of an existing Power BI implementation, improving it, and ensuring its reliability. This includes data modeling, DAX, troubleshooting, and client-facing reporting support. The Senior Power BI Consultant will work directly with internal project stakeholders and client users to clarify reporting needs and explain dashboard behavior.

As a Senior Power BI Consultant at DOOR3, you will be part of a team that values collaboration, innovation, and excellence. You will have the opportunity to work with a diverse range of clients and projects, and to develop your skills and expertise in Power BI and data visualization.

## What You Will Do - Maintain and enhance Power BI reports and dashboards for an active client engagement - Develop and optimize Power BI data models, relationships, measures, and visuals - Write and maintain DAX measures and Power Query transformations - Validate report outputs against source data and business requirements - Investigate and resolve report performance, refresh, data accuracy, and usability issues - Work directly with internal project stakeholders and client users to clarify reporting needs and explain dashboard behavior - Document key metrics, report logic, assumptions, and known limitations - Troubleshoot Power BI refresh failures, data discrepancies, model issues, and report performance - Collaborate with the project team to ensure that reporting needs are met and that dashboards are delivered on time

## What We Are Looking For - Senior-level Power BI consultant/developer with 5+ years of experience in BI, reporting, analytics, or data visualization - 3+ years of hands-on Power BI experience, including Power BI Desktop and Power BI Service - 3+ years of DAX experience, including measures, calculated columns, filtering logic, and performance-aware calculations - 2+ years of SQL experience, preferably with SQL Server or Azure SQL - Strong understanding of BI data modeling concepts, including relationships, measures, KPIs, and report-level filtering - Experience troubleshooting Power BI refresh failures, data discrepancies, model issues, and report performance - Strong communication and interpersonal skills, with the ability to work with clients and stakeholders - Ability to work independently and as part of a team

## Nice to Have - Experience inheriting and improving existing Power BI reports - Experience with Power BI workspace management, permissions, deployment, and dataset refresh configuration - Familiarity with row-level security and report access controls - Experience working with operational, legal, case management, HR, or nonprofit reporting

## Benefits and Perks - Remote work arrangement with flexible hours - Opportunity to work with a diverse range of clients and projects - Collaborative and dynamic work environment - Professional development and training opportunities - Access to the latest tools and technologies - Competitive compensation and benefits package - Recognition and reward for outstanding performance

- Tip: Make sure you have a strong understanding of Power BI modeling, DAX, and SQL, as these are essential skills for this role.

• Tip: Highlight your experience working with clients and stakeholders, as this is a key aspect of the job.
• Tip: Be prepared to provide examples of your work, including reports and dashboards you have developed.
• Tip: Show enthusiasm and passion for data visualization and Power BI, and be prepared to discuss your experience and skills in these areas.
• Tip: Ask about the company culture and values, and be prepared to discuss how you can contribute to the team.
• Tip: Be prepared to discuss your experience with troubleshooting and problem-solving, as these are critical skills for this role.
• Tip: Research the company and the role, and be prepared to ask informed questions during the interview process.