Commercial Data & Excel Wizard in Norwich

Commercial Data & Excel Wizard in Norwich

Norwich Full-Time 36000 - 60000 £ / year (est.) Hybrid
B

At a Glance

  • Tasks: Design and maintain ELT pipelines, manage data governance, and lead a dynamic data team.
  • Company: Join BizClik Media, a leader in B2B digital publishing and innovative events.
  • Benefits: Enjoy gym membership, flexible working, 20 days leave plus your birthday off, and more!
  • Other info: Collaborative culture with opportunities for professional development and networking.
  • Why this job: Be the driving force behind data operations and make a real impact on business growth.
  • Qualifications: Experience in data engineering, strong SQL skills, and a passion for audience insights.

The predicted salary is between 36000 - 60000 £ per year.

About BizClik Media

BizClik Media is a global leader in B2B digital publishing, media and events, creating platforms that connect the world’s most influential leaders, brands and ideas. Our digital platforms and flagship global events, Sustainability LIVE, Procurement & Supply Chain LIVE, AI LIVE, FinTech LIVE, Data Centre LIVE, and more, bring together C-suite executives, innovators and change-makers to shape the conversations that move industries forward.

Purpose of Role

Based in Norwich as our Data Manager, you are the nerve‑centre of BizClik’s data operations: every record that leaves a silo and lands in BigQuery travels a path you design, monitor, and improve. Reporting to the Director of Technology and leading a two‑person data team, you architect resilient ELT pipelines in GCP Dataflow, design warehouse schemas that reflect how the business operates, and document not just the fields but the full context – what the data represents, who uses it, and how it connects to real‑world activity – so when questions land, you already know the answers.

Your remit spans governance – access controls, retention rules, GDPR‑safe handling – and the technical operations needed to keep data flowing and reliable, from pipeline monitoring to resolving issues when things break. You’re hands‑on: writing SQL, tuning Dataflow jobs, tracking anomalies. You’re also strategic – prioritising the backlog, coaching the team, and road‑mapping the next integration, schema upgrade, or governance control to keep pace with growth.

Responsibilities

  • Design and maintain ELT pipelines: Develop robust ELT pipelines in GCP Dataflow and BigQuery to ensure seamless data flow from Salesforce, Piano.io, Apollo, and other sources.
  • Architect data warehouse schemas: Create and optimise warehouse schemas that align with business operations, enabling efficient data retrieval and analysis.
  • Comprehend and document data context: Delve into the meaning behind each data point, understanding its origin, purpose, and how it serves various business functions. Document this context to facilitate clarity and informed decision‑making across teams.
  • Understand and manage audience data: Gain a deep understanding of audience data, including demographics, behaviours, and engagement patterns, to ensure data strategies effectively support audience targeting and personalisation efforts.
  • Implement and enforce data governance: Establish and uphold data governance policies, including access controls, retention schedules, and compliance with regulations like GDPR, ensuring data integrity and security.
  • Monitor and troubleshoot data systems: Continuously oversee data pipelines and systems, promptly addressing anomalies and issues to maintain data accuracy and availability.
  • Lead and mentor the data team: Manage a two‑person data team, providing guidance, setting technical direction, and fostering professional growth.
  • Collaborate with business units: Engage with campaign and sales teams to understand their data needs, ensuring that data solutions are tailored to support their objectives effectively.
  • Plan and execute data initiatives: Develop and implement plans for integrating new data sources, refining schemas, and enhancing data governance frameworks to support business growth.

About You

  • Hands‑on data engineer: You have a strong background in building and maintaining ELT pipelines, particularly within GCP environments, ensuring data flows are efficient and reliable.
  • Data context expert: Beyond technical structures, you understand the stories the data tells – its origins, its implications, and its relevance to different business units.
  • Audience insight: You grasp the intricacies of audience data, recognising patterns and behaviours that inform strategic decisions across campaigns and sales initiatives.
  • Governance advocate: You implement and uphold data governance policies, ensuring data integrity, security, and compliance with regulations like GDPR.
  • Team leader: You lead by example, guiding your team with clear direction, fostering growth, and encouraging a culture of excellence.
  • Collaborative communicator: You work seamlessly with various departments, translating complex data concepts into actionable insights that drive business success.
  • Strategic planner: You’re forward‑thinking, always planning the next steps in data integration, schema evolution, and governance enhancements to support organisational growth.

What We Offer

  • Gym membership at Nuffield Health (post‑probation)
  • 20 days annual leave + your birthday off
  • Flexible hybrid working (Thursdays from home)
  • A culture first workplace that rewards ambition, integrity and innovation
  • Cycle to work scheme
  • Paid sickness leave
  • Enhanced maternity leave
  • Learning and development programme
  • Access to charity initiatives and team volunteering opportunities
  • Company wellbeing programme
  • Access to global C‑level networks through our platforms and events

Commercial Data & Excel Wizard in Norwich employer: BizClik

At BizClik Media, we pride ourselves on being a dynamic and innovative employer that thrives on creativity and collaboration. As a Campaign Project Manager, you'll be at the forefront of our fast-growing global media and events business, with clear opportunities for professional growth and the chance to engage with industry leaders and cutting-edge brands. Our vibrant work culture fosters ambition and accountability, ensuring that every team member plays a vital role in shaping the future of B2B engagement.

B

Contact Details:

BizClik Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Commercial Data & Excel Wizard in Norwich

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like BizClik!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Commercial Data & Excel Wizard at BizClik.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like BizClik.

✨Apply Directly through Our Website

When you find a suitable opening like Commercial Data & Excel Wizard at BizClik, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Commercial Data & Excel Wizard in Norwich

ELT Pipeline Development
GCP Dataflow
BigQuery
SQL
Data Warehouse Schema Design
Data Governance
GDPR Compliance

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at BizClik, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at BizClik. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at BizClik

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at BizClik!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.