SQL Data & Quality Assurance Analyst

Company:
V12 Group
Location:
Red Bank, NJ
Job Type:
Posted:
6/14/2013

Related Jobs

Job Description

V12 Group is a leading provider of data and cross-channel digital marketing that empowers organizations of all sizes to communicate with prospects and customers through email, mobile, social media, and digital display ads. V12 Group’s marketing automation platform, Launchpad, hosts a suite of integrated applications that enable marketers to plan, automate, deliver and optimize data driven marketing and real-time communications to drive new and existing customer engagement, increase sales and improve return on marketing investment. We have an outstanding opportunity for a Microsoft SQL Server Data Analyst to join our IT organization. Position Responsibilities: The Data & Q/A Analyst will be responsible for supporting all the data needs of various departments of the company (sales, acquisition, operations, etc.). Implementing and managing all aspects of data quality assurance will be a main priority. The job functions include, but are not limited to developing complex MS SQL Server queries for data extraction and reporting, performing data conversions (ETL) from several data sources, develop necessary SQL for loading, updating and maintaining data tables. Also, trouble-shooting data file related issues, and quality control. Our expectations are high and critical thinking ability is a must. The candidate will test and verify processes and systems to understand the cause of data issues. Statistically analyze data and interpret findings to identify opportunities for database and product improvements. Additionally, this position will create and maintain detailed documentation as required pertinent to problems and errors produced by database processes and applications. Coordinate various business improvement initiatives by applying excellent analytical and problem resolution skills. Retrieve data from various sources and prepares data for analysis. Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2008 Quality Assurance - Verify accuracy of data pulled and revises methods of data retrieval by following a standard process. Perform internal audits: gather data from various sources/applications and databases to validate audit steps performed; evaluate quality assurance Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries. Analyse and interpret data, producing clear and compelling reports for different audiences which may include graphs and charts of data developed by analyzing situations and/or data models from which answers can be obtained. Supports business area projects by applying general knowledge of the business area processes including best practices. May provide data and respond to questions to external groups/agencies/vendors. Intermediate MS Office skills including the ability to create, manipulate and formulate spreadsheets. Knowledge of spreadsheet functionality including v-look-up, pivot tables, charts and graphing. Must be well organized, extremely detail oriented and have great communication skills, both oral and written. Concisely summarize and communicate recommendations to various levels of management maintaining confidential information Must be flexible and have the ability to adapt quickly as external environment and organizational changes occur. Write queries and stored procedures in SQL, exports data into excel or csv files, reviews them for quality and data integrity, and sends them to internal clients or external agencies. Combining of data files for use of suppression or enrichment (Combining of different outputs format to aid in targeting) Basic understanding of the direct marketing project process flow, including postal database structure is a plus. We offer a competitive salary commensurate with your experience as well as the following benefits: 12 Days PTO (Paid Time Off) earned on an accrual basis. 10 paid Holidays. 401k plan (eligibility after 90 days of employment) 50% employer paid medical, dental and vision benefits (eligibility after 60 days of employment) Flexible Spending Account. Company paid Long Term Disability and Life Insurance (eligibility after 90 days of employment) Various other employee assistance programs
APPLY NOW



Jobs Like This Near Red Bank, NJ


GO


Click on the button below to go to the V12 Group website and apply for SQL Data & Quality Assurance Analyst.

GO TO EMPLOYER WEBSITE
  • Copyright ©2014 Dice Holdings, Inc. All rights reserved.
Log in 
FINS Login
 
*Indicates required field
 
User Name*
Password*
     Forgot Your Password?
Or log in using your Facebook account:
Connect with Facebook