IT SQL Data Analyst

V12 Group
Red Bank, NJ
Job Type:
Yrs of Exp:
2+ to 5 years

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 Analyst will be responsible for supporting all the data needs of various departments of the company (sales, acquisition, operations, etc.). IT manages numerous large databases across several servers. 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. Also, as marketing campaigns complete, you will aid in the delivery of standard reporting metrics to V12 clients. Our expectations are high and critical thinking ability is a must. Skills & Required Technical Experience: Bachelor's degree with an emphasis in Technology or Statistics or equivalent work experience. 3+ years of business experience. 2+ years of MS SQL Server (2005/2008), Transact-SQL, Stored Procedures, Reporting Services (SSRS) 2+ years of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) 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. Compiles and prepares reports, graphs and charts of data developed by analyzing situations and/or data 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. Ability to work with and maintain 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 and execution a plus. Ability to multi-task multiple execution team deliverables and meet deadlines. 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

Jobs Like This Near Red Bank, NJ


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

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