Data Analytics Specialist Job at Messina Talent Advisors in Chicago

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’ 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

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
• 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