Data Engineer - Microsoft SQL & SSIS

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 onMicrosoft SQLandSSIS,together with experience of Microsoft Fabric, Databricks or Snowflakeis 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.