Description
Role - Data ArchitectContract - 6 Month (Rolling)
Location - Central London
My Client is looking for a talented and very capable Data Architect to work closely with various departments working to architect, build and support various data solutions. In conjunction with these requirements, the role will require the candidate to provide team leadership to the in-house data team, mentoring and support to development teams around best practices and database architecture.
The position will involve using various flavours of databases as well as using cloud based technologies. It is expected that duties will include Microsoft SQL Server 2012 Enterprise, MySQL, NoSQL database performance and capacity planning, troubleshoot database issues, maintain database system availability and scalability as well as develop and optimize database design for new applications. Work closely with the development and online content teams to identify on going; Improvements in tools, processes, procedures, installation, configuration and troubleshooting techniques.
KEY RESPONSIBILITIES
Lead the in-house Data Team (2 permanent, 1 contract) Create/Support the data architecture to ensure business objectives can be met
Plan, design, & architect enterprise databases both on-premise and in Amazon (AWS)
Develop and troubleshoot Microsoft SQL Server 2012/ Analysis Services 2012 (Multidimensional and Tabular), MySQL, NoSQL
Develop Data Integration solutions to ensure unity and integration of various data sources using Microsoft Integration Services 2012.
Analyse and tune databases for optimal efficiency and performance requirements
Work alongside the senior technical team to define strategy
Work very closely with various teams to ensure database architectures, standards, security are maintained
ESSENTIAL SKILLS & EXPERIENCE
Technical
Extensive knowledge in architecting on premise and cloud based data services.Extensive knowledge designing, maintaining, tuning MS SQL Server 2012 & MySQL databases.
Knowledge of the Microsoft SQL Server 2012 BI stack including SSIS/SSAS
Solid understanding enterprise database architecture / massively scalable design
Appreciation of Data Warehousing methods including Kimball Methodology
Proven ability to learn and deploy new systems quickly and reliably
SQL Server, maintenance and installation
Non-technicalTeam Leadership and task delegation
Excellent communication skills are essential to work with other teams and the business
Desire to use latest, emerging technologies
Able to work independently without supervision - ability to prioritise tasks and work pro-actively
Good technical documentation skills
Able to work in a team environment.
Enthusiastic with a willingness to learn quickly, ability to adapt to change quickly and effectively