Data Analyst - Python & Power BI

About Business line/Function:

The Intermediate Holding Company (IHC) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platforms operating model due to the drastic changes introduced by the Enhanced Prudential Standards (EPS) for Foreign Banking Organizations (FBOs) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S Dodd-Frank Act.

The IT Transversal Team is part of the Information Technology Group which works simultaneously on a wide range of projects arising from business, strategic initiatives, and regulatory changes and reengineering of existing applications to improve functionality and efficiency.

As part of the transformation, the team is spreading the culture of Data driven outputs for the various business functions for the reporting line.

- Able to analyze huge data and identify any functional gaps on Data front and Data Quality.

- Perform detailed analysis on data / functional gaps, conduct / organize sessions with Stakeholders/ Clients, to discuss / brainstorm these gaps and present these functional gaps in a summarized manner to Business Stakeholders/ Clients.

- Work extensively on Reporting using Power BI on the analysed data set to provide business insights.

- Coordinate with techno functional team in explaining to them the logic based on which the data needs to be created for the reporting requirement.

- Explain the functional gaps to techno functional team so that they can incorporate those checks as part of testing / Delivery.

- Perform reconciliation on month end data Vs tactical adjustments and generate variance analysis.

- Develop test cases if required aimed at validating development for a given requirement and record them in the official test management platform.

- Partner with Onshore leads to present the created solution, Share the knowledge and provide training if required.

- Produce and distribute daily/weekly team Status reports and contribute to project status reporting depending on the undertaking at hand

- Create Documentation as per the project needs.

- Perform knowledge transfer and cross training for proper backup in team

- Understanding of various data models for extraction of required data sets to be consumed for PBI reporting.

- Able to work with different data sets and create relational models.

- Proficient in MS Office applications; MS Project, MS Visio.

- Python knowledge and inclination to work on it will be an added advantage.

- Ability to Adapt to new technologies and flare learning and implement projects with new technologies.

knowledge of the following:

Power BI dashboard development

- Understanding of Python and basic coding.

Skills Referential

• Communication skills - oral & written
• Ability to collaborate / Teamwork
• Adaptability
• Active listening

• Analytical Ability
• Ability to develop and adapt a process
• Ability to understand, explain and support change
• Ability to manage / facilitate a meeting, seminar, committee, training
• Ability to anticipate business / strategic evolution

Education Level:

Bachelor Degree or equivalent in computer application

Other/Specific Qualifications

- A self-starter who can take the process a level ahead and have the ability to think out of the box, suggest and challenge status quo.

- Ask questions and understand the larger picture for the tasks assigned.

- Display a sense of curiosity, enthusiasm and eagerness to understand business constraints, environment and impact on regulation for the financial industry.

- Excellent communication skills (both verbal and written)

- Excellent organization, analytical and time management skills.

- Ability to work under pressure and flexible to work extended hours or weekend working.

- Ability to work independently and become an effective team member.