Technical Data Analyst (SQL)

Clearwater Analytics, LLC; City of Edinburgh; On-site; GBP 48,000 - 72,000; Full time

Job summary

Clearwater Analytics, LLC is seeking a Technical Data Analyst to maintain investment data for clients and build robust data systems and pipelines. You will analyze complex datasets, present findings through visualizations, and collaborate with clients and project teams to align data with business needs.

The role emphasizes merging data from diverse sources, improving data quality, and delivering actionable insights to drive decisions and product development.

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.

Responsibilities

• Analyze and organize raw data to generate valuable insights.
• Build robust data systems and pipelines to ensure smooth data flow.
• Perform complex data analyses and deliver insightful reports.
• Present findings using data visualization techniques.
• Integrate multiple data sources to deliver actionable insights.
• Improve data quality and reliability continuously.
• Develop analytical tools to empower data-driven decisions.
• Collaborate with system architects and product teams to innovate.

Skills

Cloud platforms

Data modeling

SQL

NoSQL

Data visualization

Data cleansing

Data governance

Python

Communication

Organizational skills

Problem solving

Education

Bachelor’s degree in data analytics

4+ years data analytics experience

Tools

Tableau

Power BI

D3.js

dbt/Prophecy

Job description

"

Job Summary

The Technical Data Analyst is responsible for maintaining 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.

About the Company

Thank you for your interest in a career with Clearwater! Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud-native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single-instance, multi-tenant architecture delivers real-time data and AI-driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at www.clearwateranalytics.com.

Equal Opportunity / Diversity Statement

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with the job description, we encourage you to still apply! You may be just what we're looking for.

"