Data Team Lead

At MacDonald-Miller Facility Solutions (“MacMiller”) we make buildings work better. 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 1,600 employees across 13 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 executing with distinction. 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 Energy & 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 Core Culture Values: Collaboration – 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. Dedication – We are dedicated to personal and professional excellence. We execute with distinction by doing the right thing and following through on our commitments. Safety – 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. Community – 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. Innovation – We are committed to continuous, creative problem solving. Innovation is how we stay an industry leader. We always strive to challenge and better ourselves. Fun! – 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. Data Team Lead This is where you come in. We’re looking for a Data Team Lead to own MacDonald-Miller’s data and analytics platform and the team that builds on it. This is a player‑coach role: you’ll directly lead our BI Analysts and Data Engineers while staying hands‑on with the architecture, the hardest problems, and the most strategic deliverables. We’re a Microsoft shop investing heavily in Fabric as the foundation of our data platform. This team is focused entirely on data: building the warehouse that brings our information together, creating the semantic layer that defines how we measure the business, developing Power BI reports that support day to day decision making, and partnering closely with stakeholders to turn data into better business outcomes. This role reports to the Senior Director of IT and directly leads the BI and data engineering team. Top deliverables in the first year to be a hero Successfully lead the ERP data transition into Microsoft Fabric Ensure historical and new ERP data flow together seamlessly so the business maintains trusted reporting through go‑live. Build a certified semantic layer Create one trusted source for key metrics like revenue, margin, utilization, and labor hours across the company. Become a strategic partner to business leaders Understand what Construction, Service, Finance, and Operations leaders are trying to solve and deliver data that helps them make better decisions. Modernize and simplify the Power BI environment Refactor outdated reports, improve performance, and establish reporting standards and governance. Create strong team operating standards Implement clear sprint cadence, intake processes, documentation standards, code reviews, and prioritization methods. Develop and grow the data team Coach team members, create growth plans, and build a high‑performing, accountable team culture. Drive AI adoption across the team Use tools like Copilot and ChatGPT to improve development speed, documentation, analysis, and overall team productivity. Focus the team on business decisions, not just dashboards Measure success by the impact the data has on business decisions and operational improvements. Your Background What kind of person will thrive in this role? You should have 3+ years of experience in BI, analytics, or data engineering roles, with a proven track record of delivering production‑ready solutions that drove meaningful business outcomes Leadership experience — whether through direct people management, leading technical initiatives, or serving as the senior IC others relied on for guidance Strong Power BI expertise, including advanced DAX, semantic modeling, and workspace governance Strong SQL skills, including complex joins, stored procedures, query optimization, and working with large datasets Hands‑on experience within the Microsoft Azure data ecosystem, particularly Microsoft Fabric and/or Azure Data Factory Experience designing and building data warehouses and dimensional data models Experience developing ETL/ELT pipelines, including data cleansing, transformation, and validation processes Proven ability to partner with non‑technical business leaders by translating ambiguous business needs into actionable data solutions and influencing decision‑making Active, day‑to‑day use of AI tools to improve engineering productivity, analysis, documentation, and development workflows Excellent written and verbal communication skills, with the ability to communicate effectively with executives, technical teams, and non‑technical stakeholders And everyone you work with should describe you as A great problem solver A strong communicator to both technical and non‑technical staff. Passionate with a can‑do attitude Someone with high standards of customer service And you should be motivated by Working with a results‑oriented team to monitor and drive key performance indicators. Personal growth by learning and becoming proficient in multiple new systems and technologies. Having the ability to manage and complete work without micro‑management or constant handholding. Having fun in an environment high on transparency and open to innovative new approaches. Compensation $105,000 to $130,000 annually Benefits 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. 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. #J-18808-Ljbffr