Jobs › Companies › Clearwater Analytics › Technical Data SME (SQL)

Über diese Technical Data SME (SQL) Stelle bei Clearwater Analytics

Clearwater Analytics · Vor Ort · Office - Edinburgh

Job Summary:
The Technical Data SME is the domain authority for investment data across client engagements, responsible for the quality, integrity and reliability of the client reporting and investment data delivered to clients. This role involves designing and overseeing data systems and pipelines, leading complex data analysis, and presenting insights through advanced data visualisation techniques. The SME collaborates with clients, project management and architecture teams to define customer and company needs, and acts as a senior technical point of contact. This role requires the ability to merge data from multiple sources and present it in alignment with customer and company requirements, while setting standards and driving continuous improvement in data quality and reliability.


Responsibilities:

  • Act as the subject matter expert for investment data, providing authoritative guidance on data structures, sourcing, transformation logic and reporting outputs.
  • Design, build and optimise efficient, scalable data systems and pipelines, ensuring seamless data flow at volume.
  • Lead deep-dive analysis of complex data sets and root cause investigations, delivering clear recommendations and insightful reports to technical and non-technical stakeholders.
  • Design and deliver advanced data visualisation and reporting solutions that bring data to life and support data-driven decision making.
  • Lead the integration of complex multi-source data into consistent, comprehensive and client-ready outputs.
  • Define and drive the strategy for data quality and reliability, establishing controls, monitoring and remediation approaches that uphold the highest standards.
  • Develop and implement analytical tools and programmes that empower teams and clients to make data-driven decisions.
  • Partner with system architects and product development teams to shape data architecture, influence the technical roadmap and evaluate new technologies.
  • Define and maintain data standards, design patterns and best practices, and champion data governance across teams and client engagements.
  • Serve as the senior technical contact for clients, advising on solutions, managing expectations and representing the data function in escalations.
  • Work with project management to scope work, assess risk and shape delivery plans and timelines.
  • Coach and mentor analysts and junior team members, reviewing work and raising technical capability across the team.

Required Skills:

  • Deep expertise in investment data, including its structures, lifecycle and common data challenges.
  • Extensive hands-on experience with SQL and NoSQL databases.
  • Advanced knowledge of cloud platforms and big data technologies (e.g. AWS, GCP, Azure).
  • Strong command of database design and data warehouse principles, including modelling for scale and performance.
  • Proven experience designing and delivering data integration and ETL/ELT processes.
  • Expert-level data manipulation, data cleansing and transformation techniques.
  • Strong knowledge of data governance and best practices in data management.
  • Proven ability to work with large datasets and perform data mining at scale.
  • Track record of leading complex, client-facing data projects from design through to delivery.
  • Demonstrated ability to lead technical decision making and influence senior stakeholders.
  • Proven ability to mentor others and raise team capability.
  • Continuous improvement mindset for self and team.
  • Ability to work collaboratively in a cross-functional team environment.
  • Strong computer skills, including proficiency in Microsoft Office.
  • Excellent attention to detail and strong documentation skills.
  • Outstanding verbal and written communication skills, including presenting to clients and leadership.
  • Strong organisational and interpersonal skills.
  • Exceptional problem-solving abilities, with the ability to resolve ambiguous, complex issues independently.

Education and Experience:

  • Bachelor's degree in data analytics, statistics, accounting, computer science, or a related discipline (advanced degree desirable).
  • 7+ years of relevant experience in data analytics, reporting and visualisation, including experience in a senior or lead capacity.
Bereit, sich bei Clearwater Analytics zu bewerben?
Bei Clearwater Analytics bewerben

Über Clearwater Analytics

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, corpora

Alle Jobs bei Clearwater Analytics ansehen →

Ähnliche Jobs

Clearwater Analytics
Product Marketing Manager - Hedge Funds
Clearwater Analytics
⚡ Früh bewerben Office - New York Vor Ort $102,000–$144,000
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Assistant General Counsel
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Staff Quantitative Developer, FX
Clearwater Analytics
⚡ Früh bewerben Office - London Vor Ort $179,400–$243,136
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Client Servicing Analyst - New Graduates
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Client Servicing Analyst - New Graduate
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Data Migration Specialist
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort $62,000–$85,000
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Prism Team Lead
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 1 Tg.
Clearwater Analytics
Senior Software Development Engineer
Clearwater Analytics
⚡ Früh bewerben Office - Noida Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 2 Tg.
Clearwater Analytics
Sr. Solutions Consultant
Clearwater Analytics
⚡ Früh bewerben Office - Boise Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 2 Tg.

Registrieren für Vorschläge, die auf die von Ihnen geöffneten Jobs und gespeicherten Suchen zugeschnitten sind.

Mehr Jobs bei Clearwater Analytics

Alle Jobs bei Clearwater Analytics ansehen →

Jetzt bewerben
🤖

Moment — langsam

JobsRadar wurde für echte Menschen gebaut, die eine schwere Zeit bei der Jobsuche haben — nicht für automatisierte Anfragen. Sie klicken viel zu schnell und sind jetzt vorübergehend blockiert.

Kommen Sie später wieder. Wenn Sie wirklich auf Jobsuche sind, stehen wir hinter Ihnen — verhalten Sie sich einfach wie ein Mensch.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Verschaffe dir einen Vorsprung bei der Jobsuche.

Tritt unserem Telegram-Kanal bei für das, was dir hilft, die Stelle zu bekommen — Gehaltsbenchmarks, den wöchentlichen Marktpuls und neue Feature-Drops. Kein Spam, nur Signal.

Dem Kanal beitreten — kostenlos