Database/Datawarehouse Engineer

Data & Analytics London, England


Position at MediaCom

The Role Objective

• Help deliver end to end solutions for managing, storing and surfacing data to reduce the time to insight for our clients and drive internal efficiencies
• Maximise benefits of the SQL environment for MediaCom specific data
• Provide data expertise to support our consulting offering
Essential Skills, Knowledge and Experience

The Ideal Candidate
• Analytical and an excellent problem solver with the ability to work under own initiative
• Proactive at identifying problems and proposing solutions and improvements
• Solution focused with a flexible attitude
• Have an interest in keeping up to date with the latest database technologies
Essential Skillset
• Knowledge of Business Intelligence and Data Warehousing theory and best practices
• Data analysis and profiling skills
• Ability to trouble-shoot complex data processing issues
• Proven experience working with MS SQL Server (2012 or higher)
• Ability to write and optimise T- SQL to a high standard
• Experience of developing solutions using Visual Studio Development Environment
• Experience with Microsoft ALM
• Knowledge of Microsoft Technology stack SQL, .NET, Azure

Desirable Skills
• Knowledge of media agency offering and business model
• Proficiency in C#
• Working experience of Azure Storage, Compute & Data Services
• Working experience of SSAS
• Working experience of Tableau, Microsoft PowerBI
• Ability to design and deliver attractive and insightful data visualisations
• Experience/appreciation No SQL technologies
Personal specification
• Excellent communication (written and verbal) and interpersonal skills
• Enthusiastic to learn and develop new skills
• Excellent analytical and problem solving skills
• Friendly and social demeanour

We are an equal opportunities employer. All GroupM agencies are equal opportunities employers and welcome applications from all suitably qualified persons regardless of their race, gender identity, disability, culture/religion/belief, sexual orientation or age.