Kanbrick Logo

Kanbrick

Data Engineer

Posted 8 Days Ago
Remote
Hiring Remotely in United States
Entry level
Remote
Hiring Remotely in United States
Entry level
Build and own AAG’s consolidated data warehouse, including production-grade infrastructure, ELT pipelines, dimensional models, and reporting layers. Integrate data from ERP, CRM, and manufacturing systems into Databricks on Azure, maintain reliable data flows, and support business decision-making across the organization. Collaborate with leadership to translate requirements into code, while managing system development, maintenance, documentation, and continuous improvement.
The summary above was generated by AI

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.

Requirements

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.

Similar Jobs

15 Hours Ago
Remote or Hybrid
CA, USA
123K-223K Annually
Senior level
123K-223K Annually
Senior level
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Build and maintain sales compensation systems, data pipelines, integrations, data models, and commission calculation logic. Translate compensation plans into tested technical configurations, ensure reconciliation and historical traceability, and implement access controls, audit trails, monitoring, and release practices. Partner with Sales Compensation Operations, Finance, Payroll, and technical teams to deliver accurate, explainable commission results.
Top Skills: APIsCaptivateiqCloud Data WarehousesLookerExcelPigmentSalesforceSpiffSQLXactly
Yesterday
In-Office or Remote
CA, USA
123K-223K Annually
Senior level
123K-223K Annually
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Build and maintain the technical foundation for sales compensation, including commission systems, integrations, data pipelines, calculation logic, data models, testing, access controls, audit trails, reconciliation, and release practices. Partner with Sales Compensation Operations, Finance, Payroll, and technical teams to implement approved compensation plans and ensure accurate, explainable, reproducible commission results.
Top Skills: Access ControlsAPIsAudit TrailsAutomated TestingData ModelingData PipelinesExcelLookerPigmentSalesforceSQLVersion Control
2 Days Ago
Remote
US
106K-170K Annually
Junior
106K-170K Annually
Junior
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Build and maintain scalable production data pipelines and cloud data infrastructure. Ensure data quality, observability, lineage, governance, and cost-efficient performance. Develop data platform tooling, semantic and metrics layers, and enterprise data models supporting analytics, reporting, AI applications, and operational decisions. Collaborate with Analytics, Engineering, Product, operations, and business stakeholders while contributing to architecture, code reviews, testing, and technical standards.
Top Skills: AirflowAWSAzureBigQueryClaudeDbtDelta LakeDockerGCPGithub CopilotJavaPythonRedshiftScalaSnowflakeSnowflake Cortex AiSQLTerraform

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account