SQL Database Administrator

JR United Kingdom; Aberdeen City; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

An exciting opportunity for a Junior Data Engineer at a leading transportation manufacturer in Aberdeen, specializing in safety solutions. You will support data engineering by managing data pipelines and ensuring data integrity, while collaborating with cross-functional teams. Join a company known for innovation and excellence!

Benefits

Excellent company benefits

Option for hybrid or remote work

Qualifications

• Basic understanding of data engineering concepts and data quality.
• Hands-on experience with SQL and database management.
• Familiarity with data visualization tools.

Responsibilities

• Provide support for data engineering tasks and data pipeline issues.
• Assist in gathering and managing data engineering requirements.
• Collaborate with teams to ensure data initiatives are managed.

Skills

SQL

Data quality management

ETL processes

Data pipelines

Attention to detail

Tools

Python

Power BI

Tableau

Snowflake

AWS

Azure

Google Cloud

Git

Job description

Social network you want to login/join with:

Overview:

An exciting opportunity has arisen for a SQL Database Administrator to join one of the world’s leading transportation manufacturers who specialise in providing safety and securement solutions for mobility devices. They are known best for their commitment to innovation, by continuously developing new technologies to improve safety and the ease of use - they have introduced several industry-first products and maintain a strong focus on research and development. As a Junior Data Engineer, you will play a crucial role in developing the data infrastructure that supports the analytics and operational functions of our business enterprise.

Role & Responsibilities:

Data Infrastructure & Support:

• Provide first-line support for data engineering tasks, such as managing and monitoring data pipelines, resolving issues, and ensuring data integrity.
• Work with both structured and unstructured datasets to design and implement data models, perform data cleansing, transformation, and validation.
• Maintain accurate documentation of data workflows, pipelines, and issue resolutions.
• Manage system administration tasks, including user access to data resources and troubleshooting data-related errors.
• Collaborate with business stakeholders to identify data requirements and deliver sustainable solutions.
• Monitor and troubleshoot data pipeline issues to maintain data integrity and accuracy.
• Assist in the development, maintenance, and optimization of ETL (Extract, Transform, Load) processes for efficiency and reliability.

Project & Improvement:

• Assist in gathering, documenting, and managing data engineering requirements and workflows.
• Contribute to the development of guidelines and documentation for data engineering best practices.
• Assist in designing, testing, and implementing data pipelines and workflows using established software development lifecycle techniques.
• Help define and optimize scalable data processes that drive operational improvements.
• Collaborate with cross-functional teams to ensure data-related initiatives are properly planned, scheduled, and managed.
• Participate in risk management and change management processes related to data infrastructure.
• Participate in quality reviews of designs, prototypes, and other work products to ensure requirements are met.

Skills & Experience:

• Basic understanding of data engineering concepts, such as ETL processes, data pipelines, and data quality management.
• Hands-on experience with SQL (e.g., writing queries, basic database management).
• Familiarity with data tools and platforms (e.g., Python, Power BI, Tableau, or similar visualization tools).
• Attention to detail across large data sets and multiple business unit data fields.

Preferred:

• Experience with Snowflake.
• Familiarity with cloud data platforms (e.g., AWS, Azure, or Google Cloud).
• Basic knowledge of version control tools like Git.
• Awareness of data warehousing concepts and architectures.

Package:

• Excellent company benefits
• Option for this role to be hybrid or remote