Data Engineer

Alchemy Analytical Group (AAG) is building a consolidated data warehouse to provide reliable, current, usable data across its companies, sites, and systems. The Data Engineer will build and maintain production-grade data infrastructure, pipelines, and reporting, and take ownership of the system’s ongoing development and maintenance.

Responsibilities:

• 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

Requirements:

• 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
• 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
• SQL
• Python
• Azure
• Databricks
• Dimensional modeling
• ELT Pipelines
• CI/CD and Github / branching
• AI-native development and experience with Codex or Claude Code
• Finance and accounting literacy
• ERP systems
• Manufacturing data / process experience