Jobs

Technical Data Analyst (SQL)


Job details
  • Clearwater Analytics
  • Edinburgh
  • 3 months ago

Job Summary:

The Technical Data Analyst is responsible formaintaining 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

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Technical Data Analyst

This job is with Munich Re, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ business community. Please do not contact the recruiter directly. Together, we engage with everything we have and are, to help humankind act braver and better. About Great Lakes...

myGwork London

Technical Data Analyst (SQL)

Job Summary:The Technical Data Analyst is responsible formaintaining 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...

Clearwater Analytics Edinburgh

Senior Technical and Data Analyst

Job Description:Functional Consultant - Finance and Data TechnologyLocation London (EC2R 7HJ) Hybrid working options (up to 3/4 days WFH)Permanent - Full time 35 hoursCompetitive Salary depending on experience and fantastic benefitsWe make health happenAt Bupa, our purpose is to help our customers to live longer, healthier, happier lives. This means...

Bupa Central London

Data Analyst Technical Trainer – Skills Bootcamps

Just IT is about making careers happen. As a national multi award-winning company operating for over 20 years, we support learners through our unique offering of Apprenticeships, Recruitment and Training services.Having been acquired by The B2W Group in , the leading national adult learning and pre-employment training provider, we are...

Just IT London

Data Analyst / System Configuration Coordinator

Technical Staffing Resources (TSR) are the in-house agency and master vendor for KBR who are a leading global engineering, construction, and services company.KBR support the hydrocarbon and government services markets on six continents. Serving their customers through diverse business units, KBR offer challenging assignments on some of the world's largest...

Technical Staffing Resources Oxford

Data Analyst - Water Asset Management

Data Analyst - Water Asset ManagementThe RPS Water Consultancy business is currently looking to appoint a Data Analyst. Our Data Analysts work within our team to provide specific data management support on water and / or wastewater projects to drive increased intelligence for internal and/or external benefit, enhance data driven...

RPS Group Edinburgh