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.
- 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.
- Collect functional and business requirements from operations, technology and data stakeholders, and help resolve conflicts between them.
- Write and run test plans, cases and validation scripts through unit, integration and UAT phases to prove the data is accurate, complete and sound.
- Track down data quality issues, find root causes, and work with technology on fixes.
- Support migration and cutover, reconciling legacy systems against the new platform and working through breaks.
- Partner with outside data vendors and internal engineers to clear mapping and integration problems.
- 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
\n
\n
\n
\n
\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.
- Hands-on security master experience covering classification, pricing, corporate actions, reference data and security setup.
- The ability to walk through how you’ve set golden-source rules from multiple feeds, using reconciliation reports, breaks and public data sources.
- Strong, hands-on SQL: you’ll query, reconcile and profile large datasets.
- Advanced Excel, including pivots, lookups and large-scale data comparison.
- Experience testing and validating data during a data migration or new system rollout.
- Clear written and verbal communication that translates technical data issues into business terms and back.
- A bachelor’s in information systems, business, finance or similar.
- 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
\n
\n
\n
\n
\n
\n
\n
\n
