Staff Data Engineer
Noida Office, India
Clearwater Analytics
Clearwater Analytics is the leading provider of investment accounting software for reporting and reconciliation services for institutional investors.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.
About the technology
We leverage a range of technologies to support the development of quality data infrastructure, including:
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.
We would love to hear from you if you have
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.
About Clearwater Analytics
Clearwater Analytics® is a global SaaS solution for automated investment data aggregation, reconciliation, accounting, and reporting. Clearwater helps thousands of organizations make the most of investment portfolio data with cloud-native software and client-centric servicing. Every day, investment professionals worldwide trust Clearwater to deliver timely, validated investment data and in-depth reporting. Clearwater aggregates, reconciles, and reports on more than $8 trillion in assets across many Fortune 500 clients.
If you are passionate about joining a dynamic team and contributing to a world-class technology platform, we invite you to apply and be part of our mission to simplify the investment lifecycle.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow Architecture AWS Confluence Data pipelines Data quality Data warehouse Data Warehousing dbt ELT Engineering ETL Git GitLab Helm Jira OpenSearch Pipelines Privacy Python Security Snowflake Terraform Testing
Perks/benefits: Career development
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.