Banner Default Image

Data Engineer

Back to job search

Data Engineer

  • Location:

    Reading

  • Sector:

    Data & Analytics

  • Job type:

    Permanent

  • Salary:

    £50000 - £70000 per annum

  • Contact:

    Zoe Caplan-Hill

  • Contact email:

    zoe.caplan-hill@mexasolutions.com

  • Job ref:

    338041_1641912655

  • Startdate:

    ASAP

Salary: Circa 50 to 70k pending experience (negotiable).

About the job

Data Engineer

The business is a trusted analytics and data management experts, delivering technology strategy and support for businesses who need to get the most from their data. The team have deep technical and commercial experience working with Microsoft Data Services to help our clients optimise their costs and maximise the benefits from their investments in these technologies.

The business has been established for over 14 years and has exclusively focused on Microsoft technologies. Our mission is to "help our clients predict their future" through the better use of data, technology, people and processes. To do this our business has always focused on:

  • Dedicated Support
  • Data Platform Consultancy
  • Analytics Consultancy
  • Adoption and Change Management

The business's preference for any client engagement is always collaborative in nature. This helps ensure we pass on our knowledge to upskill and develop our client's internal resources while our on-going Dedicated Support team can provide a fully managed service for on-premises, hybrid, and public cloud solutions. This includes 24x7 proactive event monitoring and issue resolution, performance tuning and cost optimisation services which are all provided from our UK based response centre.

Microsoft recently awarded the business the prestigious Advanced Specialisation focussed on Azure Analytics, demonstrating our breadth and depth of capability. You will be work to enable our customers to ingest and model data in a greenfield Azure platform. As a technical, functional and industry expert you will uncover technical solutions to complex business scenarios. The role will require engagement at all levels of a project lifecycle including initial client consultancy, scope and design, and technical delivery.

This is a client facing position, which requires travel to customer sites across the UK and occasionally abroad, with nights away from home.

Having just been awarded the prestigious Windows Server and SQL Server Migration to Microsoft Azure advanced specialisation, you will be required to support our customers in migrating and optimising SQL Server based production workloads to Azure. As a technical, functional and industry expert you will uncover technical solutions to complex business scenarios. The role will require engagement at all levels of a project lifecycle including initial client consultancy, scope and design, and technical delivery.

This is a client facing position, which requires travel to customer sites across the UK and occasionally abroad, with nights away from home.

Key Responsibilities

  • Effectively gather client requirements and ask clarifying questions when needed
  • Translate these requirements into actionable tasks to perform or collaborate with other team members
  • Select and deploy the best approach for data ingestion and processing pipelines to support client requirements
  • Setting up and leading the practice of DevOps to design, build and maintain efficient, reusable, and reliable code
  • Designing, Implementing, and optimising ETL pipelines using DevOps principles
  • You will be working with our team on some of our clients most challenging projects, you will take responsibility for your work and ownership of the successful outcome of these projects
  • Set high standards for self on adhering to information and security practices and processes to protect personal data, and maintain the integrity of the business and its customers

Technical Skills

You'll need to have some experience with some of the following and be able to learn new technologies or concepts quickly:

  • Loading and transforming large data sets, including structured and unstructured data from corporate and external sources
  • Running data cleansing routines and data quality tasks using SQL, Python or Spark
  • Design and optimising Data Lake for data storage to meet security, retention and access needs
  • Using Azure Data Factory (and Synapse Analytics Pipelines) to perform data loading
  • Experience with Azure Databricks for orchestrating loads and cleansing activities
  • Experience with Azure solution deployment automation and testing through ARM templates etc
  • Knowledge of delivering DevOps capabilities for data projects

Project Delivery Experience

You'll likely have some experience delivering projects to external clients:

  • Strong understanding of BI and data warehousing concepts
  • Experience with data modelling, data structures, databases, and ETL processes
  • Excellent stakeholder management and communication skills, including prioritising, problem solving and relationship building
  • Ability to understand and articulate requirements to technical and non-technical audiences
  • Experience delivering in an agile project delivery environment

Benefits and Perks

  • Homebased working available and we have a lovely office in Winnersh, Berkshire, just outside Reading but please do expect to work from home for the time being.
  • Comprehensive benefits package including BUPA healthcare scheme, Pension, Life Assurance and Income Protection
  • We care about your well-being so have invested resources such as GP and other health services and training help to ensure you can be at your best with us.
  • Very friendly, inclusive culture, with strong team spirit.
  • Company growth and new projects means ongoing career progression options.
  • Up to date technology, so collaboration has never been easier.
  • Cutting edge technology projects - exciting goals ahead!

You will be Working From Home (WFH) for this position.

Please feel free to contact me about this vacancy on -

Phone: 07 547 672 676 or 07 591 212 477

Email: jan . villaruel @ mexasolutions . com or zoe . caplan-hill @ mexasolutions. com