I.T. Data Engineer

Optos; Dunfermline; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading medical technology company is seeking an experienced Data Engineer to join their IT Operations team in Dunfermline. You will design and maintain data solutions, collaborating closely with analysts and stakeholders to meet business objectives. Ideal candidates will have a strong background in Microsoft technologies, with at least 2 years’ experience in a similar role. Competitive compensation and benefits package offered.

Benefits

Competitive compensation and benefits package

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent.
• 2+ years of experience as a Data Engineer or similar role.
• Strong experience with Microsoft SQL Server, T-SQL, and SSIS.

Responsibilities

• Design, develop, and maintain data pipelines and ETL processes.
• Build and optimise data models and data warehouses.
• Collaborate to understand data requirements and deliver reliable solutions.

Skills

Microsoft SQL Server

T-SQL

ETL processes

Data modelling

Data warehousing

Education

Bachelor’s degree in Computer Science

Tools

SQL Server Integration Services (SSIS)

Azure Data Factory

Power BI

Python

PowerShell

Job description

Social network you want to login/join with:

We are currently looking for a talented and experienced Data Engineer with a strong background in Microsoft technologies to join our IT Operations team in Dunfermline. In this key role, you will be responsible for designing, developing, and maintaining scalable data solutions that support our business objectives.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Design, develop, and maintain data pipelines and ETL processes using Microsoft technologies (e.g., SQL Server Integration Services, Azure Data Factory).
• Build and optimise data models and data warehouses on SQL Server and/or Azure Synapse Analytics.
• Develop and deploy data solutions in Azure, including Azure Data Lake, Azure SQL Database, and related services.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.
• Ensure data quality, integrity, and security across all data platforms.
• Write efficient T-SQL queries, stored procedures, and scripts for data extraction, transformation, and loading.
• Monitor, troubleshoot, and optimize performance of data solutions.
• Implement data governance and best practices for data management.
• Stay up to date with emerging Microsoft data technologies and recommend improvements.

MINIMUM QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent professional experience.
• 2+ years of experience as a Data Engineer, or similar role.
• Strong experience with Microsoft SQL Server, T-SQL, and SSIS.
• Proficiency in data modelling, data warehousing, and ETL processes.
• Knowledge of Power BI or other Microsoft BI tools.
• Familiarity with scripting languages such as Python or PowerShell is desirable.
• Solid understanding of data governance, security, and compliance.
• Excellent problem-solving skills and attention to detail.
• Proven ability to communicate effectively and work well in team environments.

BENEFITS

At Optos, we offer a highly competitive compensation and benefits package.