Data Modeller

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

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., * 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.

• 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.