first-mile logo

SQL Analyst - Newark-on-Trent

first-mileNewark-on-Trent, England, United Kingdom
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Experience

Qualifications

Technical SkillsStrong proficiency in SQL, including complex queries, joins, aggregations, and window functions. Experience working with SQL data warehouses and large datasets. Ability to translate business requirements into technical specifications.

About the job

We are actively looking for a skilled SQL Analyst to play a pivotal role in the development, maintenance, and analysis of our SQL-driven data warehouse. The ideal candidate will be responsible for ensuring reliable data flows, maintaining the SQL infrastructure, and deriving actionable insights related to sales performance, pricing strategies, customer churn, product mix, and waste stream volumes. In addition, this role will facilitate the integration of data from newly acquired businesses, guaranteeing consistent reporting and scalable forecasting models based on historical data held within the SQL data warehouse.

 

Key Outcomes for the Role

  • Establish a robust SQL infrastructure and data warehouse.
  • Provide clear visibility into sales drivers such as pricing, churn, and client growth.
  • Implement forecasting capabilities utilizing historical SQL data.
  • Integrate data from new acquisitions to support uniform reporting across the organization.

 

Key Responsibilities / Accountabilities

SQL Data Warehouse & Infrastructure

  • Design and maintain SQL data warehouse structures to ensure dependable and scalable data access.
  • Develop and sustain SQL pipelines and data tables that bolster business intelligence and forecasting initiatives.
  • Guarantee data accuracy, consistency, and integrity across all reporting datasets.

Forecasting & Business Insights

  • Create and uphold forecasting models in SQL that utilize historical data stored in the data warehouse.
  • Assist in the forecasting of sales volumes, tonnage, and pricing by client, waste stream, location, and product/service type.
  • Contribute to building scalable forecasting frameworks that enable the business to anticipate future demand and operational necessities.

Data Integration & Acquisitions

  • Support the assimilation of new acquisitions into the SQL data warehouse.
  • Develop new SQL data structures and datasets to incorporate operational and sales data from newly acquired entities.
  • Ensure standardized reporting and forecasting across both legacy and newly acquired businesses.

Reporting & Collaboration

  • Collaborate closely with commercial, finance, and operations teams to translate business queries into SQL analyses.
  • Construct and maintain SQL datasets utilized by BI dashboards and reporting tools.

About first-mile

first-mile is a dynamic company focused on leveraging data to drive business decisions and enhance operational efficiencies. We prioritize innovation and are committed to integrating cutting-edge technology into our processes. By joining our team, you will become part of a forward-thinking organization that values collaboration and continuous improvement.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.