Job
Description
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
