Primarily responsible for the data management of accounts that hold securities that have undergone corporate actions. Scans for, validates, and corrects transaction data where necessary to ensure correct performance reporting for such accounts/securities. Independently analyzes, reconciles, troubleshoots and reviews incoming and outgoing data/files/reports to ensure accurate performance/output generated by technology solutions and services. Serves as a mentor or project lead, allocating work to and reviewing the work quality of others. Interfaces with clients internally and externally to discuss project status, data issues and remediation recommendations. Analyzes and monitors files/data/reports to ensure quality of and accurate transfer, integration, translation, and reporting of data, reacting promptly to data quality metrics and client inquiries. Based on experiential analysis, execute complex data fixes, resulting in improved performance or accuracy. Contributes to the development of the standard operating procedures for the function. Interacts with data management and client support teams to identify trending issues and document root cause. Performs data mining and analysis to determine impact assessment. Employs a proven method for gathering data and model/articulate the proposed solution to complex business problems. Identifies, creates and proposes solutions for complex, large scale data issues which requires in-depth analysis and custom data manipulations to resolve. Interfaces with clients internally and externally to discuss project status, data issues and remediation recommendations. No direct reports; provide guidance to less experienced colleagues as needed. Often serves as project lead, allocating work to and monitoring the work quality of others. Contributes to the achievement of related teams' objectives.
Bachelor's degree in finance, economics, computer science or a related discipline, or equivalent work experience required. Typically requires 7-10 years of total work experience, preferably in securities or financial services. 'Uses SQL for data mining purposes to troubleshoot data conditions in relational databases. Develops complex script solutions for data conditions in relational databases. SQL Skills required (2-4 years anonymous block data analysis querying skills)'