Business Intelligence Specialist

1 month ago


Croydon, Greater London, United Kingdom Stott and May Full time
Job Title: Business Intelligence Specialist

Overview
At Stott and May, we're seeking a talented Data Analyst to join our team. As a key member of our business intelligence unit, you'll play a crucial role in designing, developing, and optimizing SQL solutions to address business needs.

Key Responsibilities:
  • Develop and optimize SQL queries and stored procedures for effective data retrieval, reporting, and manipulation.
  • Analyse and enhance database performance using indexing, query optimization, and other techniques.
  • Collaborate with third-party vendors to integrate effective data solutions, reducing manual data processing.
  • Automate database tasks such as data imports/exports and scheduled jobs to improve workflow efficiency.
  • Perform data analysis and provide insights using SQL, Python, and Power Platform.

Tech Stack:
The data infrastructure is fully cloud-based, utilising an Azure SQL data warehouse that combines data from various sources. Reporting tools include the Power Platform and Excel, with plans for future integration of Python, GIS, and other technologies to enhance data solutions.

Essential Skills, Knowledge, and Experience:
  • Bachelor's degree (minimum 2:1) in a numerate field.
  • At least 2 years of experience in SQL.
  • Intermediate proficiency in Microsoft Office Suite (Excel, Word, PowerPoint).

