Responsibilities
• Management and oversight of trading and lending data for Mortgages and Structured Products, including data pipelines and database management, validation, and quality control
• Process and workflow automation to eliminate redundancies, reduce manual interventions and improve efficiency for the firm’s trading and lending platforms
• Develop strategic reporting for trading desks and asset management across relevant products and asset classes
• Ensure end-to-end flow, accuracy, and completeness of data by partnering with Trading Desks, Asset Management, Engineering and Strats to understand business requirements and define strategic data models and systems
• Liaise with Controllers, Compliance, Risk and other divisions for regulatory and business important reporting through automated toolkits
• Translate business requirements into tangible solution specifications and high quality, on time deliverables
• Manage project timelines and completions for committed analytics, automation and reporting
• Reconcile data discrepancies and perform data reconciliations between external vendors and internal databases through analytics and research
Skills / Experience
• 1-3 years of experience in data analysis, data modeling, RDBMS databases and ETL
• Strong academic background – 4-year related engineering background with a minimum 3.0 GPA
equivalent.
• Experience with at least one programming language such as Java, Python etc. preferred.
• Proficient in SQL and / or interacting with structured data
• Understanding of in industry standard data transformation and reporting tools such as Tableau,
Qlikview, QlikSense, Alteryx, RapidMiner etc.
• Solid analytical/logical mindset and attention to detail
• Strong communication skills (clear, concise, and confident) with the ability to manage internal and
external relationships.
• Team-oriented with a strong sense of ownership and accountability
• Must know or be able to learn Excel to an advanced level
• Ability to prioritize workload, and work with Technology to help drive data smart solutions
Good to have
• Knowledge and/or experience with Machine Learning preferred
• Understanding of databases, data models, and Extraction Transformation Load (ETL) processes
preferred.
• Mortgage banking or other financial industry experience
• Understanding of structured finance, collateralized lending, fixed income, or related finance
modeling concepts