Company Name


2 - 6 years

Key Skills
Data Analytics Associate


Software Engineer/ Programmer

Banking/ Financial Services

Posted On
2nd Jan 2019

Job Ref code
About DTCC

Through multiple operating facilities and data centers around the world, DTCC and its subsidiary companies automate, centralize, and standardize the processing of financial transactions for thousands of institutions worldwide. With 40 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry, simplifying the complexities of clearance, settlement, asset servicing, global data management and information services for equities, corporate and municipal bonds, government and mortgage-backed securities, derivatives, money market instruments, syndicated loans, mutual funds, alternative investment products, and insurance transactions. In 2011, DTCC’s subsidiaries processed securities transactions valued at approximately US$1.7 quadrillion. Its depository provides custody and asset servicing for securities issues from 122 countries and territories valued at US$39.5 trillion. DTCC’s global OTC derivatives trade repositories record more than US$500 trillion in gross notional value of transactions made worldwide across multiple asset classes.

For more information, visit, and follow us on Twitter: @The_DTCC

Job Title

Data Analytics Associate 

Business Unit: Financial Risk Management
Department: Group Chief Risk Office  
Job Family: Risk Management
Job Title: Data Analytics Associate
Corporate Title: Associate
FLSA Code (US Only): Exempt

Business Unit Description:

Our Risk Management teams work to protect the safety and soundness of our systems and are responsible for identifying, managing, measuring and mitigating a spectrum of key risk types including credit, market, liquidity, systemic, operational and technology in all existing and new products, activities, processes and systems.

Position Summary:

The Data Analytics team is responsible for the advancement and integration of the Data Warehouse into all aspects of risk management, DTCC, and external clients. The successful candidate will have proven experience in managing data, including data warehousing, data analysis, and problem solving. They will have a structured approach to business analysis and a proven track record of implementing solutions. Be a point of contact for risk data warehouse activities, including business requirements gathering, data modeling, data documentation, user acceptance testing, and ad-hoc data queries.

Specific Responsibilities:

  • Communicate with internal stakeholders to understand data requirements.
  • Write data business requirements and user stories related to new software development projects.
  • Provide data analytics support to Business Analysts and Product Owners.
  • Follow the Agile SCRUM practices for data-intensive projects covering software development, data warehousing, customer reporting, and data analytics.
  • Participate in pre and post-release testing to validate requirements have been met.
  • Profile data to thoroughly understand the quality, anomalies and patterns.
  • Identify, plan and oversee consolidation of redundant data sources to establish centralized golden copy source data.
  • Establish data quality processes for the data warehouse and analyze data quality reports to identify potential anomalies across multiple data sources.
  • Research and propose solutions for data anomalies; Escalate data issues to appropriate stakeholders in a timely manner.
  • Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately

Leadership Competencies for this level include:
  • Accountability: Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
  • Global Collaboration: Applies global perspective when working within a team by being aware of own style and ensuring all relevant parties are involved in key team tasks and decisions.
  • Communication: Articulates information clearly and presents information effectively and confidently when working with others.
  • Influencing: Convinces others by making a strong case, bringing others along to their viewpoint; maintains strong, trusting relationships while at the same time is comfortable challenging ideas.
  • Innovation and Creativity: Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.

  • Minimum of 3-5 years of related experience
  • Bachelor's degree preferred with Masters or equivalent experience
  • Hands-on experience writing and executing complex SQL queries
  • Experience with various business intelligence tools is a plus
  • Experience with Python, R, or other programming languages is a plus
  • Experience with Amazon Web Services is a plus

About DTCC:

With over 40 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From operating facilities and data centers around the world, DTCC automates, centralizes, and standardizes the processing of financial transactions across the trade lifecycle and mitigates risk for thousands of institutions worldwide.

At DTCC we value on our clients' interests and partner to deliver superior results with excellence and innovation and lead with integrity. We proactively develop your potential and invest in your career.  


Apply Now

Powered by Monster