Exl Service

  • Data Analyst, Decision Analytics Services (RPM)

    Job Location US-NJ-Lambertville
    Regular Full-Time
  • Overview

    ETL Production Analyst


    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.


    Please visit www.exlservice.com for more information about EXL Analytics.


    RPM Direct, a division of EXL Service Holding, Inc., is a leading developer of customized database solutions that drive successful marketing programs across the insurance industry. To meet our growing business demands, we’re looking to add a highly motivated and talented individual to our database production team.


    The ETL Production Analyst will help ensure the accurate and timely extraction, transformation, and loading of data, and will work closely with the marketing operations and campaign development teams to complete routine campaign database activities, conduct troubleshooting, and provide ad hoc project support.


    • Core responsibilities include the completion of daily, weekly, and monthly offline and online data production activities, collaborating with operations and campaign design teams to align data requirements with project objectives.
    • Day-to-day activities include: ensuring proper input file naming conventions, troubleshooting and resolution of data loading errors, data mapping of output file record layouts, metadata setup and support, performing data matching and appending, and other related activities.
    • Writing and updating PL/SQL scripts and procedures.


    • Master’s or Bachelor's degree in Computer Science, Computer or IT, or Computer Engineering
    • 5+ years writing and updating PL/SQL codes and updating scripts and procedures
    • Previous experience supporting a Direct Marketing business is a plus
    • Strong working knowledge of SQL required - writing and updating code
    • Experience with Oracle PL/SQL is preferred
    • Knowledge of SQL Analytic Functions is preferred
    • Exposure to Unix Scripts is a plus
    • Apex development experience a plus
    • Highly motivated and can work collaboratively with others in a fast paced environment
    • Able to effectively manage multiple projects at any given time, under pressure while working quickly to develop clear priorities
    • High attention to detail with focus on quality and compliance
    • Takes initiative, and engages is continuous self-directed learning
    • Acute problem solving ability, with good communication skills and style

    What we offer:


    • 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. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants.
    • You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth. 
    • Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.
    • We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors.
    • Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond.


    EEO Statement



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