Data engineer

Role: Data Engineer Location: Woking Salary: GBP45,000 - GBP50,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 #39;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