Data Modeller

Sword Group; Glasgow; Hybrid; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Competitive Salary

Personalized Career Development

Flexible working

Comprehensive benefits package

Diversity and inclusion initiatives

Job summary

A leading tech company in Scotland is seeking a data analyst/data engineer with strong SQL and Python skills. The role involves building and maintaining analytics layers, collaborating on data models, and managing data flows end to end. Candidates should have a minimum of 5 years in analytics engineering or data analysis. This position offers competitive salary, personalized career development, and flexible working arrangements. Join a diverse team and contribute to impactful data insights in a supportive environment.

Qualifications

• 5+ years of experience in analytics engineering, data engineering or data analysis.
• Excellent SQL skills, including complex queries and performance tuning.
• Solid Python skills for ETL/ELT and data wrangling.

Responsibilities

• Build and maintain the analytics layer of our client's data environment.
• Partner with analysts and finance to define core product and business metrics.
• Own data flows end to end, from event tracking through ETL/ELT pipelines.

Skills

SQL

Python

Data Modelling

ETL/ELT

Business Intelligence Tools

Tools

Looker

Tableau

PowerBI

Git

Job description

We are looking for a data analyst/data engineer with strong SQL & Python skills who loves organising and modelling data.

5+ years of experience in analytics engineering, data engineering or data analysis with strong transformation ownership.

Location: Scotland

About The Role

• Build and maintain the analytics layer of our client's data environment, including data transformations, marts and semantic models.
• Partner with analysts and finance to define and implement core product and business metrics in the BI layer.
• Provide clean, well‑documented datasets and BI models that accelerate experimentation, product insights and reporting.
• Apply validation, testing and documentation standards to ensure high quality and trust in our data.
• Collaborate with the data platform team on ingestion, architecture and performance optimisation.
• Own data flows end to end, from event tracking definitions through ETL/ELT pipelines to ready‑made datasets and dashboards.
• Help define and enforce standards for how data models are stored, queried and shared across the company.

Requirements

• Excellent SQL skills, including complex queries, window functions and performance tuning.
• Solid Python skills for ETL/ELT, data wrangling and workflow automation.
• Experience with data modelling techniques such as star schemas and dimensional modelling.
• Familiarity with modern data warehousing concepts including ELT and optimisation.
• Experience building metrics layers or standardising business metrics is desirable.
• Knowledge of testing and version control practices (Git, CI/CD).
• Understanding of product subscription metrics is an advantage.
• Experience with BI tools such as Looker, Tableau, PowerBI.

Benefits

• Competitive Salary.
• Personalised Career Development: customised development plan, learning and development opportunities.
• Flexible working: flexible work arrangements to support work‑life balance.
• A fantastic benefits package including generous annual leave, enhanced family‑friendly benefits, pension scheme, access to private health, well‑being and insurance schemes, employee assistance programme, discounted cash plan and more.
• Diversity and inclusion: we are an equal‑opportunity employer and embrace diversity in all its forms. We encourage all applicants to apply regardless of age, disability, gender identity or reassignment, marital or civil partner status, pregnancy or maternity status, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation. Your perspective and potential are important to us.
• Support for accessible hiring process and adjustments if needed.

Seniority level: Entry level

Employment type: Full‑time

Job function: Information Technology; Industries: IT Services and IT Consulting