Data Engineer

MacDonald-Miller Facility Solutions • Seattle, WA

18h • Hybrid

About The Position

MacDonald-Miller Facility Solutions (“MacMiller”) is seeking a Data Engineer to join their IT team. This role will focus on building the data platform that powers the business, with responsibilities in developing integrations between their ERP and other enterprise systems, building Power BI reports and semantic models, and contributing to their Microsoft Fabric data warehouse. The Data Engineer will 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, this role offers the opportunity to help shape the future of the company's data platform.

Requirements

• Strong SQL skills, including complex queries, stored procedures, and performance optimization
• Experience with Microsoft Fabric, Azure Data Factory, or related Azure data technologies
• Experience designing data warehouses and dimensional data models
• Experience building integrations using REST/SOAP APIs, webhooks, middleware, or database connections
• Experience developing ETL/ELT processes and data transformation workflows
• Experience creating Power BI reports and semantic models
• Knowledge of JSON, XML, CSV, and other common data formats
• Experience implementing monitoring, error handling, and support processes for production systems
• Strong communication, documentation, and stakeholder management skills
• Active use of AI tools in day-to-day engineering work

Nice To Haves

• Experience integrating ERP, Payroll, HRIS, or Field Service Management systems
• Experience supporting ERP implementations or large-scale system migrations
• Experience with Python, PowerShell, or C#
• Familiarity with event-driven architectures, message queues, or integration platforms
• Experience with Git and CI/CD practices
• Exposure to ETL tools such as SSIS, Informatica, Boomi, or MuleSoft

Responsibilities

• Design, build, and support integrations between ERP, payroll, field service, HR, and other enterprise systems using APIs, webhooks, middleware, and database connections.
• Contribute to the architecture, pipelines, data modeling, and ongoing development of our Microsoft Fabric data warehouse.
• Develop Power BI reports and semantic models that provide reliable, actionable insights for business stakeholders.
• Implement monitoring, logging, documentation, and validation processes to ensure data accuracy, reliability, and sustainability.
• Identify opportunities to automate processes, improve performance, and enhance the overall data ecosystem.
• Design and build integrations between the new ERP and enterprise systems.
• Bring ERP data into Microsoft Fabric and create scalable data models.
• Migrate and redesign Power BI reports to support the new environment.
• Leverage AI tools to accelerate development, documentation, and data analysis.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed