Azure Data Engineer

JATO Dynamics Ltd; Uxbridge; On-site; GBP 60,000 - 90,000; Full time

Job summary

JATO Dynamics Ltd. is hiring an Azure Data Engineer to join agile teams and help build next-generation SaaS data solutions for the automotive sector. You will design, implement and operate data pipelines in Azure, turning data assets into usable data products for internal and external customers.

You will collaborate with Operations, Architecture, Delivery, Product and Software Engineering to release platform increments, improve data quality and enforce DevOps practices across CI/CD pipelines.

Qualifications

• Minimum 2+ years’ hands-on experience designing and developing complex ETL/ELT pipelines in the cloud (Azure Data Factory and Azure Synapse).
• Experience of preparing data mappings based on high level requirements and taking those to a solution level details.
• Firm understanding of data warehousing concepts in the lake and traditional database with experience of working end-to-end in a ETL lifecycle from data acquisition to the consumption layer.
• Knowledge and experience in value-added areas of automation, scripting.
• Hands-on analytical and data exploration skills.
• Experience of working in Agile methodology.
• Good knowledge and hands-on experience of developing Stored Procedures.
• Experience of working with PySpark Notebooks for data ingestion and provision.
• Practical experience of improving data quality and efficiency in data pipelines.
• Solid understanding of DevOps and CI/CD.
• Understanding of compliance and lifecycle of data management.

Responsibilities

• Ingest, warehouse, and store data at scale in the Azure cloud platform as JATO Data Assets.
• Build Data Products from Data Assets and provision to customers to satisfy commercial requirement.
• Work closely with colleagues in Operations, Architecture, Delivery, Product, and Software Engineering to collaboratively release platform increments.
• Contribute toward solution level architecture and design.
• Own your release from development to production following DevOps method.
• Contribute towards ADF and Synapse pipeline design improvement and best practices and following design principles.
• Understand data issues and able to analyse and work with Architects in addressing design challenge.
• Migrate data from legacy databases and storage to Azure cloud-based lake and warehouse.

Skills

ETL/ELT pipelines

Azure Data Factory

Azure Synapse

Cloud data engineering

Data warehousing

Stored Procedures

CI/CD

PySpark

Agile

SQL/NoSQL

Education

Bachelor’s or higher in a relevant field

Tools

Azure Data Factory

Azure Synapse

PySpark

SQL/NoSQL databases

Job description

About us:

JATO Dynamics is a global company and the leading provider of automotive market intelligence. With an insight into over 50 overseas markets, we deliver the world's most complete, accurate and up-to-date automotive data and insights, creating significant competitive advantage to our customers.

Find out more about what we do here: JATO

Our vision.

Our vision is to be the world’s most exciting leader in automotive business intelligence solutions. We aim to generate excitement through implementing pioneering ideas, problem solving and going beyond our customer expectations. Our JATO colleagues are partners in our future and stakeholders in our desires. Our strategic intent is to help customers create significant competitive advantage by constantly leading in connected data, information and knowledge provision, ultimately improving our customers’ work processes, informed decision-making and business results.

Role Overview:

Do you want to be part of building out next generation SaaS products that power the automotive industry? JATO is currently looking to hire an Azure Data Engineer to join our agile teams. As a Data Engineer, you will work in a product delivery team using your data analysis, ETL and cloud technology skills to discover, model, provision and store data at scale in the cloud. This data will be then converted into data products based on the commercial requirements and provisioned to internal and external customers

Key Responsibilities:

• Ingest, warehouse, and store data at scale in the Azure cloud platform as JATO Data Assets
• Build Data Products from Data Assets and provision to customers to satisfy commercial requirement
• Work closely with colleagues in Operations, Architecture, Delivery, Product, and Software Engineering to collaboratively release platform increments
• Contribute toward solution level architecture and design
• Own your release from development to production following DevOps method
• Contribute towards ADF and Synapse pipeline design improvement and best practices and following design principles
• Understand data issues and able to analyse and work with Architects in addressing design challenge
• Migrate data from legacy databases and storage to Azure cloud-based lake and warehouse

Key Requirements:

Essential Skills:

• Minimum 2+ years’ hands-on experience designing and developing complex ETL/ELT pipelines in the cloud (Azure Data Factory and Azure Synapse)
• Experience of preparing data mappings based on high level requirements and taking those to a solution level details
• Firm understanding of data warehousing concepts in the lake and traditional database with experience of working end-to-end in a ETL lifecycle from data acquisition to the consumption layer
• Knowledge and experience in value-added areas of automation, scripting
• Relational databases (SQL Server, MySQL etc.), NoSQL and writing querie
• Hands-on analytical and data exploration skills
• Experience of working in Agile methodology
• Good knowledge and hands-on experience of developing Stored Procedures
• Experience of working with PySpark Notebooks for data ingestion and provision
• Practical experience of improving data quality and efficiency in data pipelines
• Solid understanding of DevOps and CI/CD
• Understanding of compliance and lifecycle of data management

Desirable Skills:

• Coding experience in any relevant language (Python, Pyspark etc.)
• Experience working with other Azure technologies such as Fabric, Power Automate
• Experience of working with non-relational databases (CosmosDB, MongoDB, etc.) and handling unstructured data in ETL pipelines

Our values

JATO core values are Integrity, People First, Collaboration, Innovation and Excellence.

Learn more about our values here: JATO Core Values

JATO Dynamics is a global business and our success is attributed to the diversity, skills and experiences of our colleagues across the world. We are proud to be an equal opportunity employer and are committed to equal employment opportunity regardless of race, sex, age, gender identity, sexual orientation, religion or belief, disability, marital status or veteran status.