Data Engineer

Our client is on the lookout for a passionate and skilled Data Engineer to join a dynamic Data Team at their Poole location. This role is a fantastic opportunity for someone who is driven and possesses a solid understanding of SQL, various scripting languages, and Excel. They offer a flexible hybrid working model, combining in-office collaboration with the convenience of remote work. However, it\’s important for the candidate to be based in Dorset or its surrounding areas, as they value the synergy of face-to-face interactions. Some of your responsibilities would include: * Process Automation: Contribute to the automation of daily business activities, streamlining workflows for efficiency and effectiveness. * Data Analysis and Organization: Spend time with raw data to cleanse, structure, and ready it for integration into our bespoke system, ensuring data quality and accessibility. * Solution Development: Utilize your scripting and SQL expertise to create innovative data solutions that support and enhance our operations. * Ticket Management: Efficiently handle ticketed tasks, prioritizing and resolving issues to maintain smooth business operations. * Continuous Improvement: Proactively identify and suggest enhancements to our existing systems and processes, liaising with our in-house Development team to implement these improvements. * Innovation: Scout for opportunities to implement time-saving measures across the company, playing a key role in their development and deployment. Skills and Competencies Requirements: * Advanced SQL skills with at least 2 years of practical experience * Possess a strong foundation in Python and/or other scripting languages, enabling you to tackle diverse data challenges. * Advanced Excel capabilities, including complex formulae and pivot tables. * A basic understanding of Hyper-Text-Markup-Language (HTML) * Experience using cloud solutions, particularly Azure and the Fabric Platform. * The ability to engage effectively with key stakeholders, understanding and translating their needs into technical requirements. * Possess outstanding communication and interpersonal skills, facilitating clear and effective collaboration within and outside the team. Desirables: * Familiarity with the Apache Airflow platform. * Basic knowledge of BI tools such as Power BI to support data visualization and insights. * Experience with version control using GIT for collaborative and organized code management. * An understanding of C#/Javascript to identify system-driven data transformations. * Familiarity with Power Query in Excel for efficient data integration and ability to translate existing processes into a scripting language