Senior Data Engineer

Job Purpose

• Responsible for managing and driving a team of Virtual Relationship Managers (VRM) handling

portfolio of eligible Imperia & Preferred customers in order to achieve the targets set and that all

guidelines and regulatory requirements are followed.

• Ensuring that customers get world-class services and their needs are understood and met through

financial products that the Bank has to offer.

• Consistently meet portfolio objectives defined Viz. sales, income, group product holding etc.

• Ensure adherence to Operations process aimed at zero defect transaction processing & meeting the

Audit & Compliance guidelines.

• Responsible for managing, training and motivating staff.

• All of the above parameters consistently met by the team of VRMs.

• Income generation through a right blend of enhancement of CASA balance and through cross sell of appropriate products. So that the VRM becomes the top of the mind recall amongst the customers in the catchment for all their financial needs and services, thereby ensuring that the VRMs also achieves the key performance parameters set

Job Responsibilities(JR) : 6 – 8 Areas

Business Achievement and Development for VRM & Team

• Ensure proper scoping is done and target / niche customers identified with ACTIVE collaboration from concerned Product/Sales Support Teams

• Ensure that the targets on liability accounts, through the channel (Branch and direct sales), are met under all parameters specified.

o Meet value target for Liability Balances of the customers

o Ensure quality of sourcing is maintained and depletion rates are controlled.

o Ensure that Salary credits reach or exceed the expect Salary Credit targets

• Ensure that all managed portfolios are effectively managed through VRMs and that set targets on each of the portfolios is reached.

• Also, Team Manager has to ensure seamless servicing of customers.

• VRMs are made aware of the Scorecard targets & Portfolio Benchmark.

• Ensure that the High Net worth individuals are persuaded to avail the private banking products and services (advisory, etc.)

• Ensure that there is cross sell to the customer on asset products as offered by the Bank.

• Ensure that the customers get credit cards and start using the same for all their transactions- credit card activation push.

• Income to be generated at a customer level.

• Ensure that cross sell targets on Third Party Products is met for the Unit

• Ensure Staff are trained on product knowledge and requisite certifications

• Engaging with bottom 20% performers and identifying ares of improvement and demonstrating the How.

• Review Daily Sales Report of the staff and provide guidance on ways to improve on the same

• Managing and monitoring performance of all the sales resources

o Productivity of Liability and Non Liability sales staff

• Attrition control of customers

o Includes persuading the customer to continue and if required renew FD’s

§ Monitor large amount movements / account closure from the deposit accounts and ensure that customer does not attrite

o Ensure that the marketing analytics list on possible attrite, is called and retained

• Ensure that there is no revenue leakage

Customer Service / Customer engagement

• Plan monthly/ weekly/ daily contacts for the team of VRMs basis the contact policy & track implementation

of the interaction plan.

• Effective planning & implementation of event based trigger, birthday calls, campaign calls and other defined

objectives for customer contacts.

• Ensure that VRMs offers highest quality of service to the customers and meets expected Service Quality standard by educating the customers to use the Digital Banking mediums for their banking transactions /

needs. This is measured iva call evaluations and Sup

Reviews

• To review contact attempts versus successful contacts and analyze reasons for non-contactable customers.

• Ensure VRMs make regular contact with customers for service as well as business updates.

• Adequate logging of complaints, Reviewing & Resolving all complaints received (VRM, self, branch, other units) within the stipulated TAT

o Monitor all complaints received and ensure that they are closed within TAT

o Improve customer communication on closures

o Check with customers if the process of complaint has been managed well

o Ensure no escalations happen

o Preventive complaint management

o Asking for feedback from customers, who are not complaining

o Discussing with staff the importance of getting feedback from customers on a regular basis

• Periodic review of customer base i.e. Contactibility,

Eligibility, Product penetration & profitability. Take appropriate action to activate every customer / improve

the product penetration & profitability of the customer to become a Primary Banker for the customer.

• Carry out VoC to assess strengths and to ascertain possible improvement areas of the VRMs basis customer feedback. Take appropriate action- reward the VRM for appreciations/ corrective actions as required.

• Monitoring implementation of Sales Process.

Business Generation / Sales Tracking

• Track business generation and income for each VRM in the team on a daily basis, and take due steps.

• Review leads generated by each VRM and ensure real time lead status availability.

• Ensure VRMs actively track their leads, keep customer regularly updated on the lead status & complete the lead closure within a reasonable timeline, basis product.

• Tracking and highlighting possible customer issues on account of improper lead management.

Supervisory Reviews frequency to assess effectiveness of customer interactions by the VRM.

• Check profiling done by the VRM to ascertain effectiveness.

• Basis interaction logs captured by the VRM & discussions with the VRM, provide directional inputs on customer interactions & business generation.

• Demonstrate “how”.

• 220 Sup Reviews per month

Operations

• Conduct internal checks on a regular basis & share a feedback with VRMs on time to time.

o Lead file maintained by VRMs

o Requests captured by VRMs

o CRM Interaction

