Average Control Analyst salary in Edinburgh

We are looking for a skilled Data Engineer with expertise in SQL Server, Teradata and Snowflake to join our team. The role involves designing, developing, and maintaining ETL processes to transfer data from source systems into Snowflake, Teradata and SQL Server. You will optimize database performance and work on creating scalable data pipelines for large datasets. Collaboration with data scientists, analysts, and business teams is essential for defining and implementing data strategies. Strong experience in SQL Server (T-SQL, stored procedures, optimization), and Teradata and Snowflake architectures is required. The role also includes troubleshooting and improving existing data systems for efficiency and performance. You will handle data migration and integration tasks from legacy systems into Snowflake. Knowledge of cloud platforms (AWS, Azure, Google Cloud) and data warehousing best practices is necessary. Proficiency in data modelling and ETL tools is expected. A degree in Computer Science or related fields, along with strong communication and problem-solving skills, is preferred. Responsibilities: Design, develop, and maintain ETL processes to move data from source systems to Snowflake, Teradata and SQL Server environments.Build scalable data pipelines for processing and storing large datasets.Collaborate with analysts and business stakeholders to define and implement data strategies.Optimize database performance, including query optimization, indexing, and partitioning across all enterprise data platforms.Work with cross-functional teams to gather requirements and develop effective data solutions.Ensure data quality, consistency, and integrity throughout the data lifecycle.Maintain and improve existing data architectures and workflows to meet business requirements.Create and maintain documentation for data systems, pipelines, and processes.Monitor and troubleshoot data pipeline performance issues and resolve them promptly.Assist in the migration and integration of data from legacy systems into Snowflake, and other strategic data stores. Perform data transformation tasks using SQL, Snowflake SQL, and relevant data processing tools. Required Skills and Qualifications: Proven experience working with SQL Server (e.g., T-SQL, Stored Procedures, Indexing, Query Optimization, System Catalog Views).Strong experience in Snowflake architecture, including data loading, transformation, and performance tuning.Proficient in ETL processes using tools such as Informatica PowerCenter and BDM, AutoSys, Airflow, and SQL Server Agent.Experience with cloud platforms preferably AWS.Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Athena, S3 and IAM.Solid understanding of data warehousing principles and best practices.Strong proficiency in SQL for data manipulation, reporting, and optimization.Knowledge of data modelling and schema design.Experience working with large, complex datasets and implementing scalable data pipelines.Familiarity with version control tools such as GitLab.Experience with data integration, data governance, and security best practices.TSYS experince & knowledge of credit cards data Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.

Your new company and role Hays' client is a public sector organisation which is seeking an experienced systems business analyst to join their Digital Delivery team. You will be part of an established agile delivery team working to deliver a new back-office database and associated reporting applications.This is a fast-paced, delivery-focused role where working independently whilst collaborating effectively within the wider team is key.What you'll need to succeed Essential Skills Data Design and Modelling within an systems implementation environment to support business requirements.Proficiency in taking business requirements and transforming these into a technical solution.Proficiency in documenting functional specifications.Provide feedback on technical solutions and data models to business analysts and development teams.Proficient in PL/SQL and SQL.Proven experience in database development. Design, develop and modify relational database objects, including Tables, View, Packages, Triggers and Indexes.Familiarity with CI/CD practices and tools (e.g., MS DevOps).Experience with version control systems (e.g., Git).Understanding and experience with Agile methodologies. What you need to do nowIf you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career. Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk

Asbestos Analyst Edinburgh Up to £36,000 (Based on experience) An ambitious Asbestos Analyst eager to join a dynamic team, contribute to business growth, and make an immediate impact. If this aligns with your goals, we would love to hear from you, as you would be the ideal candidate for my client. My client is one of the UK's leading environmental compliance and risk management consultancies, renowned for helping some of the nation's largest and most respected organisations protect the health and safety of their people, the broader community, and their reputation. As the Asbestos Analyst for my client, they are seeking a proactive individual who can collaborate effectively with the team to support the company's goal of preventing accidents, occupational ill health, and eliminating workplace hazards through effective risk management, to the greatest extent reasonably practicable. Given the responsibilities of the role, my client offers a generous benefits package, including a competitive salary, company mobile, company van, and a fuel card. Key Responsibilities you will hold as an Asbestos Analyst: Air SamplingFibre countingUndertake clearance air testing, reassurance monitoring and personal monitoringCheck all locations are photographed and photographs are downloaded onto servers appropriatelyMonthly reporting of exposure records and RPE inspectionsEnsuring all equipment is correctly calibrated and tools are correctly maintained to specified level in HSG 264 Asbestos Analyst Requirements: BOHS P403 and P404 QualificationsFull UK driving licenceIOSH Working Safely Qualification desirableValid IPAF Licence desirableValid confined space entry and escape certificate desirableRisk assessment in training desirable Commutable Locations: GlasgowStirlingLivingston