Database Production Assistant

JATO Dynamics; Uxbridge; On-site; GBP 30,000 - 52,000; Full time

Job summary

JATO Dynamics is seeking a data-focused professional to ensure the timely and accurate production of our data. You will monitor the Live Production system, oversee the ETL process end-to-end, report failures, and maintain up-to-date documentation.

This role requires meticulous attention to detail and the ability to prioritise tasks under tight deadlines in a global data environment. Responsibilities include SQL querying across databases (SQL Server and SQLBase), database maintenance, testing and

Qualifications

• Experience with data production and SLA fulfilment.
• Ability to monitor ETL pipelines end-to-end and report issues clearly.
• Strong SQL skills and experience with relational databases.

Responsibilities

• Monitor Live Production system
• Oversee the complete ETL (extract Transform Load) process
• Reporting any failures / issues / defects via reporting tool
• Review and keep documentation up to date
• SQL Querying the databases to see the changes made and comparing results
• Production of several database types for various platforms.
• Maintenance of databases
• Testing and QA of all databases and data feeds
• Database backups and housekeeping UAT of production software upgrades
• UAT of schema changes in production

Skills

SQL

ETL

QA testing

Attention to detail

Time management

Tools

SQL Server

SQLBase

FTP tools

PowerShell

Job description

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:

To ensure the timely and accurate production of all data. Ensuring all service level agreements are met and improved where possible.

Key Responsibilities:

• Monitor Live Production system
• Oversee the complete ETL (extract Transform Load) process
• Reporting any failures / issues / defects via reporting tool
• Review and keep documentation up to date
• SQL Querying the databases to see the changes made and comparing results
• Production of several database types for various platforms.
• Maintenance of databases
• Testing and QA of all databases and data feeds
• Database backups and housekeepingUAT of production software upgrades
• UAT of schema changes in production

Key Requirements:

• Microsoft Edge / Google Chrome
• Microsoft SQL Server or SQLBase
• Knowledge of networks, FTP tools
• Can demonstrate attention to detail and strong completion skills
• Able to prioritise workloads and respond to tight deadlines
• Willing to take responsibility for ensuring delivery of a quality service
• Powershell desirable not essential

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.