Job id : 3186
Analyst/Senior Analyst(SaaS,MySQL,Unix)
  Bangalore / Bengaluru
   CITI INDIA        Bangalore / Bengaluru
  3 years ago      135 Applied
Job details

Job Type

  Full Time

Functional Area

Investment/Corporate/Retail Banking/Insurance

Industry

Banking/Financial Services/Insurance

Education

B.Tech/B.E-Computers Science, M.Tech -Computers Science, MCA -Computers Science

Experience Required

  2 - 3 Yrs

Skills Required

   SaaS ,MySQL ,Unix

Job Description
Business/Department Objectives: The role of Analyst/Senior Analyst – Strategic Information Solutions group is based at COE Bangalore Center and reports to the Manager/AVP. The Analyst / Senior Analyst will be part of one of the business teams COE partners with (NA Cards, NA Retail Bank, EMEA Cards, APAC Cards, APAC Retail Bank, Banamex, Growth Venture, etc.) The key requirement for the Analyst / Senior Analyst role is the ability to understand the business, develop data-driven solutions to address business problems and independently manage end-to-end project communication with business partners. The individual will possess the ability to work in teams and display a proactive learning attitude. We are looking for Self-motivated individuals who are comfortable working in teams with high growth potential and involved in transitioning the highly complex and critical projects. A flexible, positive and mature mindset to deal with ambiguities of complex business problems is a must. Core Responsibilities: Data Extraction and Data Manipulation: Take ownership in extracting data from various data sources Requires an understanding of the project objectives and data requirements, working with the huge databases to meet the data needs for the project Campaign List/Fulfillment/Rewards Tracking and Execution: Understand the campaign objective, requirement gathering on the data needs/system needs, etc. Code, test and execute the campaign requests as required using SAS Work closely with the business partners and ensure timely delivery of rewards files for posting and engage in list management activities (targeting, list pulling, channel file creation) across business units standardization and efficiency- achieved by having a standardized data flow, common definitions across campaigns, etc. Role would also require post – campaign tracking and data management activities as required Presentation of Results: Individual would be expected to independently design presentations to summarize the result of analysis Business Knowledge: Develop an understanding of the domain/function The individual is expected to develop domain expertise in his/her work area Teamwork: Develop cross-site relationships to enhance leverage of ideas Set and manage partner expectations Coach and mentor junior analysts by sharing business, functional and technical expertise Communication and Relationship: Independently manage end-to-end project/partner communication across the various levels in the organization Extremely critical to develop and maintain smooth relationship with partners across business units Day-to-Day Responsibilities: Design and development – end-to-End set-up of the campaign file ( targeting/fulfillment/MIS) delivery process (request, initiatives , validation and posting files) , understand data requirements (Code, Test and Execute) and assist with simple MIS and analytics requirements (this is not a modeling/complex analytics role) Work closely with partners across business units to understand project requirements, timely delivery and partner communication with 100 % accuracy and solving business problems Auditing and quality checks are extremely critical for this role Timely partner communication and attending business calls Data driven solutions and working on critical initiatives Identify opportunities to drive data analytics solutions Key Deliverables: Design and development of data files/reports – regular and ad hoc Work closely to create all targeting/channel/fulfillment files as required On-time delivery and quick TAT, multi-task and manage multiple projects independently Planning and Prioritization, Partner communication. Handle new transitions within tight timelines Automation of BAU , develop self-service solutions and deliver business value Ideas and Suggestions for continuous improvement , Contribution to organizational initiatives Communication: Effectively communicate strategic considerations with team, partners and senior management Share best practices across SIS groups and implement best practices, drive data and analytics solutions Interact and present results to senior management Education: Master degree in Information Technology, Information Systems, Computer Applications or Engineering from a premier institute BTech/B.E/MCA in Information Technology, Information Systems or Computer Applications with additional 2 years of experience Experience: (Required) Established competency in one or more of the following: Data manipulation , extraction of data from huge/complex databases using SAS/SQL is required (SAS hands-on experience is a must) Ability to interact with multiple stakeholders, automate, optimize, standardize and rationalize data, metrics and reports Knowing Spanish language is a plus Experience in Campaign MIS and reporting is preferable Good VBA and Excel skills Strong analytical aptitude and logical reasoning ability Strong presentation and communication skills Strong process/project management skills Hands-on knowledge – SAS (Base and Advanced), MS SQL Server, UNIX, (SAS hands-on experience is a must) Excel, report automation skills Good communication skills is mandatory Experience: (Preferred) Financial domain (Cards/Retail Bank/Mortgage) background preferred Experience working with off-shore industry preferred Any campaign tools