National AI Awards 2025Discover AI's trailblazers! Join us to celebrate innovation and nominate industry leaders.

Nominate & Attend

I.T. Data Engineer

Optos
Fife
2 weeks ago
Create job alert

ROLE SUMMARY

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.
Hands-on experience with Azure data services (Azure Data Factory, Azure Data Lake, Azure SQL Database, Azure Synapse Analytics).
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.

Related Jobs

View all jobs

Senior Delivery Consultant: Data Analytics & GenAI

Graduate Data Engineer

Data Engineer

Data Engineer

Data Engineer

Senior Data Engineer

National AI Awards 2025

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Jobs

How to Get a Better Data Science Job After a Lay-Off or Redundancy

Redundancy can be tough to face, especially in a competitive field like data science. But it’s important to know: your experience, analytical thinking, and modelling skills are still in demand. Across sectors like healthcare, finance, e-commerce, government and AI startups, UK employers continue to seek data scientists who can deliver value through insight, prediction, and automation. This guide will walk you through how to bounce back from redundancy with purpose and clarity—whether you're a data analyst looking to step up, a mid-level data scientist, or a machine learning specialist seeking a better-aligned opportunity.

Jobs

Data Science Jobs Salary Calculator 2025: Find Out What You Should Earn in the UK

Why last year’s pay survey is already out of date for UK data scientists “Am I being paid enough?” Every data professional eventually asks that question—often after a teammate reveals a hefty counter‑offer, a recruiter shares a six‑figure opening, or a headline trumpets the latest multimillion‑pound AI investment. Yet salary guides published even twelve months ago belong in a museum. Generative‑AI hype re‑priced Machine‑Learning Engineer roles, LLM fine‑tuning turned Prompt Engineering into a genuine career path, & fresh regulation forced companies to hire Responsible‑AI Officers on senior‑scientist money. To cut through the noise, DataScience‑Jobs.co.uk distilled a transparent, three‑factor formula. Insert your role, your region, & your seniority, and you’ll get a realistic 2025 salary benchmark—no stale averages, no vague ranges. This article walks you through the formula, examines the forces pushing data‑science pay ever higher, and offers five concrete actions to boost your market value within ninety days.

Careers

How to Present Data Science Solutions to Non-Technical Audiences: A Public Speaking Guide for Job Seekers

The ability to communicate clearly is now just as important as knowing how to build a predictive model or fine-tune a neural network. In fact, many UK data science job interviews are now designed to test your ability to explain your work to non-technical audiences—not just your technical competence. Whether you’re applying for your first data science role or moving into a lead or consultancy position, this guide will show you how to structure your presentation, simplify technical content, design effective visuals, and confidently answer stakeholder questions.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.