Consultant Junior Advanced Excel / VBA / Power BI

Project overview

Context

A large banking institution is looking for a Junior Consultant specialized in advanced Excel, VBA, and Power BI, to work in the field of IT operational risk management.

The consultant will join a team of four Risk Managers.

The mission is primarily focused on:

The need is more oriented towards advanced Excel, operational Power BI, and functional administration of a business tool than Data Analysis.

Mission Objectives

The consultant's objective will be to ensure the smooth running of monthly level 1 internal control campaigns.

Specifically, they will need to:

Missions and Responsibilities

AGIR is a tool published by Nabla.

The consultant will not be responsible for developing the application but must quickly understand its operation to become autonomous in its functional administration.

Expected Technical Skills

Expected Functional Skills

Technical and Functional Environment

Domain

Tools / Skills

Advanced Office Suite

Microsoft Excel

Office Automation

VBA – Existing Macros

Reporting

Power BI

Business Tool

AGIR, published by Nabla

Functional Administration

Repositories, imports, users, entities, campaigns

Data Quality

Cleaning, control, anomaly correction

Risk Management

Level 1 Controls

Operational Steering

Monthly campaigns and deadline monitoring

Organizational and Operational Calendar

The consultant will work within a team of four Risk Managers.

Their activity will be structured around a recurring monthly cycle.

Between the 20th and the end of the month:

Before the 7th of the following month:

Working Conditions

• Operational steering of monthly level 1 control campaigns.
• Management and updating of Excel repositories.
• Functional administration of the AGIR business tool.
• Data processing, control, and validation.
• Populating and monitoring Power BI dashboards.
• User support.
• Ensure the preparation and launch of campaigns.
• Ensure the quality and reliability of repositories.
• Monitor user responses.
• Identify delays and anomalies.
• Control campaign results.
• Populate Power BI reports.
• Meet monthly delivery deadlines.
• Provide first-level functional support.
• Management and validation of Excel repositories
• Update Excel repositories.
• Handle large files.
• Control data consistency and quality.
• Perform data cleaning operations.
• Identify and correct anomalies.
• Ensure the reliability of information used for control campaigns.
• Functional administration of the AGIR tool
• Ensure the functional administration of the AGIR tool, including:
• Perform data imports.
• Manage users.
• Administer entities.
• Prepare and manage campaigns.
• Identify and resolve functional errors.
• Support users in using the tool.
• Steering of monthly level 1 control campaigns
• Prepare monthly campaigns.
• Launch campaigns between the 20th and the end of the month.
• Monitor responses.
• Identify users or managers who have not responded.
• Produce lists of late respondents.
• Ensure adherence to the campaign schedule.
• Control and reporting of results
• Export campaign results.
• Control data consistency and reliability.
• Identify any errors.
• Perform necessary corrections on the data.
• Prepare information for reporting.
• Power BI Reporting
• Populate Power BI dashboards.
• Check displayed results.
• Identify data errors.
• Make simple adjustments to reports.
• Ensure reporting is available before the 7th of the following month.
• Functional support for users
• Respond to user requests.
• Support users in the campaign process.
• Identify and resolve difficulties related to the use of the AGIR tool.
• Data Quality
• Contribute to data quality.
• Check the completeness and consistency of information.
• Identify anomalies.
• Participate in the validation of control and reporting processes.
• Advanced Excel – Essential Skill
• Operational mastery of advanced Excel, including:
• Advanced formulas.
• Lookup functions.
• Pivot tables.
• Handling large files.
• Data cleaning.
• Data control and verification.
• Concrete experience in handling complex Excel files is particularly expected.
• Power BI – Operational Use
• Ability to:
• Populate existing Power BI reports.
• Check results.
• Correct anomalies.
• The need is for operational use of Power BI, not advanced expertise in developing decision-making solutions.
• VBA – Understanding and Maintenance
• Expected skills:
• Understanding of existing VBA macros.
• Error identification.
• Macro troubleshooting.
• The consultant is not intended to act as a VBA developer.
• Functional administration of business tools
• Repository management.
• Data imports.
• User management.
• Functional administration of campaigns.
• Error identification and resolution.
• Functional support.
• Reporting and data quality
• Data preparation.
• Consistency checks.
• Campaign monitoring.
• Report production.
• Verification and validation of results.
• Management of control campaigns
• Ability to manage a monthly process.
• Deadline monitoring.
• Response checking.
• Identification of delays.
• Production of reports.
• Risk management and internal control
• Knowledge appreciated in the following areas:
• Operational risks.
• Internal control.
• Sectoral knowledge
• Experience appreciated in one of the following environments:
• Banking.
• Insurance.
• Large organization.
• Campaign preparation.
• Repository updates.
• Functional administration of AGIR.
• Launch of control campaigns.
• Campaign monitoring:
• Response tracking.
• Identification of late respondents.
• Data control.
• Anomaly resolution.
• Export of results.
• Populating Power BI dashboards.
• Making reporting available.
• Number of positions: 1
• Experience: 0 to 3 years
• Salary: €35K
• Remote work: 2 to 3 days per week
• Start date: 01/04/2027
• Working hours: Full-time

Project details

• Start: flexible
• Remote: hybrid
• Location: 92130 Issy-les-Moulineaux, France, FR
• Languages: French