Our website uses cookies

Cookies enable us to provide the best experience possible and help us understand how visitors use our website. By browsing Infosecurity Magazine, you agree to our use of cookies.

Okay, I understand Learn more

ME368 Data Solutions Manager

Employer: Undisclosed
Posted: 22/08/2014
Location: London, England
Salary: 40,000 - 45,000
Deadline: 19/09/2014

Intapeople have an immediate requirement for an ETL Developer for a prestigious Media Agency based in central London. The role has arisen from the companies continued success and growth. 

Skills, knowledge & experience 

• Have demonstrated SQL expertise in a previous role • Working with Microsoft’s SQL Server stack will be second nature; knowledge of additional coding languages is an advantage • Excellent problem solving abilities – able to think ’outside the box’ when required • Able to understand complex data projects involving multiple stakeholders, taking a methodical approach to issue resolution • Excellent communication skills – can translate business requirements into technical solutions, as well as explain concepts to those less technically minded • Confident working independently as well as in a team; happy to operate collaboratively with the Data Solutions Director as well as help train the Data Solutions Executive. • Can grasp and assimilate technical concepts quickly, with a strong aptitude for learning new technologies • Enthusiasm for process improvement and operational efficiency • Highly motivated with a ’can-do’ attitude • Organised and detail-focused, process oriented approach • Ability to work well under pressure and to tight deadlines, prioritising accordingly 

SSIS Skill Expectations: • Ask the right questions • Import data sources by building Connection Managers • Basic transformations; o add columns o cast variables o filter, sort aggregate o lookups • Deal with complexity • Work is control flow, not just data flow, e.g. looping • Script tasks in C# • T-SQL commands • Parallelism • Optimisation & efficiency of data management • Framework design • Auditing 

SQLSkill Expectations: • Data Manipulation Language (DML) o select o update o insert • Data Definition Language (DDL) o create o drop • Review and assign data types • Intermediate Indexing • Partitioning • Stored procedures (SPROCs) • Basic security • SQL Server Agent – scheduling / automation • Advanced understanding of all previous topics

SSAS Skill Expectations: • Basic understanding of theory / concepts • Cube creation o dimensions o data sources (DWH) o MDX query scripting o attribute hierarchies o security permissions • Use of DMX for data mining • Distribution of components 

SSRS Skill Expectations: • Basic understanding of theory / concepts • Report production • Building an SSRS server 

The application deadline for this job has passed. Please click here to return to the jobs list.