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.
