senior data analyst needed at NY

.

 

Functional Title: Senior Data Analyst

 

Location: NY

 

Duration: 12 + Months

 

Have to be your current h1/w2 candidates

Job Description:

 

Work to be performed:

 

·         Create and maintain advanced queries/procedures in order to conduct regular audits on member databases as well as any data sources that fuel the Data Warehouse, segmentation or   impact online marketing efforts, ensuring member profiles are accurately portrayed throughout.

·         Create and present dashboard reports that monitor file health and identify abnormalities

·         Identify, Analyze and interpret trends, patterns in complex data sets

·         Monitor output of customer consolidations to ensure proper handling.

·         Identify problematic areas and conduct research to determine the best course of action to correct the data

·         Perform special ad-hoc analyses on member file, history etc. as needed

·         Create accounts that simulate and validate segments and ensure each are receiving appropriate efforts, cadence, experience.

·         Test, simulate and evaluate each respective opt-out and suppression method, including breaking the link/spam re-opts within current corporate PCH best practices in place by Compliance team.

·         Work with data team, Data analyst and Email Service provider to ensure data flow to third party vendor is timely and accurate.

·         Responsible for supporting customer service inquiries and researching specific requests via database SQL queries.

·         Investigate online reporting anomalies as needed

·         Work with Cognos reporting team to enhance and automate Key back end reporting

·         Help Data analyst review daily file counts and monitor database health

Other Knowledge Requirements:

 

·         Technical expertise regarding data models and database design development.

·         Expert skills in advanced SQL database queries, building views/procedures against SQL Server 2005/2008 BI stack. 

·         Experience with Microsoft SQL database and related tools, or other statistical packages is desirable for analyzing large datasets

·         Expert and Report Writing

·         Expert at  Excel Pivot Reports Development

·         Ability to present complex information in an understandable and compelling manner

·         Must be able to work independently without direct supervision or encouragement

 

Thanks,

 

 

Radhika Raghavan, Director of Business Development

SSAI Technologies LLC| Board: 908 393 2374 | cell 908 720 5780/Fax - 908 842 0244 | www.ssaitech.com | Email: radhika@ssaitech.com |  ssairadha@gmail.com;/IM yahoo-radhasysnet@yahoo.co.uk/raghavanradha@hotmail.com;

WBE/MBE certified for the State of NJ

View my profile at http://www.linkedin.com/in/radhikaraghavannj

Note: We respect your online privacy. TBill s.1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line. I am sorry for the inconvenience caused to you

SAP online training taking place from this month. Any queries  please donot hesitate to contact me.

Any one have project in CLOUD wants to excute it please do contact me