Data Engineer

MacDonald-Miller Facility Solutions • Seattle, WA

14h • $90,000 - $117,000 • Onsite

About The Position

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 systems, Building Power BI reports and semantic models that drive business decisions, and Contributing to our Microsoft Fabric data warehouse. You'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.

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
• You take ownership of outcomes, not just tasks.
• You're curious about both technology and the business problems it solves.
• You're a self-starter who thrives in a fast-paced environment with minimal supervision.
• You actively leverage AI tools such as Copilot, ChatGPT, and Claude to improve productivity, documentation, and development.
• You communicate effectively with both technical and non-technical audiences.

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.
• Designing and building integrations between the new ERP and enterprise systems
• Bringing ERP data into Microsoft Fabric and creating scalable data models
• Migrating and redesigning Power BI reports to support the new environment
• Leveraging 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