Data Analyst (SQL Server)
Data Analyst / Data Verification (MS SQL & CRM) – up to £30k - based near Preston & Blackpool –This highly successful and expanding Leisure & Hospitality organisation is in the process of amalgamating a number of CRM databases and is seeking to recruit an experienced Data Analyst with strong SQL Server (T-SQL) skills. PERSON SKILLS Essential 2 years+ Data Analysis MS SQL Server (T-SQL ) ideally with SSRS, SSIS etc Knowledge of managing and integrating data Excellent communication skills. Numerate, logical, educated to A Level standard. Ideally some experience of Testing Data Flows. Knowledge of Excel, Powerpoint, Project, Visio, MS Dynamics CRM, DotMailer, and Power BI would also be an advantage. THE ROLE Control and manage all aspects of CRM (MS Dynamics 365) data Assist CRM Manager & Developer in project lifecycles from requirements gathering, design and Test Monitor all data ensuring only validated (format & content) data enters the CRM system Identify causes of data anomalies and influence process for data capture 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 it’s uses Design & implement Data Flows, testing integrations Investigate and diagnose any failures in data flows Design & maintain a responsive information service for staff and introduce MS Power BI tools. Marketing data is key to our client so this is an exciting career opportunity to join a well established company who hold many awards inc Investors in People, and who can offer an excellent working environment and benefits package. Based Fylde coast commutable from Blackpool, Preston, Blackburn. Salary £26,000 to £30,000neg dependant on experience.