About the jobData Engineer Location: Hybrid – Office (Wilmslow) and homeSalary: CompetitiveWe’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 improvementsDevelop, deploy and maintain ETL/ELT pipelines to automate financial data collection, transformation, validation and exception reportingActively engaging with stakeholder across multiple departments.Data platforms administrationEnsure relevant technical documentation is in placeAbout 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 detailExperience writing, troubleshooting, and debugging advanced SQL queriesOutstanding analytical and problem-solving skillsExperience working with ETL/ELT, and reporting and analytic toolsExperience designing data warehouse technical architectures and infrastructure componentsProgramming experience in PythonSkills and experience we’d love you to have…Understanding of cloud computing security conceptsExperience in relational cloud based database technologies like Snowflake, BigQuery, RedshiftExperience in open source technologies like Spark, Kafka, BeamGood understanding of Cloud providers – AWS, Microsoft Azure, Google CloudFamiliarity with DBT, Delta Lake, DatabricksExperience working in an agile environmentHere’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.
Job Title
Senior Data Engineer