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
What We Do
CWAN was founded on a simple belief: investment professionals deserve modern technology that actually works for them. Not legacy systems that slow them down. Not fragmented data that creates confusion. But one comprehensive platform that gives you complete visibility and crystal-clear insights.
The result? Investment management that works as seamlessly as your investment strategy.
Since our founding in 2004, CWAN has been the trusted technology partner powering the world’s leading institutional investors — from insurance companies, asset managers, and hedge funds to asset owners like corporations, endowments, and pension funds managing over $10 trillion in assets.
Why Work With Us
We continue to grow, fueled by a strong foundation, an ambitious vision, and a commitment to delivering exceptional value to our clients, partners, and team members around the world.
What started as a bold idea in Boise, Idaho has rapidly transformed into a global presence. We’ve expanded our footprint significantly—now operating out of 24 offices
Gallery
Clearwater Analytics (CWAN) Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
