Technical Data Analyst (SQL)

Clearwater Analytics

Edinburgh

1 year ago

Applications closed

Related Jobs

View all jobs

Technical Data Analyst

Technical Data Analyst Associate

Senior Data Analyst - Power Bi

Marketing Data Analyst

Data Engineer / Analyst

Senior Data Analyst

Job Summary:

The Technical Data Analyst is responsible formaintaining investment data for clients. This role involves tasks such as analyzing and organizing raw data, building data systems and pipelines, conducting complex data analysis, and presenting information through data visualization techniques. Additionally, the analyst collaborates with clients and project management teams to grasp customer and company needs. This role requires the ability to merge data from various sources and present it in alignment with customer/company requirements, while also striving to improve data quality and reliability.

Responsibilities:

Utilize your analytical expertise to decipher and organize raw data, transforming it into valuable insights.

Build efficient and robust data systems and pipelines, ensuring seamless data flow.

Dive into complex data sets, conducting thorough analysis and delivering insightful reports on outcomes.

Showcase your findings using cutting-edge data visualization techniques, making data come to life.

Harness the power of multiple data sources, combining raw information into comprehensive and actionable insights.

Continuously explore innovative methods to improve data quality and reliability, contributing to the highest standards.

Develop and implement analytical tools and programs that empower teams to make data-driven decisions.

Collaborate closely with system architects and product development teams, fostering an environment of innovation and excellence.

Required Skills: 

Familiarity with cloud platforms and big data technologies (e.g., AWS, GCP, Azure).

Understanding of database design and data warehouse principles.

Strong understanding of investment data, good to have

Knowledge of one or more programming languages (e.g. Java, Python, VBA).

Proficiency in data manipulation and data cleansing techniques.

Knowledge of data governance and best practices in data management.

Continuous improvement mindset for self and team.

Ability to work collaboratively in a cross-functional team environment.

Ability to work with large datasets and perform data mining tasks.

Strong computer skills, including proficiency in Microsoft Office.

Excellent attention to detail and strong documentation skills. 

Outstanding verbal and written communication skills.

Strong organisational and interpersonal skills. 

Exceptional problem-solving abilities. 

Education and Experience:

Bachelor’s degree in data analytics, statistics, accounting, computer science, or related discipline.

4+ years of relevant experience in data analytics, reporting, and visualization.

Hands-on experience with SQL and NoSQL databases

Experience with data integration and exchange, transfer, load processes.

Experience with data visualization tools such as Tableau, Power BI, or D3.js.

Familiarity with dbt/Prophecy good to have, but not essential

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Feb 10, 2026

Careers

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

Feb 3, 2026

Jobs

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

Jan 23, 2026

Education

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.