Careers

Automation Specialist

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 & GOCS

 

 

 

The Global Operations, Client Services & Administration group delivers world-class safety and soundness for the global financial services industry. The team provides DTCC’s 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, DTCC’s 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. DTCC’s 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 www.dtcc.com or connect with us on LinkedIn, Twitter, YouTube and Facebook.


Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

Tampa

📁 Global Operations, Client Services & Administration

Requisition #: 192015

Tampa

📁 Global Operations, Client Services & Administration

Requisition #: 191971

Tampa

📁 Global Operations, Client Services & Administration

Requisition #: 192006