Data Analyst - Global Market Regulatory IT

Job Description

About Businessline/Function :Global Markets The Global Markets business of BNP Paribas helps its corporate and institutional clients leverage capital markets across the globe for their financing, risk management and investment needs. This encompasses a wide range of financial products ranging from Foreign exchange to complex Equity Derivatives that are traded in financial markets across the globe 24/7. IT systems are integral to the business and are a key part of the value proposition to clients. These IT systems range from industry standard products for standard process automation to internally developed, often, market leading IT applications. The IT teams owning these IT systems are made up of functions that include Technical and Application production support, Business Analysis & Project Management, Development & Maintenance and Quality Control. BNP Paribas India Solutions is an equal partner in these IT functions along with colleagues in other locations including Paris, London, New York, Tokyo, Singapore & Hong Kong. This partnership ranges from sharing the IT work load, executing global strategy to owning global applications offshore. The technology and engineering landscape is wide, encompassing almost all techniques and platforms. It continues to evolve and transform with the market with the business continuing to invest in it.Regulatory IT Regulatory IT comprises of software systems which manage reporting to Regulators in the Americas, EMEA and APAC regions. These systems1) Manage the generation of real time reports to Regulators2) Control and monitor trades, positions and breaks for report accuracy3) Make Pre trade regulatory checks and alert compliance violations.Job Title:Technical LeadDate:12 March 2019Department:Global Markets Regulatory ITLocation:ISPL MumbaiBusiness Line / Function:Global Markets ITReports to: (Direct) Sandip HULMUKHEGrade: (if applicable) (Functional) Mathieu MASSONNumber of Direct Reports:0Directorship / Registration:NAPosition Purpose ODIN is a datawarehouse application and it is changing its overall architecture and migrating to new efficient data model, Also few of the technical upgrade are due in this year. To cope up with increase in reporting demands we need to design new analytical CUBES. It demands senior technical expertise in the team, who can take up the responsibility to do overall architectural, design decisions, and can speed up the BAU as well as contribute to build the overall skills of the team to face the new challenges. Responsibilities Direct Responsibilities & Contributing Responsibilities
1. Participate in technical planning & requirements gathering phases including design, coding, testing, troubleshooting, and documenting the application.
2. Interface with key stakeholders to define, analyze, and deliver requirements that reflect the needs of the business, and translate to detailed design specifications
3. Lead in the creation, development, implementation, configuration, maintenance, and support of data models for databases, data marts, and data warehouses
4. Develop methods to store, organize, and report data and incorporate development operations automation where appropriate
5. Identify potential design, process and/or system changes to optimize performance, and mitigate risks
6. Study data, identify patterns, make sense out of it and convert it to algorithms.
7. Designs and plans BI, and other Visualization Tools capturing and analyzing data from multiple sources to make data-driven decisions, as well as debugs, monitors, and troubleshoots solutions.
8. Carry out exploratory development to integrate new components into existing software.
9. Propose new technical solutions and best practices, discuss and present their ideas in detail to stakeholders
10. Prepare diagrams and exhibits to explain proposed system to managers and users in a clear format.
11. Identify performance bottlenecks, profile applications & tune SQL queries.
12. Contribute to Architecture standards and best practices.
13. Setup new / enhance the existing processes and create SOP.
14. Contribute to the Release and Sprint planning.
Technical & Behavioral Competencies Mandatory Technical expertise required:
• Oracle (+++) / T-SQL (+++) (preferably) - including optimization of stored procedures, queries
• Python
• Exposure to any ETL Tool (++)
Nice to have Technical skills:
• MS BI 2008 R2/2012
  • SSIS (++)
  • SSRS (++) including MDX (+)
  • SSAS 2008 R2/2012 (+) including MDX (+) and optimization of cube process performance
• Shell script (++)
• Subversion (+)
• Angular JS
• C#.net
Behavioral Skills
• Curiosity and analysis skills and willingness to learn.
• Good Communication skills.
• Quality-focused with a good eye for detail.
• Capacity to work in a high-pressure environment.
• Must be able to work closely with distributed team, users and business analysts.
• Willing to share knowledge and skills with other developers within the team.
• Whilst able to work independently, should be a true team player.
• Creativity and Problem solving attitude.
Specific Qualifications (if required) Skills Referential Behavioural Skills : (Please select up to 4 skills)Decision Making Ability to deliver / Results drivenCritical thinkingActive listening Transversal Skills: (Please select up to 5 skills)Ability to develop and adapt a process Ability to anticipate business / strategic evolution Ability to develop others & improve their skills Ability to set up relevant performance indicators Ability to manage / facilitate a meeting, seminar, committee, training Education Level: Bachelor Degree or equivalent Experience Level At least 7 years Other/Specific Qualifications (if required),

Keyskills :
microsoft excelsqldetail designdata analysisdata modelsinternational financial institutionscustomer relationsreporting