FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Investments Specialist
Marsh McLennan. Support Mercer's Reference Data team as a Market Data Analyst on a contingent basis .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in reference data management and market data operations, with strong capabilities in data modeling, validation, and governance. Proficient in SQL, Excel, and MDM systems, with a focus on maintaining data quality and compliance within financial services.
Highest-signal resume keywords
Reference Data ManagementMarket Data OperationsSQL ProficiencyMaster Data Management (MDM)Data Governance
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingData ValidationData Lineage DocumentationInstrument Setup and MaintenanceCorporate Action ProcessingAdvanced Excel SkillsSQL for Data ExtractionPython ScriptingVBA AutomationETL Tools
Soft Skills
Analytical SkillsTroubleshooting SkillsVerbal CommunicationWritten CommunicationCollaboration
Tools & Technologies
BloombergRefinitiv/ReutersFactSetTableauPower BIOracleSQL ServerAWSAzureMDM Systems
Industry Keywords
Financial ServicesInvestment OperationsSecurities Master DataCorporate ActionsPrivate MarketsAlternative AssetsData Quality KPIsLicensing ComplianceVendor Data ModelsCross-Functional Teams
Tech Stack
Tools & technologiesAWSAzureETLOraclePythonSQLTableauVBA
About the role
Key responsibilities & impact- Support Mercer's Reference Data team as a Market Data Analyst on a contingent basis
- Create, validate, and maintain instrument records across equities, fixed income, ETFs, mutual funds, derivatives, indices, and private assets
- Assign and manage identifiers, symbology, exchange mappings, currencies, and instrument attributes
- Configure lifecycle states and maintain corporate actions, corporate hierarchies, and security relationships
- Onboard new issues, listings, and funds while coordinating with issuers, custodians, exchanges, and vendors
- Perform routine maintenance including corporate action updates, ticker mapping changes, corporate events, ticker splits, fund share class mapping, and reclassifications
- Implement master data management procedures and governance standards
- Perform data modeling, attribute mapping, metadata documentation, and data lineage documentation
- Participate in change control, configuration management, and deployment processes
- Manage permissions, entitlements, and data access configurations
- Design and perform validation, reconciliation, exception handling, and quality checks across internal and vendor systems
- Triage and remediate data issues; maintain reconciliation logs, dashboards, metrics, and SLA reporting
- Lead root-cause analysis and design remediation plans
- Support vendor interactions, metadata validation, field mapping, fixes, escalations, and licensing compliance
- Serve as a point of contact for data requests, instrument lookups, and incidents
- Translate business requirements into data models and delivery specifications with cross-functional teams
- Contribute to platform migrations, MDM implementations, data migrations, vendor integrations, UAT, cutover, and stabilization
- Produce documentation, runbooks, and training materials
- Automate data ingestion, validation, enrichment, and reconciliation using scripts, SQL, or workflow tools
- Maintain operational playbooks, SLAs, and data-quality KPIs
Requirements
What you’ll need- 5+ years of professional experience in reference data management, market data operations, securities master data, or investment operations within financial services
- Strong working knowledge of Bloomberg, Refinitiv/Reuters, FactSet, and common vendor data models
- Hands-on experience with instrument setup and maintenance across multiple asset classes
- Familiarity with ISIN, CUSIP, SEDOL, FIGI, and LEI identifiers and corporate action processing
- Practical experience with Master Data Management (MDM) systems and enterprise reference data stores
- Advanced Excel skills, including lookups, pivot tables, and data cleaning
- Proven experience with SQL for data extraction, reconciliation, and analysis
- Experience with Python, VBA, or similar scripting/automation tools and/or ETL tools
- Familiarity with data governance, metadata management, data lineage, and regulatory or licensing considerations for market data
- Strong analytical and troubleshooting skills
- Excellent verbal and written communication skills
- Ability to work independently and collaborate effectively with cross-functional teams
- Desirable: experience with private markets/alternative assets reference data
- Desirable: familiarity with Tableau or Power BI
- Desirable: prior experience in MDM implementation, data migration, or reference data modernization
- Desirable: knowledge of Oracle or SQL Server and exposure to AWS, Azure, or data engineering practices
- Must work in the local office or onsite with clients at least three days per week
Benefits
Comp & perks- Hybrid work with flexibility to work remotely
- Collaboration, connections, and professional development benefits from working together in the office
- Diverse, inclusive, and flexible work environment