Sign In
 [New User? Sign Up]
Mobile Version

Senior Analyst- Excel VBA & SQL

Bengaluru, KA
Job Code:
  • Insurance
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Key responsibilities include Provides expert knowledge of Excel and Visual Basic for Applications (VBA); macros, user-defined functions, Evaluates and troubleshoots existing VBA-enabled templates to fix defects and optimize execution. Provides expert knowledge of databases, including Oracle SQL and Microsoft SQL Server. Learn all the excel forms; excel spreadsheets, VBA code, and SQL tables for these system. Document data flow, data mappings, calculations, and flowchart all the process for actuarial models. Enhance, maintain, processes which build analytic data assets in Excel and SQL server. Automate and improve commonly conducted analysis and calculations, including profitability studies, and pricing strategy development. Perform complex data aggregations and data validations. Analyze historical data. Participate on system maintenance, technical design, testing, implementation, and development of controls throughout the data base system. Support the leader on all the projects lifecycle, specifically design, code, test, and implementation of the pricing actuarial dashboard. Position Requirements BS/BA Degree preferably in Computer Science, Statistics, Math or related area. 5+ years experience in programming, 3+ years experience in the design, development, and implementation of programming code. Consideration given to experience in insurance or related industry. Experienced using SQL language ad VBA code. SAS language a plus. Experience in Microsoft office suite. Experience in database development. Star schema structures knowledge a big plus. Strong analytical and problem solving skills. Work both independently and as part of a team. Strong business and collaboration skills, and responsive to service needs and operational demands. Effective time management skills. Excellent communication, presentation and interpersonal skills. Customer Focus. Willing to learn and self-teach any new technology
Degree: MCA/ PGDCA | ME/ M.Tech./ MS (Engg/ Sciences)

Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 5-10


Application Programming | Database Administration (DBA) | Graphic Designing/Animation/Web Designing | Software Engineer
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News