Data Engineer

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 over 1,600 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 executing with distinction. Our clients trust their toughest projects with our integrated teams, including: New construction - Engineering, fabrication and install 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 and 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 taking ourselves too seriously. It's possible to be both serious professionals and good-natured people you enjoy working with. We strive to be bothRequirementsData EngineerThis is where you come in.MacDonald-Miller is looking for a Data Engineer to join our IT team and help build the data platform that powers our business. This hands-on role focuses on three core areas:Developing integrations between our ERP and other enterprise systemsBuilding Power BI reports and semantic models that drive business decisionsContributing to our Microsoft Fabric data warehouseYou'll partner with IT, business leaders, and implementation partners to ensure data flows reliably across systems and is accessible, accurate, and actionable. As a Microsoft-focused organization investing heavily in Fabric, you'll have the opportunity to help shape the future of our data platform.Who You AreYou take ownership of outcomes, not just tasksYou're curious about both technology and the business problems it solvesYou're a self-starter who thrives in a fast-paced environment with minimal supervisionYou actively leverage AI tools such as Copilot, ChatGPT, and Claude to improve productivity, documentation, and developmentYou communicate effectively with both technical and non-technical audiencesWhat you'll ownSystems IntegrationsDesign, build, and support integrations between ERP, payroll, field service, HR, and other enterprise systems using APIs, webhooks, middleware, and database connections.Data Platform & WarehousingContribute to the architecture, pipelines, data modeling, and ongoing development of our Microsoft Fabric data warehouse.Reporting & AnalyticsDevelop Power BI reports and semantic models that provide reliable, actionable insights for business stakeholders.Data Quality & GovernanceImplement monitoring, logging, documentation, and validation processes to ensure data accuracy, reliability, and sustainability.Continuous ImprovementIdentify opportunities to automate processes, improve performance, and enhance the overall data ecosystem.First-Year PrioritiesAs MacDonald-Miller transitions to a new ERP platform, this role will be critical to the success of that implementation. Key objectives include:Designing and building integrations between the new ERP and enterprise systemsBringing ERP data into Microsoft Fabric and creating scalable data modelsMigrating and redesigning Power BI reports to support the new environmentLeveraging AI tools to accelerate development, documentation, and data analysisThis is a unique opportunity to help build the foundation of our enterprise data platform while gaining broad exposure across the business.Required QualificationsStrong SQL skills, including complex queries, stored procedures, and performance optimizationExperience with Microsoft Fabric, Azure Data Factory, or related Azure data technologiesExperience designing data warehouses and dimensional data modelsExperience building integrations using REST/SOAP APIs, webhooks, middleware, or database connectionsExperience developing ETL/ELT processes and data transformation workflowsExperience creating Power BI reports and semantic modelsKnowledge of JSON, XML, CSV, and other common data formatsExperience implementing monitoring, error handling, and support processes for production systemsStrong communication, documentation, and stakeholder management skillsActive use of AI tools in day-to-day engineering workPreferred QualificationsExperience integrating ERP, Payroll, HRIS, or Field Service Management systemsExperience supporting ERP implementations or large-scale system migrationsExperience with Python, PowerShell, or C#Familiarity with event-driven architectures, message queues, or integration platformsExperience with Git and CI/CD practicesExposure to ETL tools such as SSIS, Informatica, Boomi, or MuleSoftEveryone you work with should describe you as...Highly collaborative with strong communication skillsPassionate and solution-orientedSelf-motivated with a high level of initiativeAn exceptional problem solverYou should be motivated by...Learning and figuring things out independentlyWorking in a lean, results-oriented environment with significant ownershipBuilding solutions that have a direct impact on the businessHaving fun in a transparent, innovative, and supportive culturelBenefitsCompensation: Base rate of $90,000-$117,000MacDonald-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 workOur 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 position, and you will be expected to work from the office 2-3 days/week or more as needed.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.