5-10 years of hands-on experience in Data Modelling techniques and schemas including snowflake, star, and hybrid models.
Strong knowledge of capital markets transaction processes and participants, including brokers and custodians.
Familiarity with various asset classes and related risks such as market, credit, operational, and liquidity risks.
Expertise in reference data management including accounts, parties, and securities.
Advanced proficiency in SQL for data profiling and quality analysis.
Responsibilities
Analyze and model data to meet urgent business demands.
Conduct data quality analysis to ensure integrity and accuracy.
Collaborate with diverse teams including stakeholders, change managers, and developers to align business needs with data requirements.
Translate complex business requirements into functional specifications and data mappings.
Maintain effective communication throughout project lifecycles to support stakeholders.
Benefits
Positive team environment fostering collaboration.
Opportunities for professional development in data analytics and modelling.
Exposure to capital markets and advanced asset management practices.
Full Job Description
Role description
Job Title: Data modelling
Work Location : Tampa, florida
Job Summary
Positive attitude and a good team player
Good verbal and written communication
6 to 10 years of hands on Data Modelling experience with knowledge of different data modelling schemas snowflake star hybrid and different types of tables fact dimension etc
Sound understanding of capital markets business transactions trade life cycle participants broker custodian investor CCP etc different asset classes products equities fixed income futures options FX commodities etc and associated risks market risk credit risk op risk liquidity risk etc
Understanding of reference data accounts parties securities etc
Highly skilled Data Analyst who can profile data using SQL andor spreadsheet
Support data quality analysis and to serve urgent business delivery needs
Strong in SQL
Work closely with varied stakeholders users change managers project manager architect and developers to translate the business requirements into functional requirements data mapping
