SQL Analyst
Core
Develop, maintain, and supervise derived fundamental data (e.g., Price earnings ratio) and create high-quality data content for index builds and products.
Role type
Senior Associate Factor Analyst (Data Analytics)
Builds
Derived fundamental data content and standardized data models for index builds and analytics products
Domain
Financial data, Equities, Index Management
Required skills
Accounting principles, Fundamental and valuation analysis, Market data handling, Data management, SQL, Database querying, Data standardization, Quality control, Client communication
Preferred skills
Corporate action treatments, Currency changes, Common market identifiers, MS Office suite, New tool adoption
Technologies
SQL, MS Office suite
Responsibilities
Create and document methodologies behind analytics, Specify requirements and collaborate with Technology on implementation, Test output of data derivations for accuracy, Wrangle data from internal and external sources into standardized models, Create and supervise quality control checks on raw and derived data, Respond to client questions with root cause and action plans, Produce data visualizations and quality reports
Seniority
Senior Associate, hands-on IC