The Senior Technical Data Analyst manages investment data, performs complex analysis, builds data systems, and collaborates with clients and teams to enhance data quality.
Job Summary:
- Design and build scalable data pipelines using Snowflake dbt and Prophecy to prepare datasets for reporting and analysis.
- Collaborate with analysts and client teams to translate reporting requirements into efficient data models, views, and BI-ready tables.
- Integrate multiple structured and semi-structured investment data sources into centralized analytical datasets for dashboards and reports.
- Develop and maintain business intelligence solutions (PRISM, GoodData) — from building datasets to creating clear, insightful visualizations.
- Ensure reporting accuracy by implementing data validation checks, quality frameworks, and governance standards.
- Partner with product, project management, and architecture teams to align data infrastructure with reporting objectives.
- Optimize data workflows for performance, scalability, and cost efficiency in AWS.
- Document data schemas, transformation logic, and reporting workflows for transparency and knowledge sharing.
- Continuously enhance reporting capabilities by leveraging emerging tools, automation, and improved data delivery methods.
- Serve as a reporting subject matter expert, ensuring that stakeholders fully understand and can act on the data presented.
Qualifications
- Bachelor’s degree in data engineering, analytics, computer science, or related discipline (or equivalent experience).
- 2+ years working in data engineering or analytics engineering roles with a strong focus on reporting deliverables.
- Strong proficiency in SQL (including performance tuning) and familiarity with NoSQL databases.
- Experience with Snowflake and dbt/Prophecy for data ingestion, transformation, and modeling for reports.
- Understanding of database design and data warehouse principles
- Client-centric mindset
- Proven experience building reports and dashboards in Tableau, Power BI, GoodData, or similar BI platforms.
- Knowledge of data warehouse concepts, dimensional modeling, and best practices for reporting datasets.
- Familiarity with cloud technologies (AWS, GCP, Azure) for hosting and optimizing reporting pipelines.
- Proficiency in one or more programming languages (Python preferred; Java, Scala, VBA, etc. a plus).
- Understanding of data governance and compliance requirements in financial or investment contexts.
- Strong problem-solving, communication, and collaboration skills.
- High attention to detail, with a commitment to delivering accurate and actionable reporting.
Top Skills
AWS
Azure
D3.Js
GCP
Java
MS Office
NoSQL
Power BI
Python
SQL
Tableau
VBA
Similar Jobs at Clearwater Analytics (CWAN)
Fintech • Software • Financial Services
The LP Project Manager oversees private equity funds, manages relationships with limited partners, conducts due diligence, and leads strategic initiatives while ensuring compliance and performance monitoring.
Top Skills:
Financial Analysis SoftwareMicrosoft Office Suite
Fintech • Software • Financial Services
The Data & Recon Division Lead manages a large team, oversees operational resources, and implements strategies to improve division performance while ensuring effective communication and leadership across the organization.
Top Skills:
JIRAMS OfficePythonSQL
Fintech • Software • Financial Services
This role involves analyzing business requirements, documenting data processes, and collaborating with technical teams to improve efficiency and maintain data integrity.
Top Skills:
ExcelPower BISQLTableau
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
