Data Engineer

Role: Data Engineer

Location: Woking

Salary: £45,000 - £50,000 (+ Bonus)

We are seeking an experienced individual to join our team as a Data Engineer as we begin a journey to transform our data and analytics capabilities. The ideal candidate will be a data engineer or developer with experience within a small business (start-up and scale-up) and skills in SQL, Python, UX frameworks and cloud platforms. You will work on both the development and maintenance of the existing data infrastructure, and as a key contributor to the architecture, design and build out of the strategic architecture.

Role Requirements:

• Willingness to get hands on with company data and tooling, and the desire to create effective solutions that deliver business outcomes quickly and efficiently.
• A demonstrated ability to develop new innovative and structure solutions while being a team-player in the support of legacy processes and the re-tooling of current capabilities.
• Ability to design, build and deploy data solutions which capture, explore, transform and utilise data to support operational effectiveness, analytics and decision-making.

Main Responsibilities:

Operational and Management Reporting:

• Design, develop, and maintain complex SQL queries and stored procedures to extract and manipulate data from various sources.
• Create, optimise and customise reports for business and operational functions to ensure data accuracy and consistency.
• Identify, prioritise and implement opportunities for improving use of data, business outcomes, performance and efficiency.
• Provide technical support and troubleshooting assistance for data, applications and reporting.

Analytics and innovation:

• Develop new capabilities and tools to deliver quick and effective solutions to business operational, efficiency and information challenges.
• Demonstrate the power of existing data by delivering solutions to empower end-users to access data that leverages third-party tools, applications, and cloud-based capabilities.
• Support business colleagues to leverage data assets using reporting tools and no/low-code capabilities and tooling.

Data Transformation:

• Participate in the design of new data solutions including the creation of a cloud-based data platform.
• Design and development of ETL pipelines to manage the flow of data and develop business insights.
• Analyse sources to determine value and recommend data to include in business processes.
• Integrate and migrate existing data capabilities into the cloud solution.
• Implement scalable solutions, review and design processes for new data sources, and liaise with third party providers for data requirements.

Collaboration and Processes:

• Collaborate closely with colleagues to understand and address business requirements.
• Implement robust quality assurance and data validation processes to ensure that data integrity and quality standards are met.
• Incorporate core data management competencies including data governance, data security and data quality.
• Model data requirements, data sources, and data flows to bring order and structure to programmes of work.

Benefits:

• Company pension.
• Bonus Scheme.
• Private Medical Insurance.
• Casual dress.
• Referral Incentive Scheme.
• Additional leave
• Cycle to work scheme
• On-site parking
• Work from home

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.

Essential Skills:

• Strong proficiency in SQL and database development, including complex query optimization and performance tuning.
• Proficiency in at least one leading business intelligence platform (e.g. Microsoft, Crystal, Qlik, SAP, Tableau).
• Good understanding of open source, big data, and cloud data platforms (e.g. Hadoop, Spark, Hive, Pentaho, AWS, Azure); given a business problem, you can analyse and evaluate options and recommend solutions.
• Proven experience in designing, building and maintaining ETL/ELT processes.
• Demonstrated ability to apply existing knowledge and experience to develop additional skills in new cloud platforms, tooling, and programming languages.
• Understanding of data modelling and schema design principles.
• Hands-on experience on at least one modern programming language (e.g. Java, TypeScript, Python).
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
• Ability to work independently and manage multiple tasks simultaneously in a fast-paced environment.

Desired Skills:

• Proficiency in Python, Flask, Jupiter Notebooks.
• Proficiency in application development (front-end/UX, APIs, web services).
• Previous experience in financial services or a regulated industry.

In Technology Group Ltd is acting as an Employment Agency in relation to this vacancy.