Description
Role - Senior Data Engineer (Snowflake/Matillion)
Salary - £60,000 - £85,000 (DOE)
Location - Hybrid; aiming to be on-site 2-3 days per week in our Bristol HQ
A bit about us...
Snap Analytics is a high-growth data analytics consultancy with offices in the UK and India, we work with enterprise clients to simplify complex data and drive business value. We’re customer-centric in our approach and dedicated to helping organisations achieve their strategic goals through innovative cloud analytics solutions.
We pride ourselves on using our innovative Snap 360 delivery framework, combined with a strong culture of teamwork and knowledge-sharing, to consistently deliver exceptional results and ensure 100% customer satisfaction.
Joining Snap at this exciting stage of growth offers a unique opportunity to make a significant impact. As a rapidly expanding consultancy, you'll have the chance to shape our direction and play a key role in driving our success and strategy forward.
Here's a breakdown of what you'll be doing...
Data Migration & Integration:
1. Lead and manage complex data migration projects, ensuring smooth transitions from multiple data sources to cloud environments.
2. Design and implement efficient ETL/ELT processes for seamless integration between systems.
Data Warehousing:
1. Design, build, and optimize cloud-based data warehouses (e.g., Snowflake, Databricks, AWS Redshift, Google BigQuery, Azure Synapse) to support advanced analytics and reporting needs. Ensure data accuracy, security, and compliance.
Data Modelling:
1. Develop and maintain robust data models (star, snowflake, etc.) that ensure high-quality, scalable, and efficient data storage and retrieval.
2. Implement best practices for data modelling to support analytics and reporting requirements.
Cloud Infrastructure:
1. Develop and maintain scalable, robust, and cost-effective cloud-based data architectures on platforms such as AWS, Azure, and GCP.
2. Provide best practices for data storage, governance, and access control.
Pipeline Development:
1. Build, automate, and monitor data pipelines that handle large volumes of structured and unstructured data.
2. Implement best practices for data cleansing, transformation, and enrichment.
Collaboration & Stakeholder Management:
1. Collaborate with data architects, data scientists, and business teams to understand requirements and translate them into effective data engineering solutions.
2. Communicate technical challenges and provide insights on data-driven solutions.
Performance Optimization:
1. Analyse and improve the performance of data systems and pipelines, ensuring low-latency data access, high availability, and optimized cloud resource usage.
Mentorship & Leadership:
1. Mentor junior engineers, fostering a culture of collaboration and continuous learning.
2. Provide technical guidance, code reviews, and best practices to elevate the overall team performance.
Innovation & Continuous Improvement:
1. Stay updated with the latest trends and technologies in data engineering, cloud platforms, and big data to propose innovative solutions for clients' evolving data needs.
This role is for you if you have...
1. Proven experience (5 years+) as a data engineer with a focus on data migration, integration and cloud-based data warehousing working with big data for enterprise organisations.
2. Expertise in building data architecture on cloud platforms such as AWS, GCP or Microsoft Azure.
3. 5+ years of experience of ETL/ELT design and development using tools like Matillion, Informatica, SAP Data Services, Talend and Cloud Data Platforms including Snowflake, Databricks, Redshift or BigQuery.
4. A deep understanding of data modelling principles and techniques (e.g., star schema, snowflake schema), and experience in developing optimized models to support analytics and reporting.
5. Experience with version control, CI/CD pipelines, and containerization tools (e.g., Git, Jenkins, Docker, Kubernetes).
6. Strong knowledge of relational and non-relational databases and hands on experience with cloud data warehouse including AWS Redshift, Google BigQuery, Azure Synapse.
7. A 2:1 University degree or above (or equivalent other).
8. Excellent communication skills, with the ability to work collaboratively with both technical and non-technical stakeholders.
9. Strong problem-solving skills, with the ability to troubleshoot complex data issues and deliver optimized solutions.
It’s useful (not a must) if you have exposure to…
1. Data Science and Machine Learning.
2. Tools like dbt and Dataiku.
Something to note…
Here at Snap, our values drive us. So, aligning with them is incredibly important. Our values are – be Smart, be Nice, be Accountable, be Passionate. Be SNAP
So, what does being SNAP look like?
* Bringing positivity and enthusiasm to the workplace
* Being dynamic and proactive, always ready to tackle new challenges
* Having a strong attention to detail, ensuring excellence in everything you do
* Having a strong desire to learn and share knowledge
All applicants are welcome!
Research shows that some may hesitate to apply unless they meet every requirement. However, your unique experience, skills, and passion are what set you apart, so, we’d love to hear from you even if you don’t hit all the skills above.
So, what’s next?
If you’ve got this far and you’re feeling inspired, apply! Our hiring process is as follows…
1. Initial screening with a member of our Talent Acquisition Team.
2. A technical task and interview with one of our Principal Consultants.
3. A final interview with our Delivery Director.
If you need any adjustments made to our process, let us know so we can provide the right support and ensure you can perform at your best!
What we offer...
Annual Leave - Everyone needs a healthy, happy and productive life that only comes with regular R&R. We offer a competitive annual leave allowance plus public holidays.
Flexible, Hybrid Working - We believe variety is the spice of life, so we encourage a healthy mix of office based and remote working to facilitate a great work/life balance.
Financial Wellbeing - As well as a competitive salary, we offer contributory pension schemes to allow for future financial security.
Health & Wellbeing - The well being of everyone at Snap is of great importance to the business, all employees from day 1 are entitled to private medical health insurance through Vitality.
Profit Share - Enjoy a share of our profits with a bonus at the end of each successful year.
Technical Training - Dedicated time for ongoing technical training and certification on the modern data stack.
Monthly Social Club - From surfing to pottery, once a month there is always something new to try.
UK Electric Car & Cycle to Work Schemes - We promote healthier lifestyles and reduced environmental pollution. These schemes are our way of trying to make a difference.
Enhanced Maternity & Paternity Time Off - We recognise that having a baby is an important and exciting time, so our policies are designed to make those early days as flexible as possible when it comes to juggling work commitments with the demands of a new family.
About Snap Analytics
We are a dream team of data engineers, data warehousing experts and advanced analytics gurus. At Snap Analytics, we believe that sharing valuable data across your organisation securely shouldn't be so hard! Having worked with some of the world's biggest consulting businesses and organisations, we spotted a huge opportunity to simplify data warehousing and analytics projects.
We utilise modern cloud data platforms to enable us to combine data from multiple separate business systems into a single, unified view. We help you to extract your data, load it to the cloud and transform it into business insights. This enables you to make more effective decisions to help your organisation succeed. By utilising new technology from our amazing cloud partners, our own Snap 360 framework and the best consultants in the business, we deliver better, faster solutions! It's our belief that technology alone doesn't solve problems. You need awesome people who also understand your business processes and challenges to help you unearth the diamonds in your data.
#J-18808-Ljbffr