Data Engineer

Our client is undergoing a major business transformation programme that aims to improve their processes, enable flexible working, and leverage technology to make a positive impact on their customers and employees. They are looking for a Data Engineer to join their new department from an SQL server and help them build a data-driven business for the future. You will be part of a team that will establish best practices and foster a culture of continuous improvement that will revolutionise the way they produce, use, and manage Data & BI.
As a Data Engineer, you will be responsible for:

• Developing accurate, efficient data transformations that meet customer needs within agreed deadlines
• Ensuring the reliability, robustness, and resilience of the projects you design and build, while working independently within agreed standards
• Aligning your activities with the Group-wide data transformation programme, both current and future-oriented
• Some of your key tasks will include:
• Designing and building reliable, robust, and accurate data pipelines based on agreed best practices
• Transforming source data to meet business requirements
• Supporting the team in consolidating manual processes into a managed data environment
• Working with key stakeholders and other data consumers to gather requirements
• Providing ad-hoc support on database administration tasks as needed
• To be successful in this role, you will need to have relevant experience in ingesting, transforming, and supporting data processes within Snowflake's ecosystem.

Essential Skills and Experience include:

• Understanding of Snowflake architecture, data modelling, and administration
• Experience in designing and implementing efficient ETL/ELT pipelines
• Experience with AWS Data Services - AWS S3
• Knowledge of Power BI
• Comfortable working with a range of data sources and formats e.g. JSON, XML, Flat files, API Integration
• Understanding of dimensional modelling for Data Warehousing (Kimball)
• Proficient in writing SQL, Stored procedures, and views. Creating and optimising complex queries, analysing query performance, use of partitioning and clustering.
• Experience of effectively coaching novice developers
• Good problem-solving and data analysis skills
• Excellent written and oral communication skills, ability to communicate complex concepts
• Ability to translate business requirements into technical solutions
• The role offers a hybrid office arrangement with flexible working 2/3 days per week.

In addition to salary, you will also enjoy:
A significant bonus potential, based on the company\'s performance.
Company Pension - up to 10% employer contribution.
Healthcare
Death in Service
25 days annual leave (plus bank hols).
What you need to do now
If you\'re interested in this role, click \'apply now\' to forward an up-to-date copy of your CV, or call us now.
If this job isn\'t quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.

Hays EA is a trading division of Hays Specialist Recruitment Limited and acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk