Technical Data Analyst (SQL)

Posted 8 Days Ago
Be an Early Applicant
Edinburgh, Midlothian, Scotland
3-5 Years Experience
Fintech • Insurance • Software • Analytics
The Role
The Technical Data Analyst is responsible for maintaining investment data for clients, analyzing raw data, building data systems, conducting complex data analysis, and presenting information through data visualization techniques. Collaborates with clients and project management teams to meet customer and company needs, while striving to improve data quality and reliability.
Summary Generated by Built In

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

Top Skills

SQL
The Company
HQ: Boise, ID
1,150 Employees
On-site Workplace
Year Founded: 2004

What We Do

Clearwater Analytics is the leading provider of web-based investment portfolio accounting, reporting, and reconciliation services for institutional investors at thousands of organizations.

Clearwater aggregates, reconciles, and reports on more than $5.5 trillion in assets across thousands of accounts daily. Our clients include corporate treasuries, insurance companies, investment managers, banks, governments, and other institutional investors both in the United States and worldwide.

For more than a decade, we have leveraged web-based software and world-class client service to help clients such as American Family Insurance, Arch Capital, C.V. Starr & Co., Cisco, Facebook, Oracle, Selective Insurance, Sirius Group, Sompo International, Starbucks, WellCare Health Plans, Wilton Re, and many others, streamline their investment and accounting operations. Clearwater also works with hundreds of custodians, investment managers, dealers/brokers, and electronic trading portals who offer Clearwater to their many clients.

With global headquarters in Boise, Idaho, and offices in Edinburgh, London, New Delhi, New York, and Singapore, Clearwater sets the new global standard for investment portfolio reporting.

Jobs at Similar Companies

Fusion92 Logo Fusion92

Account Executive

AdTech • Agency • Digital Media • Enterprise Web • Marketing Tech • Analytics • Web3
IL, USA
263 Employees

ForeFlight Logo ForeFlight

Product Designer II

Aerospace • Software • App development
Remote
Austin, TX, USA
466 Employees

IonQ Logo IonQ

Lead Ion Trap Design Engineer

Artificial Intelligence • Hardware • Information Technology • Internet of Things • Software
Easy Apply
Seattle, WA, USA
305 Employees

Snap Inc. Logo Snap Inc.

Application Engineer, Salesforce UI

Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
Hybrid
New York, NY, USA
5000 Employees

Similar Companies Hiring

Capco Thumbnail
Professional Services • Generative AI • Fintech • Financial Services • Energy • Cybersecurity • Consulting
London, GB
6000 Employees
iCapital Thumbnail
Fintech • Financial Services
New York, NY
1500 Employees
Kin + Carta Thumbnail
Software • Retail • Professional Services • Information Technology • Financial Services • Consulting • Agriculture
Chicago, IL
2000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account