Data Specialist

As a Data Specialist you will be part of the Data team and participate on an execution team by performing complex SQL queries and large data extraction and manipulation tasks using only Microsoft SQL Server only. Also as marketing campaigns complete you will aid in the delivery of standard reporting metrics to customers. You will report to Data team lead. The ability to communicate effectively in English is a requirement of this position.

Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2012.

Working with strong and complex queries as well as with stored procedures.

Creates and runs daily weekly and monthly data jobs that populate data repositories while ensuring accuracy and consistency.

Analyzes business requirements and makes recommendations to maximize efficiency quality and compliance on the data work.

Works to analyze and solve complex operational systemsrelated andor customer issue

Creating local databases views table and workflows in order to standardize and industrialize the data cleansing process Removal of malformed physical addresses email addresses or phone numbers

Handling mainly PII data Personal Identifiable Information like name company name phone numbers email addresses job titles etc. requires to adhere to privacy rules.

Responsible for timely execution of marketing activities as defined by SLAs Service Level Agreements.

Attendance completion and participation in new tool deployments updates and trainings as required.

An estimated 8090 of daily works hours should be spent on campaign execution deployment andor reporting on average.

Skills

23 year experience of data cleansing manipulation and extraction and or preparation is required.nbsp

English language skills required further language skills a plus.

Solid skills in Microsoft SQL Server 2008 and 2012 is a MUST and in Microsoft Transact SQL.

Ability to multitask and work under pressure.

Thinking analytically to be able to gatheranalyze information from multiple data sources and design and test the technical solution

Ability to balance and prioritize responsibilities to ensure all deadlines are met.

Ability to compile research and perform indepth analysis on critical operational data.

Demonstrated aptitude to independently provide summary and recommendations on operational data.

Proficiency with Microsoft8217s suite of Office products Word Excel PowerPoint.

Experience with sales analysis and reports using database technical tools SSIS OLAP is a plus

Basic understanding of the direct marketing project process flow and execution a plus.

Good organization skills acute attention to detail consistent follow through.

Ability to work in a team

Education

BSBA required

Official Microsoft certification MCP MCTS or MCITP in SQL Server database and BI developments a huge plus

via http://egypt.tanqeeb.com/jobs-in-egypt/%d8%a7%d9%84%d9%82%d8%a7%d9%87%d8%b1%d8%a9/004134617.html

شارك هذه الصفحة وتابعنا على صفحاتنا الرسمية

شارك الموضوع →

تويت

تابعنا →

إنشر الموضوع →