Data engineer

Location: Hybrid – 1 day per fortnight in office (Wilmslow HQ)

Salary: Competitive

We are The Citation Group - a collective of businesses dedicated to supporting small and medium-sized enterprises across a range of essential services. We know that running a business means juggling a lot. Our mission is to ease these pressures by providing expertise, guidance, and solutions that enable business leaders to focus on what they do best. From HR and Health & Safety to Cybersecurity, E-Learning, and ISO compliance, we’ve got you covered.

Citation has achieved strong growth through a combination of organic expansion and strategic acquisitions, continually broadening our expertise, services, and reach to create a one-stop shop that supports businesses across the UK, Canada and Australia.

The role

The Citation Group are looking to build out their data and AI 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. Work with the Head of Data Engineering to build and maintain the data warehouse foundations which support all business units and new AI initiatives.

We’re looking for an individual who has experience with scaling Data Modelling/Engineering processes with robust pragmatic solutions. You’ll work alongside the BI/Reporting, Data Science, AI and Data Governance teams to implement the group wide data warehousing strategy.

• Build and maintain ETL pipelines
• Manage and maintain the Group Data Warehouse
• Data platforms administration
• Ensure relevant technical documentation is in place

About You

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 writing, troubleshooting, and debugging advanced SQL queries
• Outstanding analytical and problem-solving skills
• Experience working with ETL/ELT, and reporting and analytic tools
• Experience designing data warehouse technical architectures and infrastructure components
• Programming experience in Python

Skills and experience we’d love you to have… But if not?

We’ll help you get there.

• Understanding of cloud computing security concepts
• Experience in relational cloud based database technologies like Snowflake, BigQuery, Redshift
• Experience in open source technologies like Spark, Kafka, Beam
• Good understanding of Cloud providers – AWS, Microsoft Azure, Google Cloud
• Familiarity with DBT, Delta Lake, Databricks
• Experience working in an agile environment
• Experience working with AI tools (Claude code, Cortex etc)

Perks

25 Days of Holiday + 8 Bank Holidays: we’re talking sun-soaked beaches, snow-capped mountains, or simply your favourite cozy spot at home. Take your well-deserved break with 25 days of holiday, plus those cherished bank holidays.

Birthday Bliss: Your birthday isn’t just another day on the calendar; it’s YOUR day! Enjoy it in style with a day off, because at Citation, we believe in celebrating YOU.

Post-Wedding Bliss: Newlyweds, we’ve got something special for you too! Extra weeks of holiday to bask in the glow of post-wedding happiness.

Growing Families: We’re all about supporting our Citation family, and that includes expectant parents. Vouchers and special perks await to celebrate the newest addition to your family.

Healthcare cash plan: Your well-being is our priority. That’s why we offer private healthcare to ensure your peace of mind and keep you feeling your best.