Alpha Resources LLC is building Nexus, a consolidated data warehouse designed to unify reliable data and reporting across Commercial, Manufacturing, Finance, Marketing, and other business functions. In this hybrid role, you will help create and operate production-grade data pipelines that keep the warehouse dependable and the reporting layer aligned with evolving business needs.
The preferred work location is Stevensville, Michigan, with options for remote candidates based in the U.S., UK, or Ireland. Some travel is expected, and the exact expectations are outlined in the location and travel section below.
What you will do
- 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 changes to source systems.
- Translate business requirements into practical technical solutions.
- Document processes and maintain code using established development workflows.
Required qualifications
- Bachelor's degree.
- 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.
Tools and technologies
- SQL
- Python
- Databricks
- Git
- GitHub
- CI/CD
Benefits
- 401(k) and 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible schedule
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
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.
Location and travel
- Preferred locations: Stevensville, Michigan; UK or Scotland.
- Remote candidates based in the U.S., UK, or Ireland will be considered.
- Travel is occasional and expected to be less than 10%.
- Candidates must have authorization to work in their country of employment and be able to travel to other countries.
- Willingness to travel: 25% (Preferred).
Additional application details
- Candidates will be asked to complete a cognitive ability test. You must confirm willingness to take the test as part of the recruitment process.
Salary: USD 80,000 - 115,000 per yearly.