Technical Data Analyst (SQL)

Clearwater Analytics (CWAN); City of Edinburgh; On-site; GBP 55,000 - 75,000; Full time

Job summary

Clearwater Analytics (CWAN) is seeking a Technical Data Analyst responsible for maintaining investment data for clients, building data systems, and delivering insights through visualization.

You will merge data from multiple sources, collaborate with clients and project teams, and drive data quality improvements while supporting data-driven decisions across the organization.

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 is a plus.

Responsibilities

• Utilize 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.
• Analyze complex data sets and deliver insightful reports on outcomes.
• Present findings using data visualization techniques to bring data to life.
• Collaborate with system architects and product development teams to enable data-driven decisions.
• Continuously explore methods to improve data quality and reliability.

Skills

Cloud platforms

Big data

SQL

Python

VBA

Data visualization

Data governance

Data cleansing

Attention to detail

Documentation

Communication

Problem-solving

Teamwork

Education

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

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 haveKnowledge 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 databasesExperience 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