Data Engineer

Alpha Resources, LLC; Michigan; Hybrid; USD 80,000 - 115,000; Full time

Job summary

Alpha Resources, LLC is seeking a Data Engineer to own and evolve Nexus, a consolidated data warehouse supporting a multi-geo organization. You will build production pipelines, model data, and deliver analytics across Commercial, Manufacturing, and Finance functions.

You will work with SQL, Python, Databricks, and ELT concepts to translate business needs into scalable solutions. Remote and on-site options are available, with occasional interstate travel as needed.

Qualifications

• Experience building and maintaining production data pipelines or data warehouses.
• Strong SQL and Python skills, with hands-on Databricks experience.
• Knowledge of dimensional modeling, ELT pipeline design, Git/GitHub, and CI/CD workflows.
• Experience developing reporting and translating business requirements into technical solutions.
• Familiarity with AI-assisted development tools such as Codex or Claude Code.

Responsibilities

• Build and maintain reliable, production-grade data pipelines and warehouse infrastructure.
• Integrate data from ERP, CRM, and manufacturing systems.
• Develop data models, reporting layers, and business-ready analytics.
• Monitor system performance, troubleshoot issues, and manage source-system changes.
• Translate business needs into practical technical solutions.
• Document processes and maintain code using established development workflows.

Skills

SQL

Python

Dimensional modelling

ELT design

Git/GitHub

CI/CD workflows

Reporting development

AI-assisted development tools

Education

Bachelor's degree in Computer Science, Data Science, Engineering, Mathematics, or related field

Tools

Databricks

Fivetran

Azure PostgreSQL

Microsoft Entra ID

Job description

Alpha Resources | Stevensville, Michigan (Preferred On-Site) or Remote

Salary: $80,000–$115,000, depending on experience

Build and own a data warehouse supporting a $100M+ group of scientific and life science manufacturers across the U.S., Canada, UK, and Ireland.

About the Role

Alpha Resources is part of a growing group of 13 scientific consumables businesses building shared systems and technology to support continued growth. As our Data Engineer, you will lead the development and ongoing maintenance of Nexus, our consolidated data warehouse, creating reliable data and reporting solutions across Commercial, Manufacturing, Finance, Marketing, and other business functions.

Key Responsibilities

• Build and maintain reliable, production-grade data pipelines and warehouse infrastructure.
• Integrate data from ERP, CRM, and manufacturing systems.
• Develop data models, reporting layers, and business-ready analytics.
• Monitor system performance, troubleshoot issues, and manage source-system changes.
• Translate business needs into practical technical solutions.
• Document processes and maintain code using established development workflows.

Required Qualifications

• Experience building and maintaining production data pipelines or data warehouses.
• Strong SQL and Python skills, with hands-on Databricks experience.
• Knowledge of dimensional modeling, ELT pipeline design, Git/GitHub, and CI/CD workflows.
• Experience developing reporting and translating business requirements into technical solutions.
• Familiarity with AI-assisted development tools such as Codex or Claude Code.

Preferred Qualifications

• Degree in Computer Science, Data Science, Engineering, Mathematics, or a related field.
• Experience owning a data platform end to end.
• Databricks or Microsoft data engineering certification.
• Experience with Fivetran, Azure PostgreSQL, or Microsoft Entra ID.
• Familiarity with ERP, CRM, manufacturing, finance, or multi-site business operations.

What We're Looking For

We're looking for someone who takes ownership, works independently through ambiguity, focuses on practical solutions, and communicates technical information clearly to both technical and nontechnical teams.

Candidates may come from data engineering, analytics engineering, software engineering, or technical analyst backgrounds.

Location & Travel

Preferred locations are Stevensville, Michigan; Devon, UK; or Strathaven, Scotland. Remote candidates based in the U.S., UK, or Ireland will also be considered. Travel is occasional and expected to be less than 10%. Candidates must have authorization to work in their country of employment.