The Data Analyst in the Enterprise Data Client Data Team will be responsible for providing data across both Public and PI asset classes and analytical insight based on inquiries from members of the Enterprise Data team as well as outside stakeholders. The individual will utilize data analysis and visualization tools such as Excel, SQL, and Power BI to collate data from various sources, analyze the information and provide insights and analysis to the requesting teams and leadership.
RESPONSIBILITIES
- Partner with members of Enterprise Data and IT teams to understand data needs with the ability to translate these needs into a comprehensive data solution
- Ability to collate, interpret and analyze data to provide insights & drive business decisions
- Use statistical models and industry recognized investment data calculation methodologies to perform various data analytics in SQL and MS Excel
- Leverage quantitative methods to identify data patterns and perform quantitative analysis on investment performance and assets under management data
- Establish and follow data management principles to improve data quality, lineage and governance
- Partner with IT to build, test and validate calculations to provide easy and consistent access to data both for applications as well as end users
- Exercise relational database knowledge to construct and execute SQL queries to be used in data analysis activities
- Build and maintain strong relationships across the firm to understand business goals and prepare for the organization’s evolving data needs
- Contribute to additional projects where relevant domain or data analysis expertise is needed
QUALIFICATIONS
- Bachelor’s Degree, with preference to Data Analytics, Information Systems, or Mathematics
- 3-5+ years of industry experience with 1-2 years of that in data analysis
- Demonstrated skill in SQL usage as part of data analysis and Power BI for data visualization
- Working knowledge of relational database design concepts
- Ability to work autonomously in a highly productive environment and executing across multiple competing deadlines with fast-paced delivery targets
- Excellent organizational, written, and verbal communication skills
- Willingness to learn and build expertise and data depth across the entire Enterprise Data Client Data Team product suite
- Direct experience integrating data from multiple sources such as client, fund, and market data domains strongly preferred