Data Integration Analyst (MS SQL)

Recruiter
Actis Recruitment Ltd
Location
Blackpool
Posted
15 Apr 2018
Closes
18 Apr 2018
Contract Type
Permanent
Hours
Full Time
Data Analyst / Data Verification (MS SQL & CRM) up to 30k - basednear Preston & Blackpool This highly successful and expandingLeisure & Hospitality organisation is in the process of amalgamatinga number of CRM databases using Talend and is seeking to recruit anexperienced Data Analyst with strong SQL Server (T-SQL) skills. PERSON SKILLS Essential 2 years+ experience of managing and integrating data Testing of Data Flows Strong Analysis skills MS SQL Server (T-SQL ) ideally with SSRS, SSIS etc Excellent communication skills. Numerate, logical, educated to A Level standard. Knowledge of Excel, Powerpoint, Project, Visio, MS Dynamics CRM,DotMailer, and Power BI would be an advantage as would experience ofhaving worked in a Sales and Marketing environment or in Hospitality. THE ROLE Control and manage all aspects of CRM (MS Dynamics 365) data Assist CRM Manager & Developer in project lifecycles fromrequirements gathering, design and Test, taking a lead role in the Test stage Monitor all data ensuring only validated (format & content) dataenters the CRM system Identify causes of data anomalies and influence process for datacapture to ensure validity and integrity of data entering the CRM system Advise CRM Manager on structure, design and performance of CRM Data Provide MIS across the organisation undertaking investigation,analysis, design, and project work to maximise use of the CRM system Produce MI reports as requested. The Data Analyst will be expected to: Build an in-depth knowledge of the CRM database and its uses Design & implement Data Flows, testing integrations Investigate and diagnose any failures in data flows Design & maintain a responsive information service for staff andintroduce MS Power BI tools. Marketing data is key to our client so this is an exciting careeropportunity to join a well established company who hold many awards incInvestors in People, and who can offer an excellent working environmentand benefits package. Based Fylde coast commutable from Blackpool.Preston, Blackburn. Salary 26,000 to 30,000neg dependant on experience. To 30,000 +excellent benefits package - provided by Dice BI, CRM, DYNAMICS CRM, SAP CRM, SQL, SQL SERVER

Similar jobs

Similar jobs