Average Data 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.

Do you have a Finance, Accounting, Business, or STEM degree and enjoy data analysis and inputting, or have you previously held a role identifying, loading, and validating invoices, both manually and electronically? Our client, a global software service provider, has four six-month contract vacancies to fill. You will need to have working knowledge of Microsoft Office Suite (Outlook, Excel, Word, PowerPoint) and data entry systems, and have a high level of accuracy along with excellent customer service experience and good communication skills, both written and verbal. This is a hybrid position, so must be within a commutable distance of their offices in central Edinburgh. Please ensure you have the right to work in the UK and do not require any sponsorship. Apply now to Karen at Jump IT

Are you looking to benefit from a new career in Data Analysis? If you are detail orientated, perceptive, organised, competent, analytical and can communicate well with those around you; you could have a truly rewarding future as a Data Analyst We do this using our specialised Data Analyst career programme which looks to assist and place qualified candidates into a career pathway in Data Analysis. Please note this career program is designed for entry level individuals with limited or no experience, so please do not apply if you are already an experience Data Analyst as we will be looking primarily at entry level roles. Demand for Data Analysts has grown 20% year on year with experienced analysts easily commanding salaries of £50k+. All business decisions rely on data to ensure correct business decisions are made and therefore the role of the data analyst in the new digital world has become essential for business owners. Below are current average salaries in the sector for lower-level positions and fully trained Data Analysts: Junior Data Analyst - £30,000Data Analyst - £50,000Business Data Analyst - £67,500Data Analytics Analyst - £80,000Business Analysts - £60,000 Using our experience in providing data analysis and business analysis training online and through our expert recruitment consultants, we can provide a seamless journey and often fast-tracked route into a new career in Data Analysis. The courses in the package have been identified by our recruitment partners as industry standards for the UK/European and International Data Analysis sector. Skills shortages across all sectors are increasing the demand for qualified, entry-level career seekers and career changers. Whether you are working full-time, part-time or are unemployed, this job and recruitment package has the flexibility to be completed at a pace that suits you and can be completed in a few weeks. Your job and career goals are completed in 4 easy steps listed below. Step 1 - CompTIA Data+ Qualification The first step is completing the CompTIA Data+ Qualification accredited by CompTIA. This professional international industry-recognised qualification teaches you the essential skills of a Data Analyst. You will cover skills such as data mining, manipulating data, visualising data, and reporting on data. Study time for the qualification is approximately 30 hours and qualification is achieved by completing a 1-hour multiple choice exam. The course is provided online and comes complete with exam simulators and revision tools. You will be provided with access to a tutor and a 1-hour online revision workshop prior to sitting your exam. This qualification will set you on a route to becoming a data analyst. Step 2 - Data Administration Training Data is extracted using various method which are normally IT driven. Therefore, we will provide you with access to the following additional courses to ensure you are suitably employable as a data analyst. Microsoft excel - to expert level.Learn SQL - the programming language used for extracting data from more complex databases.Learn Python 3 - Python 3 is a simple to use programming language used by many analysts.Learn Tableau - Tableu is a tool which analysts use to build visually appealing dashboards for complex data making it easier for stakeholders to comprehend. Study time for these courses is approximately 30-60 hours and qualification is achieved through completion of the course with no exam. Step 3 - Business Analysis Foundation Business Analysts and Data Analysts often work very closely together and indeed many Data Analysts become Business Analysts and vice versa. Adding a Business Analyst Foundation certificate will make you much more employable and enable you to cross over into business analyst roles and hybrid roles. Business Analysis Foundation accredited by the BCS (The British Computer Society also known as the Chartered Institute of IT). Study time for this course is approximately 15 hours and qualification is achieved through an online BCS exam. Step 4 - Recruitment Support Now you are qualified for an entry level data analyst position our recruitment support team will now begin collaborating with you to help you secure your first a suitable role based on your new qualifications and any other experience you may have. We have been helping candidates start and build careers in the project management industry since 2007 and have a 4.8 Trustscore on Trustpilot. Our Recruitment Support team will help you work through job applications, interviews and provide you with a full cv review based around your new qualification and written to maximise your chances of obtaining a role in the project management sector. They will provide you with guidance as to which roles our most suitable for you as an entry level project sector worker aiming to become a project manager. This will include mock job interviews as well as any help you feel you need. Our money back guarantee If after 1 year of passing your formal qualifications, we have been unable to help you secure a role, we will refund your study fees minus the cost of the exams. However, we are normally able to help candidates find their first role within 6 months of qualifying and for locations based close to major cities this is often reduced to less than 3 months. Check our testimonials from the hundreds of candidates we have already helped. What Now? To accommodate candidates, the training element of the package is available on finance terms of up to 1 year. This enables you to get qualified and start in your new role without having to fund all the training costs up front. Enquire now and one of our experienced Career Consultants will contact you within 4 working hours to answer any questions that you may have and to assist you in taking the first step towards your Data Analyst Career aspirations.