• Ensure seamless handling of operations areas such as customer requests, transactions, reversals etc.

• Handling queries of VRMs on floor and provide resolution.

• Ensure timely responses to customers through call out/ e-mail as applicable.

• Handle 1st level escalations and ensure satisfactory resolution to the grievances.

• Ensure judicious utilization of financial and non- financial authority.

• Carry out periodic checks to ensure team adheres to Audit & Compliance guidelines.

Audit and Service Quality

• Ensure all laid down system and process are followed as stipulated by Audit and Senior Management

• Monthly / Periodic Verification of Auditable items.

• Review of CRM Interactions & Lead Quality

 MIS - Reporting and Analysis :

• Ensure timely and accurate updates of all portfolio

performance parameters.

• Maintain track of VRM performance w.r.t leads, conversions, income, achievement of portfolio parameters etc.

 Staff Management

• Ensure that all VRMs are adequately trained on the

Products of the bank and sales process

• Ensure that all VRMs are trained on the process to be followed (including amendment with new circulars)

• Be aware and make VRMs aware of various policies of the bank with regard to customer service and compliance

• Monitor productivity and give guidance on improving the same in conjunction with the Line Manager / Unit Head.

• Ensure that all VRMs are sent for class room training on a regular basis

• Ensure that nominated VRMs attend training sessions conducted by HR, without fail.

About Company

Our client is a leading mid‐market investment bank with strong practices around M&A, PE, Capital Markets, Institutional Equities, Wealth Management, Insurance Broking, and Portfolio Management Services.

Roles & responsibilities:

• Key connect with Insurance Companies to procure competitive pricing and terms

• Timely and compliant placements of all lines of General Insurance Products

• Assisting the sales team to close business

• Client onboarding, retention & renewals, and servicing requirements

• Assisting onboard clients for all their new / renewal requirements

• Keeping customers updated on the latest products to increase sales.

• Preparing RFQ’s for all General Insurance requirements

• Retention – Manage servicing team for renewal retention; visiting clients for managing relationships; retention of existing policies/clients

Requirements:

Technical Skills:

• MS Office – Word, Excel, PowerPoint, and Outlook.

Education, experience & skills required:

• Graduate / MBA or relevant degree. Insurance degree would be an added advantage.

• Knowledge of insurance / General Insurance domain preferred.

• 2 to 4 years of experience in Insurance Broking / Placement & Retention.

• Excellent interpersonal and communication skills

• Proficient in all Microsoft Applications

• Superior product knowledge

• A team player with leadership skills

• Maintain a positive attitude focused on customer satisfaction.

• Creating and managing ETL/ELT pipelines based on requirements
• Build PowerBI dashboards and manage datasets needed.
• Work with stakeholders to identify data structures needed for future and perform any transformations including aggregations.
• Build data cubes for real-time visualisation needs and CXO dashboards.

Required Tech Skills

• Microsoft PowerBI & DAX
• Python, Pandas, PyArrow, Jupyter Noteboks, ApacheSpark
• Azure Synapse, Azure DataBricks, Azure HDInsight, Azure Data Factory

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

Job Description: 

3+ years of experience as a JAVA/J2EE technologies developer in delivering highly available and scalable applications in a cloud operating environment. - Expertise in Spring framework and equivalent. 

• Experience in developing Java Microservices using spring boot, docker, Kubernetes etc. 
• Programming expertise in Java, JavaScript; and familiarity with other languages.
• Experience building, testing, and consuming REST APIs is a must have experience. 
• Experience with high-throughput messaging technologies and patterns; Kafka and/or related technologies a plus. 
• Exposure to databases of any types relational, analytical, columnar, etc; including MySql. 
• Experience with Git source control and building/maintaining Continuous Integration and Delivery pipelines; Jenkins experience a plus. 
• Expertise in Object-Oriented Development. 
• Experience working in an Agile/Scrum-inspired delivery methodology. - Expertise with database programming, transaction management. Expertise with build tools – MAVEN, Gradle. 
• Expertise in design patterns and data structures. 
• Good understanding of Unit test tools. 
• Good analytical skills to break down requirements and solve complex problems. 
• Good understanding of Source control toolsets. 
• Well-developed verbal and written communication skills. 
• Proven track record to meet aggressive timelines.

Required Skills:

Good to have

• Understanding CI tools like Jenkins, Bamboo. 
• Experience with Google Cloud Platform or equivalent. 
• Experience with Microservices and/or Monolith to Microservice migration.
• Experience with frontend technologies like to react, angular is a plus
• Good Linux experience

• Developing and maintaining dynamic websites and web applications
• Ensure foolproof performance of the deliverable
• Coordinate with co-developers and other related departments.
• Experience own and work on end to end on an application.
• Set Milestones and deadline.
• Fine-tuning and resolve performance issues
• Mentor colleagues and code walk through.

Must have Skills:

PHP, OOP, codeigniter, Jquery, MySQL

Location: Job Location : Senapati Bapat Marg, Elphinstone Road.