Technical Data Analyst (SQL)
Role Overview
Maintains investment data for clients and analyzes, organizes, and combines raw data from multiple sources.
Builds data systems and pipelines, performs complex analysis, presents findings through visualization, and improves data quality and reliability.
Works with clients and project management teams to understand customer and company needs.
Key Skills for This Role
Full Job Posting
Role summary
Maintains investment data for clients and analyzes, organizes, and combines raw data from multiple sources.
Builds data systems and pipelines, performs complex analysis, presents findings through visualization, and improves data quality and reliability.
Works with clients and project management teams to understand customer and company needs.
Responsibilities
- Analyze and organize raw data; build robust data systems and pipelines.
- Analyze complex datasets and report outcomes; present findings through data visualizations.
- Combine data from multiple sources into actionable insights aligned with customer and company requirements.
- Improve data quality and reliability; develop analytical tools and programs for data-driven decisions.
- Collaborate with system architects and product development teams.
Education and experience
- Bachelor’s degree in data analytics, statistics, accounting, computer science, or a related discipline.
- 4+ years of relevant experience in data analytics, reporting, and visualization.
- Hands-on experience with SQL and NoSQL databases, and data integration and ETL processes.
- Experience with data visualization tools such as Tableau, Power BI, or D3.js.
Required skills
- Familiarity with cloud platforms and big data technologies such as AWS, GCP, or Azure.
- Understanding of database design and data warehouse principles.
- Knowledge of one or more programming languages, such as Java, Python, or VBA.
- Proficiency in data manipulation and cleansing; knowledge of data governance and data management best practices.
- Ability to work with large datasets and perform data mining; proficiency with Microsoft Office.
- Attention to detail, documentation, communication, organization, collaboration, interpersonal, and problem-solving skills.
Preferred knowledge
Investment data knowledge is described as good to have.
Familiarity with dbt/Prophecy is good to have but not essential.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Clearwater Analytics (CWAN)
Financial Data Analyst
Boise, USA
Clearwater Analytics is seeking a Financial Data Analyst to maintain and validate client asset and reference data. The role requires advanced Excel, SQL, strong attention to detail, and a bachelor's or master's degree in
Implementations Team Lead
Edinburgh, GBR
Clearwater Analytics is seeking an Implementations Team Lead to lead a team and oversee client onboarding to its SaaS platform. The role combines hands-on client delivery, people development, performance tracking, and co
Implementation Analyst
Boise, USA
Clearwater Analytics seeks an Implementation Analyst to onboard new clients onto its SaaS platform and service model. The role involves assessing client requirements, customizing solutions, training users, and troublesho
Implementation Analyst
Boise, USA
Clearwater Analytics seeks an Implementation Analyst to onboard new clients onto its SaaS platform and service model. You will assess client requirements, customize solutions for accounting, compliance, performance, risk
Lead Implementation Associate
Boise, USA
Clearwater Analytics seeks a Lead Implementation Associate to support the onboarding of new clients onto its SaaS platform. You will work with clients and cross-functional teams to gather requirements, configure solution
Implementation Analyst
Boise, USA
Clearwater Analytics seeks an Implementation Analyst to onboard new clients onto its SaaS platform and service model. You will assess client requirements, customize solutions for accounting, compliance, performance, risk
Quantitative Financial Analyst I
Boise, USA
Clearwater Analytics seeks an early-career quantitative developer to implement, test, and maintain financial models, calculation libraries, and data pipelines. Candidates need a completed or near-completed quantitative m
Reconciliation Associate
, IND
Clearwater Analytics seeks a Reconciliation Associate to compare investment portfolio data and provide accurate daily client reporting. The role investigates reconciliation issues and requires finance or accounting knowl
Financial Data Analyst
Boise, USA
Implementations Team Lead
Edinburgh, GBR
Implementation Analyst
Boise, USA
Implementation Analyst
Boise, USA
Lead Implementation Associate
Boise, USA
Implementation Analyst
Boise, USA
Quantitative Financial Analyst I
Boise, USA
Reconciliation Associate
, IND