Data Engineer

About Alchemy Analytical Group
AAG is a leading manufacturer of consumables for life science analytical instruments, helping scientific and industrial customers by providing the key products they need to run their labs. Headquartered in Southwest Michigan, we operate 13 business units across the U.S., Canada, UK, and Ireland., with revenues exceeding $100 million.

Backed by Kanbrick, a long-term investment partner, we’re building the systems, processes, and technology needed to support our next stage of growth. That creates an opportunity for people who enjoy solving complex problems, building scalable solutions, and helping transform how data is used across the business.

The Role
AAG runs on data spread across companies, sites, and systems that operate largely independently. We are building a consolidated data warehouse: the one place where the group’s data is reliable, current, and usable for those running the business. This infrastructure will be the foundation by which we operate and scale the business, from the CEO to the shop floor, and is intended to support every function including Commercial, Manufacturing, Finance, Marketing, etc.

Reporting to the AAG Global Director of Strategy & Corporate Development the Data Engineer will:

• Lead the creation of production-grade infrastructure. Develop reliable, documented, and stable technology to run reporting and decisions against.
• Build and maintain data pipelines. Get data flowing into the warehouse cleanly and consistently from across AAG’s companies and systems (e.g., ERP, CRM, shop floor data tracking, etc.) and keep it flowing as sources change.
• Own the reporting layer. Shape raw data into models that people can use, so the business gets answers. Build and maintain reporting that ties the numbers to how the companies operate.
• Take ownership of the system. Working alongside current technical leadership, take over its development and day-to-day maintenance.
• Technical foundations. You are comfortable with SQL and a modern data stack, building ELT pipelines, modeling data in a cloud warehouse, and working in code rather than only in BI tools.

Who We’re Looking For
This is a build role with real ownership from day one and a clear path to broader responsibility:

• A data or analytics engineer who has built or substantially contributed to data pipelines or a warehouse and wants to own one end to end.
• A software engineer who has gravitated toward data infrastructure and wants a system to call their own.
• A technically strong analyst who has outgrown spreadsheets and BI tools and has started building the pipelines behind them.
• A quick learner who can work with the Strategy & Corporate Development team to translate user requirements from the CEO and AAG Leadership Team into code.

What will make someone thrive here is less about background than disposition:

• An ownership instinct. You treat the system as yours, including the highlights of new module releases and the unglamorous maintenance that keeps it trustworthy.
• Comfort with ambiguity. You make progress before every requirement is defined, and you ask the right questions as you go.
• A bias toward solutions that work. You take an 80/20 approach to get to solutions efficiently, then refine and harden where needed.

Skills, software and tools
Nexus runs on Azure. Fivetran lands data from the group’s ERP systems into Databricks, where a medallion model (bronze, silver, gold) governed by Unity Catalog is built in SQL and Python and deployed from GitHub. The gold layer is mirrored nightly into Azure PostgreSQL and served through an Entra gated web portal.

The essentials below are the foundations. Everything under nice to have is something you can pick up here. If you meet most of the essentials, apply: we are hiring for trajectory, not for a checklist.

Essential: SQL · Python · Azure · Databricks · Dimensional modeling · ELT Pipelines · CI/CD and Github / branching · AI-native development and experience with Codex or Claude Code

Nice to have: Finance and accounting literacy · ERP systems · Manufacturing data / process experience

This role can be remote in the U.S. (Eastern or Central time zone required) or in person at one of our locations (Stevensville, Michigan (US), Devon (UK), or Strathaven (Scotland)). The role will also require periodic (<10%) domestic and international travel.