Data Analyst

Job Title : Data Analyst
Department : Enterprise Technology Solutions (ETS)
Reports To : Lead Analyst
Location : Gandhinagar

Summary

Data Analyst is responsible for integrity of lead information, categorization and sterilization of lead files, resetting and provision of customized filters for all outbound programs. In addition to list loads, the team also has the responsibility for pre and post analysis of lead information while providing solutions to the operations division and CTI team regarding those leads in ways that are designed to maximize productivity. As part of its defined process, the list team also has accountability regarding compliance through lead suppression and implementation of dialing restrictions. Part of the methodology of lead suppression includes file comparisons to “Do Not Call” lists supplied both internally as well as through Etech’s partner in compliance “Possible Now” on the federal and state levels

Essential Duties and Responsibilities:

  • Receive and process lead information
  • Verify lead information falls within all compliance parameters and categorize and account for those records that are considered un-callable due to federal and state legislation as well as local and client
  • Process all callable leads and make them readily available for dialing
  • Provide load reports detailing information such as callable loads, geographic locale, etc.
  • Ensure continued performance of leads through analysis and monitoring
  • Summarize, Reconcile, and Return lead information once completed through final disposition status, expiration, un-callable status, etc.
  • Provide recording as well as missing information from database.
  • Implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
  • Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
  • Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
  • Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
  • Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.

Qualification:

  • Computing studies such as Bachelor Degree or Diploma in Engineering (Computing) or Computer Science with minimum 2 years experience.
  • A good understanding of Database systems, Database Achitecture and Sql.
  • Vendor certification (eg, Microsoft Certified Database Administrator)

Knowledge of:

  • Microsoft Sql server 2000/2005/2008.
  • ETL Tools like SSIS, Talend.
  • Pl/Sql.
  • Should be well versed with Different file Formats for parsing files like Flat File, JSON, XML and etc.
  • Data Warehouse / BI concepts and CTI knowledge would be added advantage

Ability to:

Prioritize work, multi task, problem solve.

Education and/or Experience:

Bachelor’s degree or Diploma from three to four year college or university; or 2 to 3 years related experience and/or training; or equivalent combination of education and experience.

Language Skills:

Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents. Ability to respond to common inquiries or complaints from customers. Ability to effectively present information to top management, Team Leaders, and/or boards of directors.

Mathematical Skills:

Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Reasoning Ability:

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Certificates, Licenses, Registrations:

Valid driver’s license or other Government issued ID.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit and use hands to finger, handle, or feel. The employee is occasionally required to stand, walk, reach with hands and arms, and talk and hear. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee regularly works in inside environmental conditions. The noise level in the work environment is usually moderate.

Go To Job Openings | Please send your resume to wanttowork@etechgs.com