Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support SQL data warehouse development and generate insights on sales performance and forecasting.
- Company: Join a purpose-driven company focused on sustainable waste management.
- Benefits: Enjoy competitive salary, hybrid work, 25 days leave, and career development.
- Why this job: Make a real impact in a fast-growing business while honing your SQL skills.
- Qualifications: Proficient in SQL with experience in data warehouses and pipelines.
- Other info: Dynamic environment with a strong focus on sustainability and growth.
The predicted salary is between 40000 - 50000 £ per year.
We are seeking an experienced SQL Analyst to support the development, maintenance, and analysis of our SQL‑based data warehouse. The analyst will ensure accurate data flows, maintain SQL 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.
Key Responsibilities / Accountabilities
SQL Data Warehouse & Infrastructure
- Build and maintain SQL data warehouse structures to ensure reliable and scalable data access.
- Develop and maintain SQL pipelines and data tables supporting business intelligence and forecasting.
- Ensure data accuracy, consistency, and integrity across all reporting datasets.
Forecasting & Business Insights
- Develop and maintain forecasting models in SQL using historical data stored in the data warehouse.
- Support forecasting of sales volumes, tonnage, and pricing by 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 newly acquired operational and sales data.
- Ensure standardized reporting and forecasting across legacy and newly acquired businesses.
Reporting & Collaboration
- Work closely with commercial, finance, and operations teams to translate business questions into SQL analysis.
- Create and maintain SQL datasets used by BI dashboards and reporting tools.
Requirements
Technical Skills
- Strong proficiency in 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 clearly and simply to non‑technical stakeholders.
- Experience working with multi‑entity or acquisition‑driven businesses is beneficial.
- Expert proficiency in; 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.
Benefits
- 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.
Why Join Us?
SQL Analyst - Newark in Newark on Trent employer: First Mile | Certified B Corp
Contact Detail:
First Mile | Certified B Corp Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Analyst - Newark in Newark on Trent
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common SQL-related questions and scenarios. We recommend setting up mock interviews with friends or using online platforms to get comfortable with your responses.
✨Tip Number 3
Showcase your skills! Create a portfolio of your SQL projects or analyses. This can be a game-changer during interviews, as it gives potential employers a tangible look at what you can do.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are genuinely interested in joining our mission.
We think you need these skills to ace SQL Analyst - Newark in Newark on Trent
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL skills and experience relevant to the role. We want to see how you've built and maintained SQL data warehouses or pipelines, so don’t hold back on those details!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and how you can contribute to our mission of sustainable waste management. Keep it engaging and personal.
Showcase Your Technical Skills: We’re looking for strong SQL proficiency, so be sure to mention any complex queries, joins, or data models you've worked with. If you’ve got experience with Power BI or Excel, let us know how you’ve used these tools to generate insights!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at First Mile | Certified B Corp
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries, joins, and aggregations. Practising with real datasets can help you articulate your thought process when solving problems during the interview.
✨Understand the Business Context
Familiarise yourself with the company's mission and how they use data to drive decisions. Knowing about their focus on sustainable waste management will help you connect your skills to their goals, showing that you're not just a techie but also someone who cares about the bigger picture.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems related to sales performance or forecasting. Think of examples from your past experience where you've built SQL pipelines or maintained data accuracy, and be ready to explain your approach step-by-step.
✨Showcase Your Collaboration Skills
Since the role involves working closely with various teams, be ready to discuss how you've effectively communicated technical concepts to non-technical stakeholders in the past. Highlight any experiences where you’ve collaborated on projects, especially in dynamic environments.