Automation Specialist Automation Specialist …

Depository Trust Clearing Corporation
in Mango, FL, United States
Permanent, Full time
Be the first to apply
Depository Trust Clearing Corporation
in Mango, FL, United States
Permanent, Full time
Be the first to apply
Automation Specialist
Careers ☰ Automation Specialist New 192013 Requisition # About this Opportunity

 The Business Automation & Reporting group creates Desktop/Server based system solutions that support Global Operations and Client Services. This includes creation and maintenance of databases and utilization and customization of software for ongoing mainframe-to-desktop downloading. The unit is responsible to improve operational efficiency through technological solutions and quality reporting. This unit designs, develops, implements and manages technology solutions to enhance internal and external customer service. The unit also assists with the testing of new corporate-level technologies. Additionally, this unit provides decision support to business leaders through data design and statistical analysis to identify root causes of product and performance issues. These responsibilities position the transformation of statistics into business intelligence.

Business Unit: Clearing Agency Services & GOCSThe Global Operations, Client Services & Administration group delivers world-class safety and soundness for the global financial services industry. The team provides DTCCs portfolio of core securities and superior transaction processing and client services support in an environment that minimizes risk and cost while maximizing efficiency.

 What You'll Do

Business Systems Analysis

  • Reviews business requirements from automation request system to understand requirements, identify components that may be missing or ambiguous and recommend ways to complete or strengthen the material
  • Works with customers to define user needs
  • Prepares detailed business requirements and process maps.

Solution Development

  • Build SQL Server schemas, tables, views and functions
  • Build, troubleshoot and maintain MS Access front-end databases
  • Use ODBC and Windows Authentication to connect the Access databases to SQL Server
  • Use Visual Basic for Applications (VBA) to code the Access databases and to create scripts
  •  Develop PERL, PYTHON AND DOS batch scripts to automate data extraction and parsing
  • Participates in functional analysis and design, technical analysis and design, test planning, and user documentation activities
  • Present solutions to senior management

Maintenance and Support

  • Troubleshoot and maintain solutions
  • Create database user guides
  • Train database users and other Business Automation team members
  • Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately

Sound Like You?

  • Minimum of 4 years of related experience
  • Bachelor's degree preferred with Masters or equivalent experience

Additional Qualifications

  • SQL Server database development, maintenance, and reporting (SSRS)
  • Understanding of data models, structures, theories, principles, and practices
  • MS Access end-user database development, including business system analysis, and hands-on technical development using Visual Basic for Applications (VBA)
  • Knowledge of RPA tools (Blue Prism) and Process Modeling (BPM)
  • Knowledge of PYTHON, PERL, and DOS batch scripting
  • SharePoint development administration

Who We Are

With over 45 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From operating facilities, data centers and offices in 16 countries, DTCC, through its subsidiaries, automates, centralizes and standardizes the processing of financial transactions, mitigating risk, increasing transparency and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm simplifies the complexities of clearing, settlement, asset servicing, data management, data reporting and information services across asset classes, bringing increased security and soundness to financial markets. In 2018, DTCCs subsidiaries processed securities transactions valued at more than U.S. $1.85 quadrillion. Its depository provides custody and asset servicing for securities issues from 170 countries and territories valued at U.S. $52.2 trillion. DTCCs Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes over 14 billion messages annually. To learn more, please visit us at or connect with us on , , and

Previous Job Searches My Profile

Create and manage profiles for future opportunities.

My Submissions

Track your opportunities.

Similar Listings


Global Operations, Client Services & Administration

Requisition #: 192015


Global Operations, Client Services & Administration

Requisition #: 191971


Global Operations, Client Services & Administration

Requisition #: 192006

© DTCC. All rights reserved. 0 0