Senior Power BI Developer

AprilAire; Madison (WI); Hybrid; USD 85,000 - 120,000; Full time

Job summary

AprilAire is seeking a BI Developer to join our hybrid team in Madison. You will develop and optimize Power BI reports, model semantic layers, and leverage DAX to deliver actionable insights for multiple business areas.

You will partner with product, sales, and other teams, train end users, and ensure data accuracy and consistency across dashboards. Strong Power BI, SQL, and communication skills are essential.

Qualifications

• Strong Power BI skills including data modeling, DAX, and report development.
• Experience with Power Query and Power BI Service.
• SQL experience preferred.
• Ability to work with business stakeholders to define requirements.
• Bachelor's degree or equivalent experience in IS/CS/Analytics.

Responsibilities

• Develop, maintain, and optimize Power BI reporting for multiple business areas.
• Partner with departments to understand usage and turn requests into dashboards.
• Build and maintain semantic models and DAX measures in Power BI.
• Work with business users to understand requirements for new requests.
• Provide training, support, and guidance to end users and user-developers.
• Collaborate with the BI team to ensure data accuracy and accessibility.
• Identify opportunities to improve analytics processes, tools, and standards.
• Demonstrate strong experience in Power BI reporting and service management.
• Support change management and project management activities.
• Solicit user feedback to continuously improve dashboards and adoption.

Skills

Power BI

Data modeling

DAX

Report development

SQL

Training & support

Stakeholder management

Change management

Project management

Analytical thinking

Education

Bachelor’s degree in Information Systems, Computer Science, Analytics, or a related field

Tools

Power Query

Power BI Service

SQL Server

Job description

This role combines report development, user training and support, and data modeling expertise to help transform business data into actionable insights. In addition to performing hands-on technical work, you will be a go-to representative of the BI team for the rest of the organization. The ideal candidate will be proficient technically in Power BI (including data modeling, DAX, and report development) while also being comfortable working closely with business stakeholders to deliver high-quality analytics solutions.

Hybrid role at our downtown Corporate location or Sun Prairie location

• Develop, maintain, and optimize Power BI reporting for multiple business areas.
• Partner with other departments (product, sales, marketing, R&D) understanding their usage and turning their requests into dashboards
• Build and maintain semantic models and DAX measures in Power BI.
• Work with business users to understand requirements for new requests.
• Provide training, support, and guidance to end users and user-developers to maximize adoption and understanding of BI tools.
• Collaborate with the BI team to ensure data accuracy, consistency, and accessibility.
• Identify opportunities to improve analytics processes, tools, and standards.
• Strong experience in Power BI, including report development, Power Query, DAX formulas, and managing user environments in the Power BI Service.
• SQL experience strongly preferred
• Experience providing end-user training and support in a BI environment.
• Ability to create a dashboard with a focus on continuous improvement based on customer and business needs
• Effective change management and project management skills
• Ability to solicit feedback to understand user needs, display attentive listening skills, and a customer service mindset
• Solid understanding of data modeling, relational databases, and data warehousing concepts.
• Strong ability and initiative to learn and solve new problems using new technology or techniques.
• Bachelor’s degree in Information Systems, Computer Science, Analytics, or a related field (or equivalent experience).