Data Engineer

Aspire Personnel Ltd; England; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading recruitment agency is seeking a passionate Data Engineer to join a dynamic Data Team in Poole. Responsibilities include automating business processes, analyzing and organizing data, and developing innovative data solutions using SQL and scripting. Candidates must have advanced SQL skills, experience with Python and Excel, and strong communication abilities. The role supports a hybrid working model, making it essential for candidates to be based in Dorset. Competitive salary and opportunities for growth are offered.

Qualifications

• Advanced SQL skills with at least 2 years of practical experience.
• Strong foundation in Python or other scripting languages.
• Advanced Excel capabilities including complex formulae and pivot tables.

Responsibilities

• Contribute to the automation of daily business activities.
• Cleanse and structure raw data for system integration.
• Utilize scripting and SQL expertise to create innovative data solutions.
• Handle ticketed tasks, prioritizing and resolving issues.
• Suggest enhancements to existing systems and processes.

Skills

Advanced SQL skills

Python or other scripting languages

Advanced Excel capabilities

Basic understanding of HTML

Experience using cloud solutions (Azure)

Outstanding communication skills

Tools

Apache Airflow

Power BI

GIT

Power Query

Job description

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.