Data Engineer - Snowflake

BJSS; London; On-site; GBP 50,000 - 90,000; Full time

Job summary

Join a forward-thinking tech consultancy that excels in solving complex data challenges. As a Data Engineer, you'll leverage your expertise to design and implement data solutions that drive insights and business value. Collaborate with diverse teams on exciting projects in the cloud, utilizing cutting-edge technologies like Snowflake and modern AI tools. This role offers a dynamic environment where you can grow your skills and contribute to impactful solutions for leading organizations. If you're passionate about data and eager to tackle new challenges, this opportunity is perfect for you.

Qualifications

• 2+ years experience in designing and implementing data warehouse solutions.
• Fluent in Python, Java, Scala, or similar languages.
• Advanced SQL knowledge and experience with relational databases.

Responsibilities

• Build, optimise, and maintain data applications, systems, and services.
• Work with cloud platforms and a variety of tools to deliver business value.
• Contribute to projects involving near real-time data and AI tooling.

Skills

Python

SQL

Java

Scala

DBT

ETL/ELT pipelines

Cloud platforms (AWS, Azure, GCP)

Data streaming technologies

Orchestration tools (Airflow, Dagster)

Job description

About Us

We're an award-winning innovative tech consultancy - a team of creative problem solvers. Since 1993 we've been finding better, more sustainable ways to solve complex technology problems for some of the world's leading organisations and delivered solutions that millions of people use every day.

In the last 30 years we won several awards, including a prestigious Queen's Award for Enterprise in the Innovation category for our Enterprise Agile delivery approach.

Operating from 26 locations across the world, we bring together teams of creative experts with diverse backgrounds and experiences, who enjoy working and learning in our collaborative and open culture and are committed to world-class delivery.

We want to continue to grow our team with people just like you!
About the Role

We're building out our Data Engineering practice across multiple levels. Depending on your experience and aspirations, you could be contributing as a key team member, leading a dedicated team, or taking on principal engineer responsibilities across multiple teams and larger strategic projects. The role and responsibilities will be tailored to your experience level and our organisational needs.

We are Software Engineers who use SDLC best practices to build scalable, re-usable data solutions to help clients use their data to gain insights, drive decisions, and deliver business value. Clients engage BJSS to take on their complex challenges, looking to us to help deliver results against their business-critical needs which means we get to work with a wide range of tools and technologies and there are always new things to learn.

BJSS Data Engineers are specialist software engineers that build, optimise, and maintain data applications, systems and services. This role combines the discipline of software engineering with the knowledge and experience of building solutions to deliver business value.

You can expect to get involved in a variety of projects in the cloud (AWS, Azure, GCP), while also gaining opportunities to work with Snowflake, Databricks, BigQuery, and Fabric. We work with near real-time/streaming data, geospatial data and using modern AI-tooling to accelerate development.
About You

You will need:

• Minimum of two years of recent experience designing and implementing a full-scale data warehouse solution based on Snowflake
• A minimum of one year of performing architectural assessments, examining architectural alternatives, and choosing the best solution in collaboration with both IT and business stakeholders
• Fluent in Python, Java, Scala, or similar Object-Oriented Programming Languages
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Working knowledge of one or more of the cloud platforms (AWS, Azure, GCP)
• Experience building ETL/ELT pipelines specifically using DBT for structured and semi-structured datasets
• Any orchestration toolings such as Airflow, Dagster, Azure Data Factory, Fivetran etc

It will be nice to have:

• Software engineering background
• Exposure to building or deploying AI/ML models into a production environment
• Previously used AWS data services e.g. S3, Kinesis, Glue, Athena, DynamoDB, SNS/SQS
• Experience using any data streaming technologies/paradigms for real-time or near-real time analytics