JOB SPECIFICATION Reports to: Senior Data Analyst Contract: Permanent Based: Glasgow HQ, with occasional travel to regional offices (St Albans and Altrincham) Salary: up to £45,000 Flexible working: Ability to work between home and office flexibly. ABOUT PRIME SECURE We are an award-winning, privately-owned, Glasgow-headquartered business providing security and facilities service to our blue-chip customer base across the UK. We are growing quickly and have ambitious plans to achieve a turnover of £50m per annum by 2030. ABOUT THE ROLE We are looking for a Data Engineer to support the ambitious growth plans of the business. The Business Transformation team is at the very start of an extremely exciting journey, which makes this role a fantastic opportunity for someone who is ambitious and really wants to make an impact and demonstrate their skills in this field. As a Data Engineer, you will play a crucial role in ensuring the effective and efficient management of data within our organisation. You will be responsible for designing, developing, and optimising data pipelines and systems, as well as analysing and interpreting large datasets to drive actionable insights and inform decision-making. As a member of our dynamic team, you will have the opportunity to contribute to the development of innovative solutions to make our business and IT operations more efficient and help unlock the power of our Data. You will collaborate closely with cross-functional teams to understand and address their data needs and challenges. The ideal candidate is a detail-oriented problem solver with a strong understanding of data engineering principles and hands-on experience with data visualization tools, SQL, Python, Cloud Infrastructure, and ETL pipelines. Our core values: Integrity Customer Excellence Plain-Speaking Agility Courage & Conviction WHO YOU ARE You are an effective communicator who is comfortable with working within the organisation and with external organisation. You have excellent written and verbal communication skills. You have strong problem-solving skills and attention to detail. You are proactive and focused on continuous improvement. KEY RESPONSIBILITIES As Data Engineer, you will be accountable for supporting our Business Transformation and Innovation strategy and as such, we see the key responsibilities of the role as being: Design, develop, and maintain efficient and scalable data pipelines and ETL processes Collaborate with cross-functional teams to gather and understand data requirements Set up and maintain cloud infrastructure, focusing on integration services and data warehouses Optimise and tune data pipelines for performance and scalability Perform data validation, cleansing, and transformation tasks to ensure data quality and integrity Develop and implement data storage and retrieval solutions Design and build data models and schemas to support business analytics and reporting Work with our Data Analysts to analyse and interpret large datasets, to identify trends, patterns, and relationships Monitor and troubleshoot data platforms to ensure smooth and efficient operations. REQUIREMENTS Proven experience as a Data Engineer or a similar role Strong proficiency in SQL and knowledge of database technologies such as PostgreSQL, Microsoft SQL, Oracle, or MySQL Experience in Cloud Infrastructure (Azure, AWS, Google Cloud) Proficiency in Web APIs (REST, GraphQL, SOAP) and in setting up and maintaining integrations Experience with ETL tools and frameworks such as Data Factory, Fivetran, Stitch, or Apache Spark Proficiency in programming languages such as Python, R, or JavaScript Familiarity with data visualisation tools such as Power BI, Tableau, or Qlik Sense Strong problem-solving skills and attention to detail. At Prime Trading Group, we value the diversity of our people and the varied experiences, expertise, backgrounds, and perspectives they bring. We work hard to foster a culture where those differences can thrive and where every one of us can fulfil our potential. Due to the nature of our business all employees are Security screened to BS 7858:2019 standard. For people who do not currently hold a SIA License a Basic Disclosure check will be included within the screening process. As a fair and ethical employer, in accordance with guidelines taken from the 2010 Equality Act, Prime Secure Systems Ltd is committed to promoting equal opportunities for all: irrespective of colour, race, religion or belief, ethnic or national origins, gender, marital/civil partnership status, sexuality, disability or age. Job Types: Full-time, Permanent Pay: Up to £45,000.00 per year Benefits: On-site gym Paid volunteer time Referral programme Work from home Schedule: Monday to Friday Experience: Data Engineer: 1 year (required) Work Location: In person