Data Analyst/Data Modeler
Role summary
This role is for a Data Analyst/Data Modeler with experience in Trading and Securities Finance. The primary responsibilities include collaborating with business stakeholders to define data requirements, designing and maintaining canonical data models (positions, trades, collateral, market data), and ensuring data quality. The analyst will perform data analysis using SQL and Excel, create reports and dashboards, and document data definitions and lineage. A Bachelor's degree in a relevant field and at least 3 years of experience in financial services data analysis are required, along with strong SQL, advanced Excel, and data modeling skills.
Role: Data Analyst/Data Modeler
Location: Jersey City, NJ (3 Days onsite/ week)
**Type:
Full time**
Job Description:
Need profiles with Trading and Security experience.
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.
