Maintains and analyzes investment data for clients by organizing raw data, building data systems and pipelines, integrating multiple sources, and improving data quality. Develops analytical tools, performs data mining, creates visualizations and reports, and collaborates with architects, product teams, clients, and project managers to meet business requirements.
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. It also 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.
- Engage directly with clients and project management teams, gaining a deep understanding of customer and company needs.
- Play an integral role in creating, implementing, and maintaining investment data for Clearwater's esteemed clients.
Required Skills:
- Deep understanding of investment data.
- Familiarity with cloud platforms and big data technologies (e.g., AWS, GCP, Azure).
- Understanding of database design and data warehouse principles.
- 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 organizational and interpersonal skills.
- Exceptional problem-solving abilities.
Education and Experience:
- Bachelor’s degree in data analytics, statistics, accounting, computer science, or related discipline.
- 7+ 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.
Clearwater Analytics (CWAN) Chicago, Illinois, USA Office
Located in the heart of the Loop in Downtown Chicago. The office is easy to get to with various train and bus stops nearby.
Similar Jobs at Clearwater Analytics (CWAN)
Fintech • Software • Financial Services
Maintain and integrate investment data; build data systems and ETL pipelines; analyze large datasets; produce visualizations and reports (Tableau/Power BI/D3.js); improve data quality and governance; develop analytical tools; collaborate with clients, system architects, and product teams.
Top Skills:
AWSAzureD3.JsData WarehouseETLGCPJavaMS OfficeNoSQLPower BIPythonSQLTableauVBA
Fintech • Software • Financial Services
Reconciles investment portfolio transactions and holdings against external provider data, investigates discrepancies, updates client reporting, and meets daily deadlines. Builds relationships with clients and data providers, supports workflow improvements and internal projects, analyzes success metrics, mentors analysts, resolves complex issues, and develops training materials. Requires intermediate investment, financial, accounting, and GAAP knowledge, along with strong communication and problem-solving skills.
Fintech • Software • Financial Services
Provide operational support and client relationship management for investment accounting clients. Handle inquiries on financial statements, reconciliations, account setup, compliance, and reporting. Validate investment data, use internal tools and third-party data, manage workflows to meet quality metrics, resolve complex queries, support projects, and coach junior staff.
Top Skills:
MS Office
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
