Data Engineer - Microsoft SQL & SSIS

Dufrain; London; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading data consultancy in London seeks a Data Engineer passionate about leveraging data for client success. In this role, you will develop high-quality data solutions and cultivate client relationships while utilizing technologies like Microsoft SQL, SSIS, and cloud services like Azure. We value diversity and encourage applications from all candidates with the right to work in the UK.

Qualifications

• Experience with data solutions, particularly in SQL Server.
• Strong interpersonal skills and team-oriented approach.
• Relevant certifications like Databricks Certified Data Engineer.

Responsibilities

• Develop performant data solutions in a collaborative environment.
• Handle and escalate issues effectively while proposing solutions.
• Contribute to consulting practice through knowledge-sharing.

Skills

Microsoft SQL

Data Migration

SSIS

T-SQL

Data Governance

Data Modelling

ETL / ELT

Data Warehousing

Agile

DevOps

Education

Relevant certifications in Data Engineering

Tools

Azure Data Factory

Snowflake

Databricks

Job description

We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services.

At Dufrain we pride ourselves on a creative and innovative approach, focusing on delivering exceptional outcomes for clients by leveraging data to drive growth and efficiency.

Our mission is to inspire, shape and deliver the data capabilities of tomorrow.

Our Data Engineers play a pivotal role in supporting clients navigate the complexities of data management, analytics, and strategy.

OUR DATA ENGINEERS

• Possess a broad range of data engineering skills, with a focus on Microsoft SQL and SSIS, together with experience ofMicrosoft Fabric, Databricks or Snowflake is also desirable.
  
• Develop good working relationships with clients on a project including interpersonal skills with both business and technical focused colleagues.
  
• Experience working as a data engineer to develop performant end-to-end solutions in a collaborative team environment.
  
• Delivering high-quality pieces of work, proven ability to escalate problems to client / senior team members where necessary and propose possible solutions.
  
• Support building the Consulting practice through contribution to ongoing initiatives. This can include contributing to knowledge-sharing activities, and data services.
  
• Experience working on Data Migration Projects is desirable.

TECHNICAL SKILLS REQUIRED

• Strong experience designing and delivering data solutions with Microsoft SQL Server or any of the Azure SQL offerings (Azure VM hosting SQL, SQL Managed Instance, Azure SQL DB)
  
• Good working knowledge of T-SQL including Stored Procedure, Functions, CTE’s, Aggregation and SSIS.
  
• Experience working with relational SQL databases either on premises or in the cloud.
  
• Experience delivering multiple solutions using key techniques such as Governance, Data Migration, Data Modelling, ETL / ELT, Data Lakes, Data Warehousing, Master Data, and BI.
  
• A solid understanding of key processes in the engineering delivery cycle including Agile and DevOps, Git, APIs, Containers, Microservices and Data Pipelines.
  
• Experience working with one or more of Databricks, Snowflake, Azure Data Factory, Azure Synapse or Microsoft Fabric is highly desirable.

NICE TO HAVE

• Databricks Certified Data Engineer Associate
  
• Databricks Certified Data Engineer Professional

SKIILLS AND EXPERIENCE

• A high level of drive with the ability to work to tight deadlines.
• Experience of providing insightful solutions
• The ability to participate effectively in meetings with senior stakeholders
• A team player who supports, encourages and shares knowledge with others
• A self-starter with the ability to work under pressure and with limited supervision
• A track record of accurate output and responsibility for elements of project delivery
• The ability to work as part of an integrated team or on an individual basis

We have a working culture that rewards high performance and nurtures talent, while providing exciting opportunities and challenges to generate positive change for our clients.

If you’re passionate about data, and you’re looking to join a leading data consultancy, you could find your dream role at Dufrain.

Please submit your CV highlighting your relevant experience and certifications. Applicants must have the right to work in the UK and not require sponsorship now or in the future. Visa sponsorship is not available.

We are an equal opportunity employer and value diversity at our company.. We do not discriminate on the basis of race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other status protected by law. All qualified applicants will receive consideration for employment without regard to these factors. We encourage applications from individuals of all backgrounds and experiences.