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.