e.g. job, company, title
e.g. city, county or postcode
advanced search »

Data Engineer

Irwin Mitchell


We’re a national law firm with a local reach. Our philosophy is ‘Expert Hand, Human Touch’ – something you’ll find in the way we work with our clients and how we support our teams. But, we’re more than just a law firm – we’re a team, working together to help individuals and businesses navigate life’s ups and downs.

Whichever team you join, working here you’ll feel a part of our friendly and inclusive environment. We’ll value you for who you are and what you bring. We support each other and push boundaries to achieve incredible things, and make a real difference to our clients and communities.

The work we do has been recognised in the awards we’ve won. We’re committed to being even better, and our awards help to show we’re on the right track.

Your Role

We are looking for an experienced and savvy Data Engineer to join the analytics team in our Sheffield office. You’ll be responsible for expanding and optimising the data and collection for cross functional teams, and deliver recommendations on improving efficiencies and reliability.

You’ll be responsible for building the required infrastructure for the optimal extraction, transformation and loading of data from a variety of sources. You’ll be an expert in the strengths and limitations of different data structures, and successfully assemble large and often complex data assets that will meet the business requirements. You’ll work with stakeholders to assist with their data-related technical issues, so it’s essential that you have strong background in supporting and working with cross functional teams.

You’ll be an experienced individual with a keen interest in optimising the transformation and provision of data through the data warehouse and data marts and manage these through to implementation. Exposure to different testing and project management methodologies is essential, and you’ll have considerable experience in a similar Data Engineer or related role with an advanced knowledge of SQL and working with OLTP relational databases, TSQL, SSMS and SQL Server 2008r.

Given the nature of the role, it’s essential that you have a good knowledge of data warehouse development techniques, methodologies and architectures. You’ll be responsible for building processes supporting data transformation and structures along with dependency and workload management.

Ideally, you’ll have exposure to several programming languages and have experience with scripting languages, such as Python and Java. You’ll also be skilled in configuration/ change management tools such as Redgate and GIT tools. You’ll be commercially aware, and maintain an awareness of new technologies and the potential investments that would ensure operational improvements.

Working in a fast-paced and exciting team, it’s essential that you’re an organized individual and can prioritise your workloads to meet deadlines, whilst working flexibly to assist others where necessary.

What we can offer you
  • 25 days annual leave, with the opportunity to buy additional leave
  • Two fundraising days in a year to give back to the community (fully paid!)
  • Westfield Health membership, offering discounted leisure and travel and refunds on medical services

We also offer a huge number of well-being initiatives to encourage positive mental health both in and out of the workplace as well as flexible working options to ensure that you are fully supported to work the way that best suits you. Our social responsibility programme is fundamental to who we are. We’re committed to being a diverse and inclusive workplace where our colleagues can flourish. We have a range of groups to celebrate our people across sexuality, disability, age, gender and culture.

Additional Information

As part of the Irwin Mitchell Group’s on-boarding process all successful applicants are required to complete the group’s employment screening process. This process helps to ensure that all new employees meet our standards in relation to honesty and integrity therefore protecting the interests of the Group, existing employees, clients, partners and other stakeholders.

Depending on the role you apply for we may carry out checks that will establish your eligibility to work in the UK, and criminal record check and financial checks ­with a credit reference agency will also be undertaken.

The employment screening process will fully comply with Data Protection and other applicable laws.

Irwin Mitchell LLP is an equal opportunity employer.