BI Analyst

At MacDonald-Miller Facility Solutions (“MacMiller”) we . As the Northwest’s leading mechanical contracting firm, we design, deliver and service HVAC, plumbing and automation system solutions for commercial buildings. With our over 1500 employees across 14 offices, there is a breadth and variety of work to keep you engaged and inspired. 

We enjoy a well-respected history of exceeding our customers’ expectations and . Our clients trust their toughest projects with our integrated teams, including: 

• New construction – Engineering, fabrication and installation of mechanical systems for new projects following lean construction practices 
• Special projects – Retrofits and mechanical repairs for existing buildings for new efficiencies 
• Service - scheduled preventative maintenance ensuring tenant comfort, and 24/7 emergency response 
• Building performance – Control systems, fault detection, energy services and remote monitoring 
• Performance Contracting -- Sustainable Solutions: Acting as the Prime Contractor, we deliver design-build energy-efficient solutions in the built environment for private and public sector clients

People love to work at MacDonald-Miller, and it’s because we all share the same 

• Diverse players, one team, a common vision. Collaboration is our foundation and critical to the success of the company. Every team member is valued and brings a diversity of strengths to help us meet our common vision.
• We are dedicated to personal and professional excellence. We execute with distinction by doing the right thing and following through on our commitments.
• Everyone deserves a safe workplace. Safety is more than hardhats and boots, it’s an attitude and the environment we create. Every day, everyone goes home to their families.
•  We are proud to be part of MacDonald-Miller. We actively seek to build relationships and know each other as individuals. Together we create an environment that is welcoming, caring, and trusting.
• We are committed to continuous. Innovation is how we stay an industry leader. We always strive to challenge and better ourselves.
• Take the work seriously, but never take ourselves too seriously. It’s possible to be both serious professionals and good-natured people you enjoy working with. We strive to be both.

Requirements

BI Analyst: This is where you come in. 

We are seeking a BI Analyst to transform data into actionable insights and drive informed business decisions. Your key responsibilities will include developing and maintaining PowerBI reports and semantic models, while also supporting SSRS and ETL processes to ensure a robust and scalable analytics infrastructure. 

You’ll help improve data quality, support ongoing data migration efforts, and bring technical expertise in SQL, data modeling, and ETL pipelines to strengthen our reporting foundation. 

This is a highly collaborative role — you’ll work closely with internal stakeholders to understand reporting needs, provide PowerBI training to citizen developers, and promote data-driven thinking across the organization. In return, you’ll gain greater ownership, plenty of growth opportunities, and a high degree of freedom. 

Top 5 things to deliver in the first year to be a hero: 

• Data Visualization – You will create visually appealing PowerBI reports, dashboards, and applications to make complex data insights easy to understand. 

• PowerBI Environment Maintenance, Governance, and Auditing – You will develop visually compelling PowerBI reports, dashboards, and applications to effectively communicate complex data insights. Additionally, you will establish governance policies and procedures to ensure data integrity, compliance, and security within the BI platform. 

• Data Modeling and Transformation – You will make a significant impact by designing and implementing data models that support PowerBI and SSRS reporting needs, ensuring efficient data retrieval and analysis. You’ll also support and maintain ETL processes that ensure data quality, consistency, and performance across our reporting infrastructure. 

• PowerBI Training and Adoption Advocate – You will engage with all levels and functions across the organization. You will conduct training sessions and workshops for internal stakeholders and citizen developers, focusing on PowerBI usage, best practices, and advanced features. 

• Collaboration with Internal Customers – You will stay close to the action by working closely with internal customers to gather reporting requirements, understand business needs, and prioritize development efforts. 

Your Background: What kind of person will thrive in this role? 

You should have… 

• Bachelor’s degree in Information Technology, Data Science, Statistics, Business Administration, Accounting, or Computer Science  

• 1+ years in a BI Developer or related role. This experience should include working with BI tools, data analysis, SSRS reporting and report/dashboard creation. 

• Strong skills in Power BI Development, SSRS, DAX, T-SQL and familiarity with ETL pipelines or tools 

And everyone you work with should describe you as… 

• Team Oriented  

• Highly organized 

• Analytical  

• Having great attention to detail 

And you should be motivated by… 

• Empowering yourself to learn how to do something.  If you need a ton of handholding or a micro-manager boss, this is not the place for you. 

• Working in a lean, results-oriented environment, where you’ll be expected to do more, take on more, and achieve more every year. 

• Having fun in an environment high on transparency, open to innovative new approaches with a supportive family feel 

Benefits

Compensation:  $80,000 to $105,000 Annually  

MacDonald-Miller Facility Solutions presently provides employee coverage for: 

• Medical, dental, vision for employees (coverage available for dependents for shared premium). 

• 401k retirement plan including Company matching. 

• Vacation and Sick Compensation (PTO), and Holiday Pay! 

• Disability income protection including short term and long-term disability. 

• Employee and dependent life insurance. 

• Wellness Program. 

• Employee Assistance Program. 

Where you will work 

Our Seattle HQ office (17930 International Blvd, SeaTac, WA 98188) has easy access to the SeaTac International Airport, ample secured parking, and newly renovated office facilities - not to mention great views! Neighborhood amenities include an onsite deli, restaurants, and convenient freeway/airport access.  This is a hybrid role, requiring you to work in the office two days a week and allowing you to work from home for the remaining three days. 

Interested in learning more?  

If you’re ready for an adventure and are interested in being considered for this role, click apply to start the conversation! Or if you know someone who currently works at MacDonald-Miller, reach out to them to get introduced to the team! 

MacDonald-Miller Facility Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran