Reporting Analyst

THE COMPANY 

With offices in Brighton and Skopje and a team in Serbia, Sopro provides sophisticated digital marketing services to hundreds of businesses, from innovative start-ups to global brands. 

As the UK’s leading B2B sales engagement service provider, with over 150 employees and backed by 10 years of multi-award-winning results, maturity and scale, Sopro offers a powerful and unique sales engagement proposition. Our relentless focus on innovation makes it an exciting time for both our teams at Sopro and our clients. 

Sopro is committed to providing an inclusive, rewarding and fun place to work and received a “Best Place to Work” award at the UK Business Awards 2021. 

THE ROLE  

Sopro is building a data infrastructure where the Data Warehouse (DWH) is the single source of truth for the business. The Reporting Analyst plays a key role in making that data accessible - translating structured, governed DWH data into clear, reliable reports and dashboards that Heads of and leadership use every day. 

This is a hands-on reporting role. You will maintain existing reports, build new ones to meet business needs, and write SQL and calculated measures where needed. You are a consumer of the DWH - working from data that has been prepared and structured by the engineering team - and your focus is on turning that data into something the business can act on. 

Assuming the role, you will be proficient in reporting and BI tools including Power BI, Excel, and similar platforms, choosing the right tool for the right output. And you will be AI-native in how you work - using Copilot, Claude and similar tools as default collaborators in your reporting workflow, not occasional helpers. 

KEY RESPONSIBILITIES 

• Maintain and develop reports and dashboards across business functions using Power BI, Excel, and other reporting tools 

• Build calculated measures and columns to support reporting requirements 

• Write SQL queries to understand, validate, and work with Data Warehouse data 

• Build AI into the reporting workflow — use LLMs (Claude, GitHub Copilot or similar) to accelerate SQL writing, validation, and documentation. Actively look for places where recurring reporting work can be partly automated, and bring proposals for where AI tooling could be worth investing in. 

• Work with the Head of Data and business stakeholders to understand reporting needs and translate them into clear, well-structured outputs 

• Ensure all reports are accurate, up to date, and clearly documented 

• Support the self-serve enablement programme — helping Heads of understand and use data independently, including through natural-language interfaces over the DWH where appropriate 

• Flag data quality issues or gaps to the engineering team where identified through reporting work 

• Maintain documentation of report logic, data sources, and metric definitions — using AI to keep documentation in sync with what's actually in production 

ABOUT YOU  

• 2–3 years of experience in a reporting, BI, or data analyst role 

• Proficient in Power BI — able to build and maintain dashboards independently 

• Strong working knowledge of Excel for data reporting and analysis 

• Comfortable writing SQL — for querying data, validating figures, and building measures 

• Familiarity with other BI or reporting tools is a plus 

• Good understanding of data warehouse concepts and working from structured data sources 

• AI-first by default. You write SQL, build dashboards, or draft documentation with AI being in the loop. You stay current on new AI tools and have a view on which ones are worth bringing into a reporting workflow. 

• Accuracy is non-negotiable — you double-check totals against source systems before publishing, and treat a report going out with the wrong number as a serious incident 

• Clear communicator, able to work with non-technical stakeholders to understand what they need and explain what the data does and doesn't say 

• Organised — comfortable managing multiple reporting requests in parallel and being honest about timelines 

ABOUT US 

We’re the people behind the prospects. For all the clever tech, what makes the Sopro service stand out is the people. As we like to tell our clients, we’re a team not a tool. 

Our values permeate Sopro Group through our behaviours, not only as people but across the business. 

We invest in our people, their development, our products and our working environment. We are ambitious, not only as a business but by encouraging passionate and imaginative collaboration. We are people who are proud of our identity and celebrate each other’s successes, whilst giving back to our local communities. We are open and transparent, with our clients and our people – each team member has a voice, and we ensure it is heard! 

WHAT WE OFFER 

At Sopro we invest in our people – they are what makes our company great and we work hard to make sure that everyone feels like a valued member of the team. 

Benefits and perks that we offer include: 

• Career progression plan - Well-structured career progression path supported by regular 360- degree feedback. 

• Company profit sharing - We believe in sharing in our success, as such we’ll reward your loyalty by sharing 10% of the company's net profit with employees. 

• Extended annual leave 

• Private healthcare insurance 

• Learning and Development – An environment where we encourage your personal and professional growth, additionally supported by mentorship, external training and certification when needed. 

• Hybrid working- 3 days from home, 2 days in the office, and if you want to come every day - you surely can! 

• Flexible national holidays: public holidays mean more time off, choose how and when to enjoy them each year.  

• Employee discount program; enjoy savings on everyday purchases in a variety of retail stores, restaurants, bookstores and more.   

• Wellbeing package adapted to the needs of our people. Regular sports, social activities, and lots of healthy snacks. 

• Your work matters - We have an open-door policy and value your opinion. Ideas are heard and genuinely put into practice.