About Adstream
Adstream provides a Connectivity Suite for the ad industry, combining collaboration tools, digital asset management, a global distribution network and powerful analytics to provide smarter, more collaborative advertising workflowsbringing the marketing and production processes together from idea to delivery for greater visibility, productivity, insight and performance.
Brands, agencies, production and post-production teams use Adstream to create great content together, manage their assets and leverage its world-class network of over 79,000 media destinations in 141 countries, to share their message with the world.
Today over 100,000 businesses use Adstream to reach billions of customers globally. We’re a fast-moving team of passionate subject-matter experts located across 37 offices, speaking 45 languages, and on a mission to connect the world’s media.
About Adstream Technology
Adstream operates a mid-sized software development team based in London. The team are responsible for the development of a Digital Asset Management system (the Adstream Platform) and supporting products to its clients primarily for use in the Marketing and Advertising industry; from internationally recognised Brands to Creative and Media Agencies and Postproduction Houses. Clients are using the AP to project manage, organise, share, approve and store creative materials across all media types.
The Adstream platform, Send+, XMG and the Print Suite are critical to the future of Adstream and are fundamental to providing a cross-media management and delivery platform. A key selling feature is the flexibility and customisation capability of the platform which means it can be implemented to meet dramatically varying client requirements and workflows.
In order to support the ongoing and intense development expectations of the Adstream solutions, there is a team of approx. 70 people working as software developers, quality assurance engineers and other supporting roles.
Your Responsibilities
We are looking for a motivated & results driven Data Engineer to join our Reporting & Analytics Development Team.
You will interact with a variety of internal databases and external client and 3rd-party data via JSON RESTful API’s, in which to deliver reporting and analytical solutions for both new and existing projects including, but not limited to, data warehouse solution development, data warehouse performance optimization, The Adstream Platform analytics product development, internal product reporting, and exciting upcoming projects in Machine Learning.
You will strive to achieve maximum success within your team, and work together and improve as a unit.
You would be reporting in to the Senior Data Engineer who would mentor the you to grow your skills.
In return, we will provide you with a competitive salary, in a friendly, sociable atmosphere. We will grant you opportunities for training and conferences, allowing you to grow your skill-set and make you a better-rounded developer. We recognise good talent and know how to harness it.
This is a magnificent opportunityto join a market leader, during an exciting period of its growth.
Duties
Develop and maintain ETL processes that feed from various data sources (SQL’s, Mongo’s, APIs etc.)
Optimize performance bottlenecks and refactor/improve code
Create data-marts, reports and dashboards.
Research and prototype new analytical big data technologies
Support team in new Machine Learning projects
Skills & Experience Needed
Data Warehousing design principles and best practices
Data analysis and profiling skills
Extensive experience troubleshooting and solving data processing issues
Extensive experience writing and optimizing T-SQL queries/procedures
DESIRABLE SKILLS
Any of the below would be advantageous but is not essential as training will be given.
Experience in Java
Experience with Nodejs / Express
Experience of the JavaScript language (ES6 +)
Experience with No-SQL technologies
Experience with HTML5 and CSS3
