*For this role it would be required to work from the London office at least 1x per week.
Overview
TeamITG is a leading technology company that specializes in delivering cutting-edge marketing and technological solutions to a diverse clientele worldwide. Our teams comprise of marketing automation specialists, consultants, front end/back end amp; data developers, client services professionals and campaign managers, as well as everything in between, who all working seamlessly to delivery award winning omni-channel campaigns on behalf of some of the most prestigious customers globally.
The role
We are in search of a dynamic and technically adept Marketing Technology Engineer to bolster our development team. As a Marketing Technology Engineer, your role will be integral within our CRM Cloud ETL Development team, tasked with the implementation and oversight of dynamic marketing technology solutions for our esteemed clients. This position offers a unique chance to collaborate with top-tier brands spanning multiple industries, providing invaluable hands-on exposure to the dynamic realm of marketing technology. Join us at the forefront of innovation and make your mark in this rapidly evolving field.
In addition to leveraging your expertise in SQL-based tasks, this role offers an exciting avenue for growth into cloud computing, cloud ETL, and associated services provided by industry leaders like Google Cloud Platform (GCP) and Amazon Web Services (AWS). Moreover, you'll delve into our extensive data repositories utilizing tools such as Python and Apache Airflow.
As a vital member of our team, you'll collaborate closely with Technical Consultants and fellow team members to grasp client needs, devise technical solutions, and ensure seamless implementation and operation of marketing technology platforms and systems. Join us in shaping the future of marketing technology!
Requirements
Main Duties and Responsibilities
Craft robust SQL scripts, queries, views, and stored procedures to efficiently manipulate and retrieve data from diverse sources.
Create bespoke scripts and applications with Python to streamline marketing operations and ETL processes, facilitate system integration, and enhance marketing analytics capabilities.
Design, develop, and rigorously test ETL processes, predominantly cloud-based, to seamlessly extract, transform, and load data into target systems.
Manage the implementation of marketing technology solutions, including configuring and customizing marketing technology platforms to support targeted marketing initiatives and ensuring seamless integration with other systems.
Develop and refine database structures to ensure streamlined data storage, retrieval, and manipulation for optimal efficiency.
Leverage cloud computing technologies (e.g., Google Cloud Platform, Amazon Web Services) to enhance data integration capabilities and optimize system performance.
Engage with stakeholders across departments to comprehend data requirements thoroughly and devise optimal solutions to address business needs effectively.
Ensure the integrity, accuracy, and consistency of data through meticulous testing and validation procedures.
Enhance the performance, scalability, and reliability of ETL processes through continuous optimization efforts.
Implement robust monitoring and error-handling mechanisms to ensure the smooth execution of ETL jobs and promptly address any anomalies.
Troubleshoot and resolve data integration and ETL process-related issues in a timely and efficient manner to minimize disruptions.
Thoroughly document processes according to company standards, encompassing technical specifications, data mappings, and workflow diagrams, and maintain all work in a designated source control repository.
Provide ongoing support for implemented processes post-go-live and proactively implement enhancements to optimize performance and functionality.
Stay abreast of industry best practices and emerging trends in cloud data integration to inform decision-making and drive continuous improvement.
Participate in research and development initia