Data & Analytics Specialist
Data & Analytics Specialist
Data & Analytics Specialist, Chicago, Illinois, United States, 60290
Our client is searching for a Data & Analytics specialist in Chicago, Illinois.
The Data & Analytics Specialist position provides an excellent opportunity to work in a demanding, yet supportive, team-oriented environment. The Data & Analytics Specialist should have relevant professional experience, be entrepreneurial, poised, and able to deal with many different people both inside as well as outside the firm. Strong communication skills are critical to success in this role. Our client fosters a cohesive and supportive work environment and encourages teamwork.
Based in Chicago, Illinois, the Data & Analytics Specialist will serve as a key member of our client’s Business Enablement team, with the primary role of supporting initiatives related to our client’s proprietary Private Market Database. The Data & Analytics Specialist will gain a general understanding of our client’s Valuations and Opinions business and their client base, and a deep understanding of private equity and private credit markets.
Regular working hours are 8:30 am to 5:00 pm with a 30-minute lunch break. Willingness and ability to work overtime is necessary.
The primary duties are to:
Develop and validate internal reporting and data & analytics tools using Power BI and SQL.
Develop and validate client-facing reporting tools using Power BI and SQL.
Enhance and update existing reporting and data & analytics tools.
Provide user support for Power BI reporting tools.
Work directly with bankers and clients to understand context and gather requirements.
Participate in data validation and quality assurance testing as well as data health analysis.
Participate in database enhancement and data cleaning initiatives.
Participate in the development of quarterly perspectives about the private credit and equity markets based on analysis of this data.
Work cross-functionally with other teams to perform business analysis and develop data strategy.
Assist in execution of strategic technology implementations.
Position Qualifications: Interested candidates should meet the following requirements:
Professional and Cultural Characteristics:
Authentic individual with high integrity, whose personal and professional values are consistent with our client’s Culture Statement (Excellence, Entrepreneurship, Integration, Collaboration, Integrity).
Assertive, articulate, and self-motivated, can manage multiple tasks and deadlines in a fast-paced environment.
Strong collaborator who enjoys working in an entrepreneurial environment.
Driven and ambitious professional who gains satisfaction from achieving personal and team goals.
Willingness to learn new concepts and technology to enhance and collaborate with teams.
Ability to interface effectively with all levels of management and banking staff as it relates to reporting and analytics.
Other Qualifications:
Bachelor’s degree in Management Information Systems, Business Analytics, Finance, Accounting, Computer Science, or related field.
1 – 2 years of professional experience in a comparable, finance-focused analytical role.
1 – 2 years’ experience developing reports in Power BI with large, complex, and/or fragmented datasets.
Proficiency with SQL.
Advanced Microsoft Excel capabilities performing data cleansing, manipulation, and analysis.
Understanding of financial concepts and terminology.
Excellent written and verbal communication skills.
Client/Customer facing experience a plus.
Experience architecting/developing relational databases a plus.
Other Details:
Schedule: 9-5
Location: Chicago, IL
Duration: Permanent
Position Benefits: Our client supports its employees with highly competitive benefits, including health insurance, dental insurance, flexible-spending accounts, and a deferred compensation program through its 401(k) and profit-sharing plans.
#J-18808-Ljbffr
The Data & Analytics Specialist position provides an excellent opportunity to work in a demanding, yet supportive, team-oriented environment. The Data & Analytics Specialist should have relevant professional experience, be entrepreneurial, poised, and able to deal with many different people both inside as well as outside the firm. Strong communication skills are critical to success in this role. Our client fosters a cohesive and supportive work environment and encourages teamwork.
Based in Chicago, Illinois, the Data & Analytics Specialist will serve as a key member of our client’s Business Enablement team, with the primary role of supporting initiatives related to our client’s proprietary Private Market Database. The Data & Analytics Specialist will gain a general understanding of our client’s Valuations and Opinions business and their client base, and a deep understanding of private equity and private credit markets.
Regular working hours are 8:30 am to 5:00 pm with a 30-minute lunch break. Willingness and ability to work overtime is necessary.
The primary duties are to:
Develop and validate internal reporting and data & analytics tools using Power BI and SQL.
Develop and validate client-facing reporting tools using Power BI and SQL.
Enhance and update existing reporting and data & analytics tools.
Provide user support for Power BI reporting tools.
Work directly with bankers and clients to understand context and gather requirements.
Participate in data validation and quality assurance testing as well as data health analysis.
Participate in database enhancement and data cleaning initiatives.
Participate in the development of quarterly perspectives about the private credit and equity markets based on analysis of this data.
Work cross-functionally with other teams to perform business analysis and develop data strategy.
Assist in execution of strategic technology implementations.
Position Qualifications: Interested candidates should meet the following requirements:
Professional and Cultural Characteristics:
Authentic individual with high integrity, whose personal and professional values are consistent with our client’s Culture Statement (Excellence, Entrepreneurship, Integration, Collaboration, Integrity).
Assertive, articulate, and self-motivated, can manage multiple tasks and deadlines in a fast-paced environment.
Strong collaborator who enjoys working in an entrepreneurial environment.
Driven and ambitious professional who gains satisfaction from achieving personal and team goals.
Willingness to learn new concepts and technology to enhance and collaborate with teams.
Ability to interface effectively with all levels of management and banking staff as it relates to reporting and analytics.
Other Qualifications:
Bachelor’s degree in Management Information Systems, Business Analytics, Finance, Accounting, Computer Science, or related field.
1 – 2 years of professional experience in a comparable, finance-focused analytical role.
1 – 2 years’ experience developing reports in Power BI with large, complex, and/or fragmented datasets.
Proficiency with SQL.
Advanced Microsoft Excel capabilities performing data cleansing, manipulation, and analysis.
Understanding of financial concepts and terminology.
Excellent written and verbal communication skills.
Client/Customer facing experience a plus.
Experience architecting/developing relational databases a plus.
Other Details:
Schedule: 9-5
Location: Chicago, IL
Duration: Permanent
Position Benefits: Our client supports its employees with highly competitive benefits, including health insurance, dental insurance, flexible-spending accounts, and a deferred compensation program through its 401(k) and profit-sharing plans.
#J-18808-Ljbffr