- Minimum of 4 years of related experience
- Bachelor's degree preferred and/or equivalent experience
Talents Needed for Success
- Minimum 5+ years of experience in Data Management, with deep expertise in analytical data warehousing and enterprise-scale data platforms, leading complex data initiatives end to end.
- Minimum 2+ years of hands-on experience with Snowflake Cloud Data Warehouse, including advanced features and performance optimization for large, concurrent analytics workloads.
- Strong expertise in AWS cloud architecture, with hands-on experience designing and supporting scalable, secure, and cost‑efficient data solutions using core AWS services.
- develop complex SQL and PL/SQL procedures to support robust, high‑performance data integration and transformation frameworks.
- Provide solutions using Snowflake services such as Snowpark, Streams, Tasks, and Snowpipe to build real‑time and batch data integration solutions in an AWS ecosystem.
- Drive data architecture decisions by applying strong knowledge of logical and physical data models, enabling analytics, reporting, and business intelligence at scale.
- Lead the development of dimensional models, including slowly changing dimensions (SCDs) and various fact table designs, aligned with analytics and reporting best practices.
- Support unit testing, system integration testing, and UAT, and ensuring production‑ready data solutions.
- Expertise in SQL performance tuning, proactive monitoring, root cause analysis, and resolution of complex data pipeline and platform issues.
- Act as a developer within Agile delivery teams, contributing to sprint planning, story design, estimation, and documentation using Jira.
- Demonstrate strong verbal and written communication skills, effectively collaborating with architects, product owners, business stakeholders, and cross‑functional technology teams.
With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem.
In 2024, DTCC’s subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC’s Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually. To learn more, please visit us at www.dtcc.com or connect with us on LinkedIn, X, YouTube, Facebook and Instagram.
DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.
Learn more about Clearance and Settlement by clicking here.