Job Title: Apprentice Data Analyst
Reporting To: Operational Data Manager
Location: Hybrid - 1 day per week in Wilmslow
Hours of Work: 09:00 - 17:30 or in line with business needs.
Salary: Dependent on Experience
The Role
We are looking for a motivated and eager Apprentice Data Analyst to join our data team. As an apprentice, you will have the opportunity to develop your analytical skills, learn data tools, and gain real-world experience in analyzing data to help drive business decisions. This is a hands-on learning role where you will support the team in collecting, processing, and analyzing data while receiving mentorship and training.
Responsibilities
- Assist in extracting and selecting data from databases for targeted marketing campaigns, ensuring accuracy and alignment with business objectives.
- Support the team in data segmentation, ensuring the correct audience is targeted for each campaign.
- Learn and utilize tools like SQL, Excel, and other data management platforms to execute selections and manage large datasets.
- Collaborate with senior analysts to refine customer data selections for direct marketing, digital campaigns, and other initiatives.
- Ensure data quality by cleaning, validating, and preparing datasets for selections.
- Assist in producing reports and visualizations to track the performance and effectiveness of data selections and marketing campaigns.
- Work with various teams, including marketing and sales teams to understand campaign requirements and deliver accurate and timely data selections.
- Stay updated on best practices in data selection, privacy regulations, and data management.
- Help maintain accurate customer databases and ensure compliance with data governance and privacy standards (GDPR, etc.).
- Support the team with ad-hoc data selection requests from various departments.
The Person
- Strong interest in data analytics and marketing.
- Basic understanding of data analysis concepts, including statistical methods and data visualization.
- Proficiency with Microsoft Excel (e.g., formulas, pivot tables, VLOOKUP).
- Familiarity with basic SQL queries or willingness to learn.
- Analytical mindset with strong problem-solving skills.
- Attention to detail and ability to work with large datasets.
- Good communication skills, both written and verbal.
- Ability to manage time and prioritize tasks effectively.
Desirable skills:
- Familiarity with data privacy regulations (e.g., GDPR, CCPA).
- Basic understanding of customer relationship management (CRM) systems.
- Exposure to data visualization tools (e.g., Power BI, Tableau).
About Us
We are Citation. We are far from your average service provider. Our colleagues bring their brilliant selves to work every day and we create an environment where they can shine. We are a nice bunch. We don't do office politics or "that's not my job". We listen, support and take ownership.
We have been proudly delivering valuable HR and Health and Safety services to SMEs across the UK for over 20 years. Passionate about service, we're on a mission to revolutionise our colleagues' and client's experience by employing brilliant people who are experts at what they do and smile whilst they are doing it.
Working for Citation you will have access to 25 days holiday, plus your birthday off work, gym membership discount, healthcare, childcare vouchers, the opportunity to purchase extra leave, pension contributions and more.
It's a great place to work because of the people we employ. Fun and professional, we want likeminded individuals who love to love their job (no 'mood hoovers' here thanks!) and want the Company to succeed.
So, if our culture sounds like a good fit for you and you want to be part of our success story, then send us your details.
Hit Apply now to forward your CV.