Senior Power BI Consultant

Chicago, IL Until 8/23/2026 4+ years exp First posted June 10, 2025 Last posted June 10, 2025
Job description

Role: Senior Power BI Consultant

We are seeking a Power BI development and implementation expert with an advanced proficiency in complex data analysis to join our team as Senior Power BI Consultant.

You thrive on the pursuit of factual information and require tangible resources to believe information. You are driven by accuracy and possess strong skills in data integration, performance optimization, and security implementation along with a solid foundation in Power BI, SQL, and database knowledge.

Your communication style is quick, brusque, and data-filled and your delivery is more informative than social. You are open to engaging and sharing your inputs with your team more frequently to foster valuable opportunities for mutual learning.

As a Senior Power BI Consultant at Collectiv, you’ll bring your business acumen and technical expertise to the table and work side-by-side with enterprise teams all the way from strategy to implementation to support. You’ll work on a wide variety of exciting and challenging projects that continually expand your knowledge base and skillsets.

In your daily and weekly routine, you will be tasked with regularly interacting with clients to collect and fine-tune data and reporting needs. This involves gathering feedback, ensuring alignment with client expectations, and overseeing the successful implementation and continuous support of Power BI, which includes conducting training sessions.

Your major responsibilities include:

  • Design and implement complex data models utilizing Power BI
  • Create visually appealing and interactive reports and dashboards using Power BI
  • Develop and optimize DAX formulas
  • Integrate data from diverse sources
  • Leverage SQL skills to facilitate efficient data extraction and integration with Power BI
  • Enhance client outcomes through strategic consulting and help clients identify additional opportunities for growth
  • Act as a core technical asset and resource in our marketing efforts
  • Provide expert guidance on Power BI solutions and ensure precision in data discussions
  • Conduct in-depth research in new areas to stay ahead of industry trends
  • Collaborate with team members to deliver high-quality solutions and participate in meetings, providing insights, and contributing to post-meeting discussions

Join Collectiv for a rewarding career in a fully remote work environment with quarterly in person team experiences and a competitive compensation. We provide a clear growth trajectory with professional development opportunities and a top-shelf benefits package. Enjoy unlimited time off and 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family. Our comprehensive offerings, from a competitive 401(k) with a 4% match to educational assistance, tech stipend, and discounts on various goods and services, demonstrate our commitment to your well-being and success. At Collectiv, your career thrives with a perfect blend of remote flexibility, growth potential, and unparalleled benefits prioritizing your financial, physical, and emotional well-being.

Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning and AI with Power BI and Microsoft Data Stack.

Our mission at Collectiv is simple: We help enterprises make better decisions.

Our Core Values:

Growth Mindset – Bring solutions, not problems.

Excel with Humility – Be humbly brilliant.

Communicate Actively and Empathetically – Listen, ask, understand, help.

Work Hard, Play Hard – Results are proportional to effort.

Keep Calm and Carry On – Stay cool, calm and Collectiv.

About this role

Summary

Design, develop, and optimize Power BI reports, dashboards, and data models.

Job title

Senior Power BI Consultant

Experience level

senior level

Minimum experience

4+ years exp

Industry

software

Location requirements

Remote work from Chicago, IL allowed

Salary

Not specified

Management role

No

Skills & keywords

Required skills

power bisqldaxdata analysisdata integration

Preferred skills

None specified

Specializations

power bisqldaxdata analysisdata integration
Locations

Structured locations inferred from the posting.

Chicago, IL, USA

Remote City