Erwin Data Modeler

About

Requirements

Candidate with Trading and Security or Banking experience.

Responsibilities

• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications for canonical data models.
• Analyze existing data sources to identify data elements, relationships, and inconsistencies.
• Design, develop, and maintain canonical data models and schemas, including positions, trades, collateral, and market data.
• Ensure data quality, accuracy, and integrity within the data models, implementing data validation rules and monitoring data flows.
• Work closely with data architects, developers, and other analysts to implement data models in various technology platforms.
• Document data definitions, data lineage, business rules, and technical specifications for the canonical data models.
• Perform data analysis and extract insights from large datasets using tools like SQL, Excel, and potentially Python or R.
• Create reports, dashboards, and visualizations to support data governance, data quality, and business understanding of securities finance data.
• Participate in testing and validation of data models and data transformations.

Qualifications Required

• A Bachelor's degree in a relevant field such as Finance, Economics, Computer Science, or Information Systems is required.
• Candidates should have at least 3 years of experience in data or financial analysis, preferably within financial services.
• A strong understanding of securities finance, including lending, borrowing, and collateral management, is essential.
• Required technical skills include proficiency in SQL and advanced Excel for data analysis and modeling.
• Experience with data modeling tools and methodologies, as well as familiarity with database concepts, is also necessary.
• Essential soft skills include strong analytical and problem-solving abilities with attention to detail.
• Excellent communication skills for explaining complex data, and the ability to collaborate effectively in a team environment.
• A proactive and continuous learning mindset is also value.