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).

Client Financial Reporting

Key Responsibilities / Accountabilities:

• 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

• The role will be involved in the ongoing administration and management of CRP change requests in a timely manner, including the production of client financials, and the preparation of e-mail communications to clear and process the change requests.
• Assist in administration and management of CRP succession planning in a timely manner, including preparing e-mail communications to senior firm leadership on the roles that need transitioning and the preparation of all relevant financial and relationship information.

Team Administration

• The role will be involved in the ongoing administration and management of CRP change requests in a timely manner, including the production of client financials, and the preparation of e-mail communications to clear and process the change requests.

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

• Candidates must have good organisational skills, and be able to manage their work and tasks in a methodical manner.
• 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 output under pressure.
• Strong written and verbal communication skills with an excellent eye for detail.
• Ability to work appropriately with confidential and sensitive information.
• Can manage a number of tasks simultaneously and works well under pressure.
• Familiarity with internet based search and other business intelligence tools and databases
• Business writing.
• Well-developed interpersonal skills and able to deal with colleagues at all levels.
• Commercial awareness

Additional Considerations

• Applicants must be South African citizens or have a valid South African work permit
• Preference will be given to Employment Equity candidates
• Preference will be given to candidates who are living with a disability

Working Hours

• 9.00am to 17;30, or a shift pattern of 42.5 hours per week, as agreed on an individual basis, but falling between 07:00 and 23:00 SAST, Monday to Friday. It may be required to work overtime from time to time. This job description sets forth the authorities and responsibilities of this position and may be changed from time to time as shall be determined.

If you have not had any response from us within 21 days of the closing date, please consider your application unsuccessful.

Hogan Lovells Services (South Africa) Limited (Incorporated in England) is an equal opportunity employer. All positions are placed in accordance with the Company’s Employment Equity Plan.

“Your application and all personal information provided herein is protected under the Protection of Personal Information Act (4 of 2013), hereinafter referred to as the “Act”.

Hogan Lovells Services (South Africa) Limited (Incorporated in England), with its head offices at 140 West Street in Sandton, Johannesburg, is collecting this information to enable us to facilitate your application and /or assess your suitability for the advertised position. This information will be used for this purpose only and disposed of thereafter.

Where shortlisted, your information will be retained for a period of 12 months and disposed of immediately thereafter if you are unsuccessful in your application. Where employment is offered, it will be retained as part of your employee portfolio and secured accordingly. This information is given to us, by you, voluntarily and of your own free will. If you do not wish to provide us with this information, are unable to do so, or object to it being used, it will result in the disqualification of your application.

In the course of the recruitment process, and for matters related to your application only, we may share your information with selected third parties. You have the right to access this information while in our possession and make corrections if necessary.

You have the right to lodge a complaint via email with the office of the Information Regulator, at [email protected], if you are unhappy with the manner in which we deal with your information.

By submitting your application, you hereby declare your understanding of the aforementioned information and consent to the processing of your information in accordance with the Act, as well as the processing of any further personal information requested by us in the future including but not limited to, banking details, criminal history and credit reports /financial history information.”

All vacancies are open to direct applicants. Recruitment agencies; please be advised that we have a preferred supplier list in place for all roles.