Investment Data Analyst: Build Pipelines & Visuals

Clearwater Analytics; City of Edinburgh; On-site; GBP 50,000 - 75,000; Full time

Job summary

Clearwater Analytics is seeking a Technical Data Analyst to manage and analyze investment data, build data systems, and present insights through visualization. You will collaborate with clients and product teams to understand needs and drive data-driven decisions.

The role requires strong SQL/NoSQL experience, cloud platforms (AWS, GCP, Azure), and proficiency in visualization tools like Tableau or Power BI. A 4+ year track record in analytics is expected.

Qualifications

• 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

Responsibilities

• Analyze and organize raw data, transforming it into valuable insights.
• Build efficient data systems and pipelines for seamless data flow.
• Dive into complex datasets, conduct thorough analysis and deliver insightful reports.
• Showcase findings using data visualization techniques.
• Harness multiple data sources to create actionable insights.
• Continuously improve data quality and reliability.

Skills

AWS

GCP

Azure

SQL

NoSQL

Python

Data manipulation

Data governance

Communication

Team collaboration

Data mining

Excel

Education

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

Tools

Tableau

Power BI

D3.js

Job description

Clearwater Analytics is seeking a Technical Data Analyst to manage and analyze investment data, build data systems, and present insights through visualization. You will collaborate with clients and product teams to understand needs and drive data-driven decisions.

The role requires strong SQL/NoSQL experience, cloud platforms (AWS, GCP, Azure), and proficiency in visualization tools like Tableau or Power BI. A 4+ year track record in analytics is expected.