At a Glance
- Tasks: Join our data engineering team to build and maintain top-notch data infrastructure.
- Company: Citation is a dynamic service provider focused on HR and Health and Safety for SMEs in the UK.
- Benefits: Enjoy 25 days holiday, gym discounts, healthcare, and more perks!
- Why this job: Be part of a supportive culture where your contributions truly matter and make an impact.
- Qualifications: Experience with data pipelines, AWS, Python, and strong analytical skills are essential.
- Other info: Hybrid work model with just one day in the office every two weeks.
The predicted salary is between 43200 - 72000 £ per year.
Location: Hybrid – 1 day per fortnight in the Wilmslow offices
Working hours: 0900 to 1730
The Role
Following recent investment, The Citation Group are looking to build out their data capabilities to be Best in Class. As such, a fantastic opportunity has arisen for a strong data engineer to work in the data engineering team, to expand and maintain the data infrastructure that provides the foundations from which our BI, Data Science and Operational Data teams deliver insights and revenue to the functions across the wider group.
We’re looking for an individual who has experience working with enterprise grade data pipelines and infrastructure, who can implement processes on our modern tech stack with robust, pragmatic solutions.
Responsibilities
- Develop and maintain ETL/ELT data pipelines using AWS services Data, Databricks and dbt
- Manage and optimize data storage solutions such as Amazon S3, Redshift, RDS, and DynamoDB
- Implement and manage infrastructure-as-code (IaC) using tools like Terraform or AWS CloudFormation
- Monitor and optimize the performance, cost, and scalability of data infrastructure
- Develop data access policies and implement security best practices for data in transit and at rest
- Support data ingestion from structured and unstructured sources, including APIs, streaming data, and batch loads
- Work closely with Data Scientists, Analysts, and Software Engineers to provide data access and tooling
The Person
We are looking for someone who can roll their sleeves up and ‘dig in’ with the rest of the team. In addition, the successful candidate should have:
- Excellent writing and communication skills with an attention to detail
- Experience designing data warehouse technical architectures and infrastructure components
- Experience deploying cloud data infrastructure services
- Programming experience in Python
- Experience writing, troubleshooting, and debugging advanced SQL queries
- Outstanding analytical and problem-solving skills
- Experience working with ETL/ELT, and reporting and analytic tools
Skills and experience we’d love you to have… But if not? We’ll help you get there:
- Understanding of cloud computing security concepts
- Proficiency with IaC tools like Terraform or CloudFormation
- Experience with workflow orchestration tools (e.g., Airflow, Dagster)
- Good understanding of Cloud providers – AWS, Microsoft Azure, Google Cloud
- Familiarity with DBT, Delta Lake, Databricks
- Experience working in Agile environments with tools like Jira and Git
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 colleague’s 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 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.
Contact Detail:
The Citation Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Engineer (Wilmslow)
✨Tip Number 1
Familiarise yourself with the specific AWS services mentioned in the job description, such as S3, Redshift, and RDS. Having hands-on experience or projects that showcase your skills with these tools will make you stand out during discussions.
✨Tip Number 2
Brush up on your Python programming skills, especially in relation to data engineering tasks. Being able to demonstrate your coding abilities through practical examples or previous work can significantly boost your chances.
✨Tip Number 3
Network with current employees or professionals in the data engineering field, particularly those familiar with Citation's culture. Engaging in conversations about their experiences can provide valuable insights and potentially lead to referrals.
✨Tip Number 4
Prepare to discuss your experience with ETL/ELT processes and how you've optimised data pipelines in past roles. Be ready to share specific challenges you faced and how you overcame them, as this will demonstrate your problem-solving skills.
We think you need these skills to ace Senior Data Engineer (Wilmslow)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly with AWS services, ETL/ELT processes, and programming in Python. Use specific examples to demonstrate your skills and achievements.
Craft a Compelling Cover Letter: Write a cover letter that reflects your passion for data engineering and your understanding of the role at Citation. Mention how your experience aligns with their needs and express your enthusiasm for contributing to their data capabilities.
Showcase Your Technical Skills: In your application, emphasise your experience with tools like Terraform, Databricks, and SQL. Provide examples of projects where you successfully implemented data pipelines or optimised data storage solutions.
Highlight Soft Skills: Don't forget to mention your communication skills and ability to work collaboratively. Citation values teamwork, so illustrate how you've effectively worked with others in previous roles to achieve common goals.
How to prepare for a job interview at The Citation Group
✨Showcase Your Technical Skills
Be prepared to discuss your experience with AWS services, ETL/ELT processes, and data storage solutions. Highlight specific projects where you've implemented these technologies, as this will demonstrate your hands-on expertise.
✨Communicate Clearly
Since excellent writing and communication skills are essential for this role, practice explaining complex technical concepts in simple terms. This will help you connect with the interviewers and show that you can collaborate effectively with non-technical team members.
✨Demonstrate Problem-Solving Abilities
Prepare to discuss past challenges you've faced in data engineering and how you resolved them. Use the STAR method (Situation, Task, Action, Result) to structure your answers and showcase your analytical skills.
✨Align with Company Culture
Research Citation's values and culture before the interview. Be ready to share examples of how your work ethic and attitude align with their emphasis on teamwork, support, and ownership. This will show that you're not just a fit for the role, but also for the company.