Key Responsibilities
- Execute the daily collection, cleansing, and validation processes of ETF (Exchange-Traded Fund) data such as NAV, Price, and Shares Outstanding to ensure high accuracy and reliability.
- Perform region-specific data completeness checks, including Canada and Asia-Pacific datasets (NAVs and Prices), ensuring all required data points are available within deadline timeliness.
- Monitor and perform quality assurance on data ingested via automated processes.
- Identify, investigate, and resolve data discrepancies such as missing NAVs, incorrect pricing, duplicate records, or inconsistencies across ETF datasets.
- Collaborate with cross-functional teams (Scrums and Stakeholders) to resolve data issues and improve ETF data processing efficiency.
- Monitor automated workflows (e.g., DAGs) for failures in ETF data processing, troubleshoot issues, and ensure timely resolutions to avoid downstream impact.
- Assist Assistant Manager/Manager in preparing comprehensive reports on incident reporting, Root Cause Analysis (RCA), fixes, and work in progress on key metrics and insights.
- Respond to data-related inquiries from Senior Analyst and your inline Manager.
- Maintain documentation of data sources, processes, and methodologies.
- Support ad-hoc data requests, including historical corrections, client issue resolutions, and dataset enhancements.
Candidates must be fully available for this shift.
Skills, Knowledge and Expertise
- Bachelor’s or master’s in science, Technology, Engineering, Mathematics, Finance or Accounting
- 2-4+ years' experience in funds/indexing industry within data, analytics or finance-related role
- Familiarity with ETFs, Mutual Funds and/or other financial instruments
- Detail-oriented, analytical nature
Skills
- Hands-on experience working with development teams on ETL operations.
- Knowledge of SQL.
- Experience in managing large datasets.
- Excellent communication and interpersonal skills.
- Problem-solving and decision-making capabilities.
- Ability to work independently, think out of the box and constantly chase quality.
Benefits
- 21 days of Annual Vacation
- 8 sick days
- 6 casual days
- 1 paid Volunteer Day
- Medical, Accidental & Term Life Insurance
- Telehealth, OPD
- Competitive pay
- Annual Performance Bonus
