Position: Data Modeler/Data Analyst (Capital Markets)
Location: Hybrid- Mississauga, ON
Job type: Full-Time/Permanent Hiring
Note- Karat Test is mandatory. After Karat Clearence there would be In-person interview for final discussion.
We are seeking a highly skilled Senior Data Modeler and Data Analyst to architect robust data environments and analyze complex transactional systems. The role most critically requires extensive, hands-on experience in data modeling (Star, Snowflake, and Hybrid schemas) alongside deep domain expertise in Capital Markets, including the complete trade life cycle, asset classes, and risk evaluation. The ideal candidate will leverage advanced SQL data profiling capabilities to lead data quality analysis and collaborate seamlessly across engineering and business stakeholder teams.
Key Responsibilities
- Architect and design robust data models utilizing Star, Snowflake, and Hybrid design patterns.
- Define and manage relational and dimensional structures, including complex dimension and fact tables.
- Profile and analyze complex financial data sets using advanced SQL queries and spreadsheet models.
- Evaluate and interpret Capital Markets domain entities, tracking asset classes (Equities, FX) and the end-to-end trade life cycle.
- Lead data quality analysis initiatives to identify anomalies, enforce validation rules, and optimize data integrity.
- Translate business requirements from market participants (brokers, custodians, investors) into clear technical specifications.
- Collaborate continuously with diverse stakeholders, bridging communication between business users, managers, and developers.
- Assess transactional risks and data patterns to ensure regulatory and reporting compliance frameworks are met.
Required Skills
- Primary: Data Modeling (Dimensional/Relational), SQL Data Profiling, Capital Markets Domain, Trade Life Cycle, Data Quality Analysis.
- Tools/Frameworks: Advanced SQL, Excel/Spreadsheet modeling, Data Profiling Tools (e.g., Informatica, Great Expectations).
- Database/Cloud: Snowflake Schema, Star Schema, Enterprise Data Warehouses (EDW), Modern Cloud Data Platforms.
- Nice-to-Have: Risk Analytics, Equities & FX Market experience, Data Governance Frameworks.