SQL Data Warehouse & Forecasting Analyst – Hybrid

Company: First Mile
Apply for the SQL Data Warehouse & Forecasting Analyst – Hybrid
Location: Newark on Trent
Job Description:

We areseeking anexperiencedSQL Analyst to support the development, maintenance, and analysis of our SQL-based data warehouse. The analyst willensureaccuratedataflows,maintainSQL infrastructure, and generate insights related to sales performance, pricing, churn, product mix, and waste stream volumes.The role will also support the integration of data from new acquisitions, ensuring consistent reporting and scalable forecasting models based on historical data stored in the SQL data warehouse.

Key Outcomes for the Role

  • Reliable SQL infrastructure and data warehouse.
  • Clear visibility into sales drivers including pricing, churn, and client growth.
  • Forecasting capabilities based on historical SQL data.
  • Integrated data from new acquisitions supporting consistent reporting across the business.

KeyResponsibilities /Accountabilities

SQL Data Warehouse & Infrastructure

  • BuildandmaintainSQL data warehouse structures to ensure reliable and scalable data access.
  • Develop andmaintainSQL pipelines and data tables supporting business intelligence and forecasting.
  • Ensure data accuracy, consistency, and integrity across all reporting datasets.

Forecasting & Business Insights

  • Develop andmaintainforecasting models in SQL using historical data stored in the data warehouse.
  • Support forecasting of sales volumes, tonnage, andpricingby
  • Client
  • Waste stream
  • Location
  • Product/service type
  • Help build scalable forecasting frameworks that allow the business to project future demand and operational requirements.

Data Integration & Acquisitions

  • Support the integration of new acquisitions into the SQL data warehouse.
  • Develop new SQL data structures and datasets to incorporate newlyacquiredoperational and sales data.
  • Ensure standardized reporting and forecasting across legacy and newlyacquiredbusinesses.

Reporting & Collaboration

  • Work closely with commercial, finance, and operations teams to translate business questions into SQL analysis.
  • Create andmaintainSQL datasets used by BI dashboards and reporting tools.

Technical Skills

  • Strongproficiencyin SQL (complex queries, joins, aggregations, window functions).
  • Experience working with SQL data warehouses and large datasets.
  • Experience building data pipelines and data models.

Other Skills

  • Strong attention to detail and data accuracy.
  • Ability to communicate clearlyand simplyto non-technical stakeholders.
  • Experience working with multi-entity or acquisition-driven businesses is beneficial.
  • Expertproficiencyin;
  • Power BI, Excel (Power Query, Power Pivot).
  • ERP/BI stack: e.g., MS Dynamics / NetSuite / Salesforce.
  • Collaboration: Microsoft 365, Teams, SharePoint.
  • Desirable:Experience from comparable sectors.

Cultural Fit

  • Wanting to work somewhere with a purpose – we are passionate about reducing climate impact through sustainable waste management and the circular economy.
  • Comfortable in a dynamic, growth-stage business that is scaling fast.

Why Join Us?

Competitive salary and benefits package

Hybrid working options

25 days annual leave per year, plus bank holidays

Comprehensive career development and training programs

Subsidised canteen and gym memberships

Employee Assistance Programme

Company Pension scheme and Life Assurance scheme

On-site parking

#J-18808-Ljbffr…

Posted: March 27th, 2026