Data Engineer (Snowflake)

Data Engineer (Snowflake)


Salary: £60,000 - £65,000 + 20% Bonus & 15% Pension
Location: Bedford / Hybrid (Once a month commute)

Keywords in the role: Data Engineer / AWS / Snowflake / ETL / Data modelling / SQL



A fantastic opportunity has come up to work for a genuine market leader as they have started a new and exciting transformation project, and now require another Data Engineer to join the team.

They are transforming the business through improved processes, flexible ways of working and greater use of technology to make a difference to their customers and their people, so this role and the role holder are integral to our success.

The part you’ll play in achieving our transformation will be:

• Responsibility for developing accurate, efficient data transformations which meet customer needs to agreed timescales
• Ensuring the stability, robustness, and resilience of the projects you design and build, enjoying substantial autonomy while working within agreed standards
• Align activities to the Group wide data transformation programme both current future orientated

Your key responsibilities will be to:

• Design and build of reliable, robust, and accurate data pipelines based on agreed best practices
• Transformation of source data to meet business requirements
• Support the team in consolidating manual processes into a managed data environment
• Work with key stakeholders and other data consumers to gather requirements
• Ad-hoc support on database administration tasks as needed

Skills, Experience and Qualifications
The ideal candidate will have relevant experience in ingesting, transforming and supporting data processes within Snowflakes ecosystem.

Essential Skills and Experience:

• Understanding of Snowflake architecture, data modelling and administration
• Experience in designing and implementing efficient ETL/ELT pipelines
• Experience with AWS Data Services - AWS S3
• 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 in 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

Desirable:

• Experience with other databases MS SQL Server, Oracle
• Experience using Informatica
• Python
• Understanding of Data Lakes
• Familiar with Jira, Confluence

Applying for the opportunity:

If you feel you have the required skills and experience and wish to be considered for this opportunity, please apply by submitting an up-to-date version of your CV, and someone will contact you back within 24 hours.

Keywords in the role: Data Engineer / AWS / Snowflake / ETL / Data modelling / SQL
Keywords in the role: Data Engineer / AWS / Snowflake / ETL / Data modelling / SQL
Keywords in the role: Data Engineer / AWS / Snowflake / ETL / Data modelling / SQL
Keywords in the role: Data Engineer / AWS / Snowflake / ETL / Data modelling / SQL