Associate, Business Advisory Services (Data)

Job Description

The Associate will be primarily responsible for the following tasks:

• Provide ongoing support to Capital Solutions team for bank scorecards and capital commitment data mart to drive decision making using Ares wallet.
• Collaborate with multiple fund accounting and deal teams to collect lender fee data and capital commitments across the Ares platform using Excel templates.
• Transform and format data in Excel to conform with BRM SharePoint database.
• Upload fee and commitment data into BRM SharePoint database. Maintain and update database for new relationships and new funds.
• Prepare and enhance Excel and PowerPoint reporting from BRM SharePoint database.
• Develop PowerBi reporting from BRM SharePoint database to automate bank scorecards and capital commitment reports.
• Data extraction and analysis
• Ability to re-engineer and automate reports to create value.

Education:

• Finance Graduate/ MBA

Experience Required:  

• Proficiency in Excel, Word and Outlook
• Experience with Power BI or other business intelligence tools a plus
• Good communication skills
• Able to coordinate and gather data/information from various teams- assertiveness required
• Ability to build relationship and trust

General Requirements:

• Dependable, great attitude, highly motivated and a team player
• Ability and desire to work in a fast pace and dynamic environment often requiring fast solutions to complex problems
• A self-directed individual with a can-do attitude, willing to work in an energetic, collaborative, and fast-paced environment, proactive in nature, and a proven ability to learn quickly, display flexibility and adaptability while resolving issues with minimal supervision
• Flexibility regarding role profile and willingness to take on new projects and learn new skills
• Outstanding communication (written and verbal), presentation, documentation, and interpersonal skills; strong customer focus
• Ability to successfully manage multiple priorities and competing demands, strong time management and prioritization skills
• High accuracy and detail orientation; confident decision-making skills
• Ability to extract meaningful information from extensive research and analysis to effectively present facts and findings in a digestible format, a keen eye for attention to detail
• Good judgment in terms of escalating issues vs. solving problems independently
• An analytical mind and a passion/interest in bringing new ideas to increase efficiency of existing processes
• Comfort in dealing with ambiguity and uncertainty in a dynamic and fast-paced environment
• Ability to be flexible in terms of hours in order to coordinate with team members across various time zones
• Willingness to take on new projects and learn new skills

Reporting Relationships

There is no set deadline to apply for this job opportunity. Applications will be accepted on an ongoing basis until the search is no longer active.