Analyst, Data Operations at Cambridge Associates in Arlington

Summary: Cambridge Associates is a leading global investment firm that helps clients manage custom investment portfolios. The Analyst in Data Operations will ensure the accuracy and integrity of investment data, manage relationships with external investment managers, and drive process improvements within the firm. Responsibilities: - Represent the firm by establishing and cultivating professional relationships with external investment managers - Collaborate with external investment managers to incorporate new investment ideas into internal databases - Utilize expertise in investment data calculation methodologies such as TWR, IRR, and Modified Dietz for accurate data entry and comprehensive analysis - Utilize expertise in reviewing financial/legal documents such as balance sheets, statement of cashflows, factsheets, attribution exports, offering memorandums, limited partnership agreements, etc. to perform comprehensive analysis - Manage and update assigned portfolios of investment firms using internal databases and tools - Coordinate with investment operations staff, client teams, and research departments to address and fulfill various requests - Independently investigate and resolve issues and exceptions by engaging with both internal and external stakeholders - Provide guidance, leadership, and oversight for outsourced data entry functions to ensure quality and accuracy - Leverage institutional knowledge to develop and deliver high-quality training and documentation - Proactively identify opportunities for process improvements, propose actionable solutions, and implement changes to minimize risks and errors while enhancing efficiency - Utilize Excel to analyze data, generate insights, and support decision-making processes - Partner with IT staff to research and resolve technical issues, ensuring seamless operations and data integrity - Work collaboratively with colleagues to deliver exceptional results and service on small projects and cross-functional teams Required Qualifications: - Bachelor's degree (BA/BS) with 1-2 years of professional experience - Relevant professional experience in finance, operations, data management, data analysis, and/or process improvement - Exceptional verbal and written communication skills with the ability to communicate effectively at all levels - Excellent customer service orientation, with the ability to understand and meet the needs of clients and stakeholders, providing high-quality support and solutions - Proven ability to efficiently organize and prioritize tasks to meet deadlines and achieve goals - Strong sense of responsibility, accountability, attention to detail, and intellectual curiosity - Solid analytical and problem-solving skills - Intermediate to advanced Excel skills, including proficiency with formulas and functions (e.g., IF, AND, OR, NOT, VLOOKUP, HLOOKUP, INDEX-MATCH, AVERAGE, MEDIAN, MODE, STDEV, VAR), Conditional Formatting, Data Validation, Charts, and Pivot Tables - Eligible to work in the U.S. without restriction or sponsorship now and in the future Preferred Qualifications: - Experience with Box, Asana, and Confluence is a plus Required Skills: Data analysis, Excel proficiency Important Skills: Investment data methodologies, Financial document review Nice-to-Have Skills: Customer service orientation, Process improvement, Box, Asana, Confluence Benefits: Eligible for an annual performance-based bonus, Comprehensive, competitive benefits package