About Salary:
We offer a competitive salary of £45,000 plus bonus and benefits.

  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Company Overview: Aggregate Intelligence is a leading provider of cutting-edge data and business intelligence solutions. We serve top-tier brands in the travel and hospitality market, offering data-driven insights that optimize business strategies.About the Role: We are seeking a highly motivated Data Intelligence Marketing Strategist to join our dynamic...


  • Croydon, Greater London, United Kingdom C2 Recruitment Ltd Full time

    Job Title: Business Intelligence SpecialistWe are seeking a skilled Business Intelligence Specialist to join our Supply Chain Administrative team at C2 Recruitment Ltd.The successful candidate will be responsible for processing, checking, verifying and consolidating data received from audit staff and preparing reports. They will also check audit information...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Job Title: Senior Campaign Marketing ManagerWe are a leading data intelligence company that provides cutting-edge solutions for the travel and hospitality industry.The successful candidate will play a pivotal role in executing our marketing strategy by managing email campaigns, creating engaging content, social media channels, and partnerships.This role...


  • Croydon, Greater London, United Kingdom Going Forward into Employment Full time

    About the RoleGoing Forward into Employment is seeking a highly skilled Intelligence Operations Specialist to join its team. This exciting opportunity will see you work closely with HMRC, Border Force, and the Department of Health and Social Care to drive enforcement and disrupt organised crime.The successful candidate will be responsible for collating,...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Campaign Marketing Manager: At Aggregate Intelligence, we're looking for a skilled Campaign Marketing Manager to lead our marketing efforts. This individual will be responsible for developing and executing marketing campaigns aligned with our business objectives. Key tasks include ensuring consistency in brand messaging and visual identity across all...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Job Title: Senior Campaign Marketing ExecutiveAggregate Intelligence is seeking an experienced Senior Campaign Marketing Executive to join our fast-growing team. As a key member of our marketing department, you will be responsible for developing and executing marketing campaigns that drive results and exceed marketing goals.About the Role:In this role, you...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Senior Campaign Marketing Manager Job DescriptionAt Aggregate Intelligence, we're seeking a highly skilled Senior Campaign Marketing Manager to join our team. This role offers an excellent opportunity to drive marketing success and exceed goals.Key Responsibilities:Develop and execute marketing campaigns aligned with business objectives, leveraging expertise...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Job Title: Marketing Operations ManagerAggregate Intelligence is seeking a skilled Marketing Operations Manager to join our team. As a key member of our marketing department, you will be responsible for optimizing our marketing operations and improving overall efficiency.About the Role:In this role, you will work closely with our internal teams to identify...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    Job Title: Marketing StrategistLocation: Remote or HybridWe are seeking a highly motivated Marketing Strategist to join our dynamic team at Aggregate Intelligence, Inc. As the successful candidate, you will play a pivotal role in executing the tactical elements of our marketing strategy.The ideal candidate will have a minimum of 3 years' experience in a...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    We are Aggregate Intelligence, a leading data intelligence company offering cutting-edge solutions for the travel and hospitality market. Our team serves top-tier brands, providing data-driven insights to optimize business strategies.The Senior Campaign Marketing Manager will play a pivotal role in executing the tactical elements of our marketing strategy....


  • Croydon, Greater London, United Kingdom 02 Reed Specialist Recruitment Ltd Full time

    Business Support and Administration Recruitment OpportunityWe are seeking a highly skilled Business Support and Administration Recruitment Specialist to join our team at Reed Specialist Recruitment Ltd in Croydon. As a key member of our team, you will be responsible for sourcing and assessing suitable candidates for vacancies, ensuring a perfect match...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    At Aggregate Intelligence, we are seeking a highly skilled Digital Marketing Strategist to join our team. As a Senior Campaign Marketing Manager, you will be responsible for developing and executing marketing campaigns that drive business growth.Your key responsibilities will include managing email campaigns, overseeing content creation, social media...


  • Croydon, Greater London, United Kingdom Remote Choice Full time

    About the Position:We are seeking an accomplished Business Development Specialist to join our team at Remote Choice and contribute to driving business growth.Job Description:The ideal candidate will be responsible for identifying, pursuing and closing new business opportunities to drive revenue growth through lead generation and sales...


  • Croydon, Greater London, United Kingdom Aggregate Intelligence Full time

    As a Senior Campaign Marketing Manager at Aggregate Intelligence, you will be responsible for developing and executing marketing campaigns that drive business growth. Your key responsibilities will include managing email campaigns, overseeing content creation, social media management, and building impactful partnerships.To succeed in this role, you will need...


  • Croydon, Greater London, United Kingdom HMRC Full time

    Director of Knowledge Analysis & IntelligenceAs a Director of Knowledge Analysis & Intelligence, you will play a crucial role in driving HMRC's strategic decision-making process. You will lead a team of analysts in producing high-quality research, analysis, and evaluation to inform policy and operational decisions. Your expertise will be essential in driving...


  • Croydon, Greater London, United Kingdom Janes Full time

    Janes is a leading provider of open-source intelligence solutions, empowering militaries, governments, and defence companies to make informed decisions. With over 120 years of expertise, our tradecraft combines human-machine teaming to deliver assured data across various domains.Our cutting-edge data model creates a framework of interconnected defence...


  • Croydon, Greater London, United Kingdom C2 Recruitment Ltd Full time

    Company OverviewC2 Recruitment Ltd is a leading provider of supply chain solutions, working closely with our clients to optimize their administrative processes.Salary and BenefitsThe successful candidate will receive a competitive salary of £24,500 per annum, reflecting the importance of this role in our organization.Job DescriptionWe are seeking an...


  • Croydon, Greater London, United Kingdom Going Forward into Employment Full time

    Going Forward into Employment's Risk and Intelligence Service is at the heart of HMRC compliance and enforcement activity. The purpose of the Intelligence team within RIS is to develop and enhance the intelligence picture of organised crime and serious fraud impacting HMRC.We are seeking Source Handlers to support the use and management of CHIS and HUMINT...


  • Croydon, Greater London, United Kingdom Adecco UK Limited Full time

    Job DescriptionWe are seeking a highly skilled and experienced HR professional to join our team as a Business Transformation Lead. This is a critical role that requires a strong understanding of organisational design, workforce planning, and talent management. The successful candidate will have a proven track record of delivering complex change programmes...


  • Croydon, Greater London, United Kingdom EcoPlanet Green Operations GmbH Full time

    EcoPlanet Green Operations GmbH is seeking a Business Development Analyst to join our team.The successful candidate will be responsible for analyzing sales data to identify trends and patterns, developing reports to inform business decisions, and implementing process improvements to increase sales efficiency.Key Responsibilities:Analyze sales data to...