Search

Securities Reference Data Analyst

PublishedPublished: 6/14/2022
Technology
|

Job Description

Security Master Data Analyst (Long-Term Consulting) · New York, NY · $75–$85/hour · Hybrid

\n


\n

Our client, an alternative investment manager, is hiring a Security Master Data Analyst on a long-term consulting basis to drive the data analysis and testing behind a security master implementation.

\n


\n

Responsibilities

\n

    \n
  • Dig into securities reference data with SQL and Excel, profiling and reconciling it across source systems and validating it in the new security master.
  • \n

  • Help define golden-source rules for identifiers, terms and conditions, classifications and corporate actions, and document the mapping specs, data flows and business rules behind security setup, enrichment and exceptions.
  • \n

  • Collect functional and business requirements from operations, technology and data stakeholders, and help resolve conflicts between them.
  • \n

  • Write and run test plans, cases and validation scripts through unit, integration and UAT phases to prove the data is accurate, complete and sound.
  • \n

  • Track down data quality issues, find root causes, and work with technology on fixes.
  • \n

  • Support migration and cutover, reconciling legacy systems against the new platform and working through breaks.
  • \n

  • Partner with outside data vendors and internal engineers to clear mapping and integration problems.
  • \n

  • Keep stakeholders and senior management informed with clear documentation and status updates, and help set quality and governance standards for reference data going forward.
  • \n

\n


\n

Requirements

\n

    \n
  • 5+ years as a data or business analyst (or similar) at a financial services firm; an investment bank, hedge fund, private equity or asset management background is preferred.
  • \n

  • Hands-on security master experience covering classification, pricing, corporate actions, reference data and security setup.
  • \n

  • The ability to walk through how you’ve set golden-source rules from multiple feeds, using reconciliation reports, breaks and public data sources.
  • \n

  • Strong, hands-on SQL: you’ll query, reconcile and profile large datasets.
  • \n

  • Advanced Excel, including pivots, lookups and large-scale data comparison.
  • \n

  • Experience testing and validating data during a data migration or new system rollout.
  • \n

  • Clear written and verbal communication that translates technical data issues into business terms and back.
  • \n

  • A bachelor’s in information systems, business, finance or similar.
  • \n

  • Pluses: security master or EDM platforms (Markit EDM, GoldenSource, SimCorp, Eagle, Charles River, Bloomberg Data License or similar); knowledge of equities, fixed income, derivatives and private assets; data governance, lineage or cataloging tools; Agile delivery in JIRA/Confluence; a reference data implementation from requirements through go-live.
  • \n

\n


Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...