Data Engineer

i247 Group is on the lookout for a passionate and skilled Data Engineer to join our dynamic Data Team at our Poole BH16 6LS location.

This role is a fantastic opportunity for someone who is driven and possesses a solid understanding of SQL, various scripting languages, and Excel.

We 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 we value the synergy of face-to-face interactions.

Some of your responsibilities would include:

• 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.


• Process Automation: Contribute to the automation of daily business activities, streamlining workflows for efficiency and effectiveness.


• Continuous Improvement: Proactively identify and suggest enhancements to our existing systems and processes, occasionally 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.
  
  Advanced Excel capabilities, including complex formulae and pivot tables.


• Advanced SQL skills with at least 2 years of practical experience


• Possess a strong knowledge of Python or other scripting languages, enabling you to tackle diverse data challenges.


• A good understanding of Hyper-Text-Markup-Language (HTML)


• 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.


• Experience with a version control repository such as GIT for collaborative and organized code management.


Desirables:

• Basic knowledge of BI Dashboard tools such as Power BI to support data visualization and insights.


• An understanding of C#/Javascript to identify system-driven data transformations.


• Skill in writing PowerShell scripts to automate Windows tasks.


• Practical experience with SSIS for data integration and workflow automation.


• Familiarity with Power Query in Excel for efficient data integration.


• Proficiency in VBA for Excel to automate repetitive tasks and create interim data solutions., SQL: 2 years (required)