What are the responsibilities and job description for the Erwin Data Modeler position at Programmers.io?
Job Description:
Position: Erwin Data Modeler
Location: Jersey City, NJ (3 Days onsite/ week)
Hire Type: Full Time
Requirement:
Candidate with Trading and Security or Banking 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.