Job Description
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:
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 preferred, 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.