Verified Job
IT / Software / Data Analyst
BI and SQL Developer
IT / Software / Data Analyst
#358683
Remote / WFH
Job Description
BI AND SQL DEVELOPER (JOB NUMBER: FRE0002+6)
About BNP Paribas Group:
BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 1++ 000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International Financial Services (whose retail banking networks and financial services are grouped together under Retail Banking & Services) and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients (retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region.
About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in Europe with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 6000 employees, to provide support and develop best-in-class solutions.
Job Title:
Developer
Date:
Department:
Fresh BIR
Location:
Business Line / Function:
FRESH
Reports to:
(Direct)
Manager
Grade:
(if applicable)
(Functional)
Number of Direct Reports:
Directorship / Registration:
Position Purpose
The developer is expected to design, develop & maintain the Business Intelligence solutions deployed across APAC and Global FRESH teams. These cover various databases, ETL, reporting technologies & applications for user interactions.
The team develops and maintains internal bespoke software solutions for various Finance & Risk departments. The team uses off the shelf & agile technologies appropriate to the situation & solution.
Direct Responsibilities
1. Business and System Analysis, Design:
Interact with business, functional and technical representatives of project teams, and various territories, Head office representatives in order to analyse reporting & system requirements.
Design Technical Solution & Data Model
2. Prototyping & Development:
Conceptualize the overall reporting approach & module design
Building proof of concepts & prototypes
Development to specifications
Benchmarking of hardware/software platforms;
3. Maintenance & Support:
Enhance, trouble-shoot, understand & resolve problems related to existing systems
Maximize system uptime and ensure alignment with changing business environment.
Partnership: Involve with the review and submission of all solution designs provided by Vendor or in-house application development teams.
System upkeep: To contribute towards housekeeping, system upgrades, installation, backup/restore & adherence to DR plans, to maintain a robust application system platform at all times.
Documentation: Control and oversee timely preparation, update and upkeep of all documents necessary to be maintained within the solution framework, ensure easy availability of information relating to the solutions and processes.
Training: Train users on system functionality and usage in order to ensure effective utilization of application systems.
Quality, Control, Compliance:
Ensure all activities carried-out and solutions proposed, planned and delivered are compliant with policy guidelines specified by BNPP Paribas group globally.
Establishes regular code reviews tied to on-going components/project development.
Adopt standard development practices, operational controls to build robust, efficient & sustainable solutions.
Contributing Responsibilities
Contribute to overall FRESH responsibilities on efficiency, controls, development of solutions.
Technical & Behavioral Competencies
Mandatory skills
Strong Knowledge on database SQL/PLSQL
Good Knowledge of UNIX Shell scripting,
Knowledge on any of reporting tool- preferably BI4.2/BoxiR2 or any other like Tableau , Power BI, VBA
Good understanding of any Database management system
Knowledge of SQL Loader/ Autosys
Nice to have
Technical skills: Alteryx or python will be added advantage
Business skills: accounting, financial products, reporting
Experience on Atlas / Infocenter
Agile methodology
Soft skills:
Excellent Communication Skills
Interpersonal and customer orientation skills
Pro-active behaviour regarding the ability to work in a fast changing and demanding environment
At ease with multi-tasking
Ability to simplify complex information in a clearly organized and visually interesting manner
Strong analytical mind, problem solving, planning & organisation skills
Education Level:
Bachelor Degree or equivalent
Experience Level
03 - 06 Years
Primary Location
: IN-MH-Mumbai
Job Type
: Standard / Permanent
Job
: INFORMATION TECHNOLOGY
Education Level : Bachelor Degree or equivalent (>= 3 years)
Experience Level : At least 3 years
Schedule
: Full-time
About BNP Paribas Group:
BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 1++ 000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International Financial Services (whose retail banking networks and financial services are grouped together under Retail Banking & Services) and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients (retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region.
About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in Europe with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 6000 employees, to provide support and develop best-in-class solutions.
Job Title:
Developer
Date:
Department:
Fresh BIR
Location:
Business Line / Function:
FRESH
Reports to:
(Direct)
Manager
Grade:
(if applicable)
(Functional)
Number of Direct Reports:
Directorship / Registration:
Position Purpose
The developer is expected to design, develop & maintain the Business Intelligence solutions deployed across APAC and Global FRESH teams. These cover various databases, ETL, reporting technologies & applications for user interactions.
The team develops and maintains internal bespoke software solutions for various Finance & Risk departments. The team uses off the shelf & agile technologies appropriate to the situation & solution.
Direct Responsibilities
1. Business and System Analysis, Design:
Interact with business, functional and technical representatives of project teams, and various territories, Head office representatives in order to analyse reporting & system requirements.
Design Technical Solution & Data Model
2. Prototyping & Development:
Conceptualize the overall reporting approach & module design
Building proof of concepts & prototypes
Development to specifications
Benchmarking of hardware/software platforms;
3. Maintenance & Support:
Enhance, trouble-shoot, understand & resolve problems related to existing systems
Maximize system uptime and ensure alignment with changing business environment.
Partnership: Involve with the review and submission of all solution designs provided by Vendor or in-house application development teams.
System upkeep: To contribute towards housekeeping, system upgrades, installation, backup/restore & adherence to DR plans, to maintain a robust application system platform at all times.
Documentation: Control and oversee timely preparation, update and upkeep of all documents necessary to be maintained within the solution framework, ensure easy availability of information relating to the solutions and processes.
Training: Train users on system functionality and usage in order to ensure effective utilization of application systems.
Quality, Control, Compliance:
Ensure all activities carried-out and solutions proposed, planned and delivered are compliant with policy guidelines specified by BNPP Paribas group globally.
Establishes regular code reviews tied to on-going components/project development.
Adopt standard development practices, operational controls to build robust, efficient & sustainable solutions.
Contributing Responsibilities
Contribute to overall FRESH responsibilities on efficiency, controls, development of solutions.
Technical & Behavioral Competencies
Mandatory skills
Strong Knowledge on database SQL/PLSQL
Good Knowledge of UNIX Shell scripting,
Knowledge on any of reporting tool- preferably BI4.2/BoxiR2 or any other like Tableau , Power BI, VBA
Good understanding of any Database management system
Knowledge of SQL Loader/ Autosys
Nice to have
Technical skills: Alteryx or python will be added advantage
Business skills: accounting, financial products, reporting
Experience on Atlas / Infocenter
Agile methodology
Soft skills:
Excellent Communication Skills
Interpersonal and customer orientation skills
Pro-active behaviour regarding the ability to work in a fast changing and demanding environment
At ease with multi-tasking
Ability to simplify complex information in a clearly organized and visually interesting manner
Strong analytical mind, problem solving, planning & organisation skills
Education Level:
Bachelor Degree or equivalent
Experience Level
03 - 06 Years
Primary Location
: IN-MH-Mumbai
Job Type
: Standard / Permanent
Job
: INFORMATION TECHNOLOGY
Education Level : Bachelor Degree or equivalent (>= 3 years)
Experience Level : At least 3 years
Schedule
: Full-time
