Senior Forecasting Administrator

The Role At HelloConnect, you will be part of a dynamic team in Inoza tower, BGC that embraces innovation and leverages advanced technology to create exceptional experiences. Our culture is built on collaboration, continuous learning, and a commitment to excellence. You’ll have the opportunity to work on impactful projects, develop your skills, and grow within a supportive environment that values diverse perspectives and experiences. In this role, you will take on a key responsibility in ensuring accurate and reliable BAU forecasts through SQL-based data validation, investigation of discrepancies and anomalies, analytical reporting, and the development of standardized processes to improve forecasting efficiency and support future automation. contributing to our ongoing efforts to drive business success and enhance customer satisfaction. We’re looking for passionate individuals who can bring their unique skills and ideas to the table. Even if you don't meet every requirement but believe you’d excel in this role, we’d love to hear from you! What you’ll do • Develop, maintain, and execute SQL queries to validate forecast data, ensuring the completeness, accuracy, and consistency of forecast inputs and outputs. • Conduct routine and ad hoc data quality checks to identify discrepancies, unusual movements, and forecast anomalies. • Investigate forecast-related issues by analysing datasets, comparing historical trends, and identifying potential root causes. • Assess the impact of identified issues, track recurring problems, recommend corrective actions, and escalate complex issues or material forecast risks when required. • Identify opportunities to standardise validation checks, streamline manual processes, and improve the efficiency and consistency of forecasting operations. • Develop reusable SQL queries and document validation procedures to reduce manual effort and minimise rework. • Support the testing and validation of new or updated forecasting processes and automated checks, and identify opportunities for automation to improve efficiency and scalability. • Support the preparation of analysis for forecast reviews and other operational reporting requirements. • Analyse historical trends and forecast movements to help identify and explain potential issues. • Prepare BAU forecasts when needed, using established methodologies and tools, and following guidance provided by Forecast Analysts. • Apply agreed assumptions, adjustments, and processes accurately and consistently. • Perform reasonableness checks on forecast outputs and investigate unexpected movements before submission. • Work closely with Forecast Analysts and other relevant stakeholders to support reliable forecast delivery. • Communicate investigation findings, data limitations, and forecast risks clearly and promptly. Key Skills and Experience Technical skills • • Working knowledge of SQL • Strong Excel or Google Sheets skills, including formulas, data manipulation, reconciliation, and reporting. • Experience working with large datasets and identifying data quality issues. • Ability to develop repeatable checks and produce clear, reliable analytical outputs. Analytical skills • • Strong attention to detail and a methodical approach to data validation. • Ability to investigate discrepancies, identify patterns, and determine likely root causes. • Ability to interpret historical trends and explain movements in forecast data. • Good numerical reasoning and the ability to quantify the impact of data issues. What you’ll bring • Relevant experience in data analysis, forecasting support, reporting, business operations, or a related field. • Demonstrated experience writing SQL queries for data analysis or validation. • Experience conducting data q