The Role
Clearwater's mission is to be the world's most trusted and comprehensive technology platform that simplifies the entire investment lifecycle. We empower our clients to run efficient investment accounting operations, provide an auditable SaaS platform for integrated investment accounting, analytics, and reporting, foster a diverse and collaborative culture of innovation and excellence, and contribute to our local communities to make a meaningful impact on society.As a Staff Data Engineer at Clearwater, you will play a crucial role in accomplishing our mission. You will be a leading member of the Prism team, which is responsible for managing our external BI reporting platform and the data aggregation pipeline backing it. This team’s product serves as a key data hub for multiple crucial products that rely on Prism Data.In this role, you will
- Lead the design and execution of scalable data architecture strategy, ensuring alignment with business objectives, operational maturity, and long-term maintainability of systems (e.g., warehouses, lakes, pipelines).
- Collaborate cross-functionally with data scientists, analysts, and business stakeholders to translate requirements into reliable, high-quality data solutions that drive decision-making.
- Champion end-to-end ownership of critical data initiatives, driving multi-team, multi-sprint projects from conception to delivery while balancing technical risk and timelines.
- Design and optimize robust data pipelines, ensuring efficient ingestion, transformation, storage, and retrieval while adhering to security, privacy, and compliance standards.
- Mentor engineers of all levels, fostering a culture of knowledge-sharing and operational excellence across teams; act as a trusted technical advisor in ambiguous or complex scenarios.
- Identify and evangelize innovative patterns (e.g., automation, monitoring, testing) to improve data quality, system reliability, and developer velocity organization-wide.
- Spearhead major modernization efforts, including redesigns of legacy systems and adoption of cutting-edge tools to meet evolving analytical and operational needs.
- Embed operational rigor into data products through logging, observability, and documentation, empowering less-experienced teams to debug and extend systems independently.
- Continuously build your skills through regular code reviews, training, mentoring, and access to free trainings on Udemy for Business.
- Snowflake as our enterprise data warehouse, with Airflow for workflow orchestration
- DBT, Prophecy, and Python for developing ELT processes
- Amazon Web Services as our public cloud provider, with configuration controlled by Terraform and Helm
- OpenSearch, Dynatrace, and Snowflake-native tooling for logging and monitoring.
- Git repositories hosted on Gitlab for code management.
- Atlassian (Jira, Confluence), Office365 (including Microsoft Teams), and Zoom for communication.
- Quality hardware to support development and communication on Windows or Mac platforms.
- 9+ years of enterprise data engineering experience (data warehousing, ETL development, data modelling, scalable Enterprise Data Warehouse (EDW) solutions, etc.).
- 5+ years of experience leveraging Snowflake and its various capabilities.
- Examples of leverage dimensional modeling/star schema design concepts in enterprise implementations
- Experience with both DBT and Python development
- Snowflake performance tuning expertise
- Exceptional leadership and mentorship skills.
- Enthusiasm for data engineering work in a software-as-a-service company.
- Driven by client satisfaction.
- Strong communication and teamwork skills.
- Ability to manage own time and deliver expected results on time.
- Commitment to continuous learning and improvement.
- Exceptional problem-solving and analytical skills.
- Experience running data through a public cloud provider.
What the Team is Saying
Dan
Chief Revenue Officer
Andrew
Client Services Regional Lead
Cynthia
Global Head of Quality Assurance
Liz
OEMS Product Owner
Alok
Vice President, Head of Client Enablement - Americas
Dori
Senior Vice President, Business Development
Ahmad
Associate Vice President, OEMS Business Analyst
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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.
Typical time on-site:
Flexible
