Senior Data Engineer

ZipRecruiter; Wilmslow; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A business solutions provider is looking for a Data Engineer to enhance their data capabilities. The role involves designing, developing, and maintaining data migrations between internal systems, with a strong emphasis on Python programming and ETL processes. The ideal candidate will engage with stakeholders across departments and ensure robust data pipelines. The company offers a hybrid work model based in Wilmslow with competitive perks including generous holiday and healthcare benefits.

Benefits

25 Days of Holiday plus 8 Bank Holidays

Birthday off

Extra holiday for newlyweds

Family support vouchers

Healthcare cash plan

Qualifications

• Proficient in Python programming for ETL processes.
• Experience writing and troubleshooting SQL queries and debugging.
• Outstanding analytical and problem-solving skills.

Responsibilities

• Designing, developing, and maintaining data migrations between systems.
• Collecting and documenting data requirements.
• Develop and maintain ETL/ELT pipelines for financial data.

Skills

SQL

Python programming

ETL/ELT processes

Analytical skills

Tools

Snowflake

AWS

Azure

BigQuery

Job description

About the job

Data Engineer

Location: Hybrid – Office (Wilmslow) and home

Salary: Competitive

We’re Citation Group. A group of businesses on a mission to make life easier for small and medium-sized companies. We get that running a business is tough. You’re spinning plates trying to keep your customers happy, stay on top of rules and regulations, look after your team, and somehow still grow.

That’s where we come in. From HR and Health & Safety to ISO certification, fire safety, and more—we’ve got your back. Our goal? To take the stress off business owners so they can focus on what they do best.

The role

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 Finance projects team. This role is instrumental in bridging financial systems, completing data migrations and engineering workflows to streamline data pipelines, ensure data integrity, and automate integrations.

The ideal candidate will be responsible for designing, developing, and maintaining robust data migrations between internal systems (ERP, billing, CRM, etc.) and finance tools to support the successful integration of acquisitions and system upgrades. A strong background in Python programming is , as the successful candidate will leverage Python to build and automate ETL (Extract, Transform, Load) processes, perform data validation and reconciliation, and develop custom scripts to facilitate data extraction and transformation between varied systems.

• Collecting and documenting data requirements.
• Pro-actively ensuring platform and pipelines are reliable and robust, fixing issues as they arise and proposing & implementing stability improvements
• Develop, deploy and maintain ETL/ELT pipelines to automate financial data collection, transformation, validation and exception reporting
• Actively engaging with stakeholder across multiple departments.
• 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…

• 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

Here’s a taste of the perks we roll out for our extraordinary team members

25 Days of Holiday, plus 8 Bank Holidays: We’re talking sun-soaked beaches, snow-capped mountains, or simply your favourite cosy 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.