Senior Quantitative Data Associate
Boston, Ma
• Held multiple roles in a startup-like project, including Junior Developer, Business Analyst, Data Quality Operations, Vendor Management, Project Manager, Team Engagement Chairperson, Trainer for new hires, and Production Support• Developed and implemented automated QA/DQ processes, reducing manual work from 2-3 weeks to 1 day by running a suite of tools• Created a regression testing process in Python using Pandas and other Python libraries to ensure 100% accuracy and consistency across all database environments including DEV, QA, UAT and PROD• Automated testing for over 6 million calculations, achieving accuracy above 96% for the system's logic. Consolidated over 20 Stored Procedures and performed the calculations in one SQL Script• Implemented an automated test to monitor the system's DQ exception logic, resulting in an increase in the calculation accuracy up to 98%• Acquired and integrated data from 10+ sources, including Bloomberg Terminal and Automated FTP feeds, to develop new processes and reporting capabilities. Collaborated with Business and Development teams to bring new datasets into the Quantitative Risk dataset• Partnered with both 3rd Party and Internal Data providers to improve data sets, working with 3rd party vendors to clean over 100,000 records and helped HarbourVest's internal data providers clean up several production data extracts that were being sent to the client• Worked in a scrum team with frequent scrum calls and biweekly sprints, planning strategic and tactical goals using Azure DevOps (ADO)• Completed data analysis, process design, and user acceptance testing across projects that required new research content• Conducted interviews for new hires and participated in Sprint Planning meetings as part of the team's leadership committee• Trained and mentored new hires in Quality Assurance (QA), Data Quality (DQ), and Business Analyst (BA) work