Data Engineer

At MacDonald-Miller Facility Solutions("MacMiller") wemake 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 1500 employees across15offices, 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 andexecuting with distinction. Our clients trust their toughest projects with our integrated teams, including:

• New construction -Engineering, fabrication and installation of mechanical systems for new projectsfollowing leanconstructionpractices
• Special projects-Retrofits and mechanical repairsfor existing buildings for new efficiencies
• Service - scheduledpreventativemaintenance ensuring tenantcomfort,and 24/7 emergency response
• Building performance-Controlsystems, fault detection,energy services and remote monitoring

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 Engineer: This is where you come in.

We're searching for a talented Data Engineer to join our dynamic IT team. In this key position, you'll be instrumental in building the data infrastructure that powers MacDonald-Miller's next generation of data-driven insights and business intelligence. Your work will ensure the accessibility, cleanliness, and reliability of our data, enabling informed decision-making across the company.

As a Data Engineer, you will design, develop, and maintain scalable data pipelines and systems that collect, manage, and transform raw data into actionable insights. Collaborating closely with BI Analyst, Accounting and Business Units, you'll ensure that our data operations meet the evolving needs of our business.

To drive our success, you'll take on these core functions as a data champion:

• Data Pipeline Development and Data Modeling: Build and maintain scalable data pipelines to streamline ETL processes into data warehouses. Design efficient data models that ensure data integrity and performance, while having opportunities to apply machine learning for advanced analytics.
• Data Visualization: Develop impactful Power BI reports and dashboards that make complex data insights easy to understand, ensuring diverse stakeholders can leverage data effectively. Use advanced features to enhance data storytelling and decision-making.
• Process Improvement: Identify, design, and implement process improvements, including re-architecting infrastructure for greater scalability, optimizing data delivery, and automating manual workflows.
• Data Quality Assurance: Build and optimize infrastructure for seamless extraction, transformation, and loading of data using Azure Data Factory, MS Fabric, Fabric Data Factory, and SQL technologies, ensuring top-tier data quality.
• Stakeholder Collaboration: Partner with key stakeholders to support their data infrastructure needs, helping with technical issues while translating complex technical concepts into clear, actionable information for non-technical audiences.

This role reports to Maryna Wandschneider, IT Business Solutions Manager, and is part of a collaborative team working on a variety of critical projects and initiatives to support MacDonald-Miller's growth. In this highly visible position, you'll interact with teams across all levels of the organization.

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

You should have...

• Proven experience building and maintaining scalable data pipelines and ETL processes.
• Strong proficiency in SQL, Python and data modeling for data warehouses.
• Experience with Azure Data Factory, MS Fabric, Fabric Data Factory and Databricks cloud platforms and big data tools like PySpark.
• Expertise in staying current with data storage and management best practices.
• Strong problem-solving skills and attention to detail in managing data integrity.
• A minimum of 2 years in data processing, including working with data analytics platforms like Databricks or MS Fabric.

And everyone you work with should describe you as...

• A great problem solver, who can tackle complex challenges with creativity.
• Highly communicative, effectively collaborating with both internal and external stakeholders.
• Adaptable and resilient, with a positive, can-do attitude that thrives in change.

And you should be motivated by...

• Being part of a talented team and playing an essential role in shaping our data strategy, driving impactful insights.
• Learning independently and taking initiative. If you need constant supervision or a micro-managing boss, this isn't the right environment for you.
• Working in a lean, results-driven atmosphere where you're expected to take on more and achieve more each year.
• Enjoying a transparent, innovative workplace that values new ideas, all while fostering a supportive, family-like culture.

Compensation: $85,000 to $110,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.

Interested in learning more?

If you're ready for an adventureand 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.