Business Intelligence Assistant

Keen to become part of a truly global, collaborative team of professionals? Your journey begins here.

Firm Description

Hogan Lovells is one of the leading global law firms, with 50 offices in Africa, Asia, Europe, Latin America, the Middle East, and the United States. With a presence in the world's major financial and commercial markets, we provide excellent business-oriented advice to our clients locally and internationally. Our distinctive market position is founded on our exceptional breadth of our practice, on deep industry knowledge, and on our 'one team' global approach.

Our people are the key to our success, which is why we seek to recruit and retain the most talented individuals in all regions of our global practice.

Purpose:
We need a capable and enthusiastic Business Intelligence Assistant to support the Business Intelligence team within the Marketing and Business Development Department.

The role will be closely involved in key aspects of the Business Intelligence team’s operations and central projects. It will involve reporting on various aspects of client financial and non-financial data as well as, external research and client profiles. Involvement in other central Business Development and Strategy Projects as required.

The role will report to the Business Intelligence Specialist (based in Louisville) and Senior Business Intelligence Adviser (based in London).

Key Responsibilities / Accountabilities:
Client Financial Reporting:

- A key aspect of the role will be to produce financial reports on a client, practice group, regional and sector level at regular intervals as well as on an ad-hoc basis. In support the firm's strategic planning process and internal reporting requirements.
- Production of individual client financial reports on an ad-hoc basis, upon request.
- Contribute to and support on a variety of complex business intelligence projects as needed, spanning an array of data sources and types.
- Contribute to the articulation and creation of standard reports for stakeholder groups in Excel and Power BI.

Client Profiles and Research:

- Conduct research relating to the firm's clients, competitors and the broader market utilizing desktop tools, e.g., the Internet, licensed research tools and databases and other intelligence sources.
- Assist with ad-hoc research related requests as needed.
- Prepare standard template research output, e.g., client dossiers and event briefings.
- Analyze client and market data to provide information that will help steer pitches, pursuits, and client targeting initiatives.
- Work closely with other teams within the firm and external suppliers to support the Business Intelligence team’s research profiles and projects.
- Prepare client
- and market-focused industry newsletters on a weekly basis for consumption by sector leadership and partners. This involves coordinating content with external research providers and internal sector teams, as well as utilizing internal publishing tools and CRM systems.

Client Relationship Partner Change (CRP) and Succession Planning Process:
Team Administration:
The role may need to support other Marketing and Business Development initiatives or tasks essential to the Business Development and Strategy team.

Role Requirements:
Education, Qualifications and Experience:

- Grade 12 or equivalent - NQF Level 4
- Finance or Information Management related tertiary qualification or BCom/BSc/BA degree (or level equivalent) in finance, business administration or informatics. A financial analysis and research analysis focus would be advantageous.
- Information administration and management related tasks - 1 - 2 years (required)
- Business research experience using a range of online databases - 1 - 2 years (required)
- Experience in Power BI and advanced Excel tools such as Power Query and Power Pivot - 1 - 2 years (Advantageous)
- Experience working in an international and global environment where team members are spread across geographies and time zones - 1 - 2 years (Advantageous)

System Skills
- Microsoft Office (Intermediate)

Behavioral Competencies:

- A self-starter who is resourceful, resilient, and analytical.
- Ability to work well both independently and in a team.
- Demonstrates an interest and understanding of the firm's business and the marketplace in which it operates.
- Someone who creates a positive impact with colleagues, managers and internal clients and delivers excellent service.
- Ability to handle queries efficiently with diplomacy and tact.
- Ability to follow instructions precisely.
- Adaptable and responsive to change.
- Strong work ethic with an inherent sense of urgency.
- Delivering results and meeting business expectations

Knowledge and Skills
- Highly proficient in the use of Microsoft office: Especially using Excel, including working with Pivot tables, and PowerPoint. (Power BI and VBA experience is not essential but would be an advantage).
- Skilled in maintaining quality and quantity of out