Exl Service

VBA/ SQL Developer, Decision Analytics

US-NY-New York
ID
2017-4237
Type
Regular Full-Time
Job Code
DJOB

Overview

VBA/ SQL Developer

EXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa.

EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision making and embed analytics more deeply into their business processes. Our global footprint of nearly 2,000 data scientists and analysts assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization.  EXL Analytics serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries.

Responsibilities

Looking for a VBA/SQL Developer with at least 5-7+ years of experience. As a VBA/SQL developer the person will be responsible for design and development of new applications and enhancements\maintains to current applications perform on projects of moderate to high complexity that impact multiple departments, systems, or work flows. Must have strong knowledge and development experience with Excel\VBA and SQL server. Experience in .Net is a big plus. 

  • Document data flow, data mappings, calculations, and flowchart all the process for Excel models. Enhance, maintain, processes which build analytic data assets in Excel and SQL server. Automate and improve commonly conducted analysis and calculations, and strategy development.
  • Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
  • Create VBA programs and stored procedures to implement business requirements.
  • Develop GUI interfaces using VBA Excel programs.
  • Extensively use Excel functions in development, focusing on read/write integration to databases.

 

Qualifications

  • BS in Computer Science or related area.
  • Proven background on MS Excel VBA Programming and coding.
  • 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.
  • Strong knowledge of databases, including Oracle SQL and Microsoft SQL Server.
  • Expert in database design, writing complex SQL Queries, Stored procedures, preparing DDLs and DMLs.
  • Proven background completing projects under aggressive financial and time constraints.
  • Strong analytical and problem solving skills.
  • Experience in .Net is a big plus.
  • Star schema structures knowledge is a plus.
  • Insurance Industry knowledge is a plus.
  • Willing to learn and self-teach any new technology.
  • 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.

What We Offer:

  1. EXL Analytics offers an exciting, fast-paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions.
  2. The ability to learn aspects of client businesses, effective teamwork and time-management skills and a deeper understanding of statistics and machine learning
  3. We invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.
  4. A talented and experienced pool of mentors and advisors

For more information on EXL Analytics visit www.exlservice.com.

"EOE/Minorities/Females/Vets/Disabilities"

EEO Statement

EEO/Minorities/Females/Vets/Disabilities

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed