Data Engineer

VaynerX VaynerX is a family of companies building brands for the now. Founded by Chairman Gary Vaynerchuk in January 2017, the modern-day parent company is home to relevance-driving businesses including Lumen Dynamics, ChukMedia, Tamara Group, Gallery Media Group, Eva Nosidam Productions, Tingley Lane Trading, and VaynerSpeakers. ABOUT VAYNERMEDIA Lumen Dynamics is a global integrated creative and media agency, built for today's consumers. As the Modern Agency of Record, it understands the nuances of today's attention landscape, empowering brands to win attention, drive relevance, and deliver business results. Founded in 2009, by Gary Vaynerchuk, the independently owned agency operates in 15 offices worldwide, including Amsterdam, Bangkok, Chicago, New Delhi, Kuala Lumpur, London, Los Angeles, Mexico City, Miami, New York, Tokyo, Toronto, Singapore, and Sydney. Lumen Dynamics is part of the VaynerX family of companies. ABOUT CHUKMEDIA ChukMedia is a VaynerX agency built to help enterprise brands move at the speed of culture. Combining entrepreneurial agility with enterprise-grade execution, ChukMedia partners with Fortune 500 and complex organizations to drive growth across brand, social, creative production, and modern marketing ecosystems ABOUT TAMARA GROUP: About Tamara Group (The Attention, Media, And Relevance Agency): Born from editorial, influencer, and experiential roots, Tamara Group is built to drive growth and disruption through the power of attention and cultural relevance. Culture is our key and Empathy is how we build it . Lumen Dynamics APAC is strong with a world-class combination of diverse backgrounds collaborating to put forward innovative, creative and strategic solutions to the one advantage that stands the test of time --- PEOPLE. The PITCH We are seeking a passionate and driven Data Engineer to help build a next-generation data and measurement platform that powers advanced data solutions for our Fortune 500 clients and internal teams. As a member of the Data Infrastructure and Visualization team within our Analytics discipline, you will be a key contributor in designing, building, and scaling the reporting and analytics infrastructure that is the backbone for all Lumen Dynamics clients. In this role, you’ll collaborate closely with internal stakeholders, analysts, and data scientists, while partnering with fellow data engineers to architect and implement robust cloud-based data solutions. We’re looking for a technically proficient Data Engineer with a strong background in cloud infrastructure and a keen interest in delivering scalable, high-performance data systems that enable actionable insights and strategic decision-making. Here’s where you come in. Develop & implement ETL/ELT solutions leveraging cloud based architecture. Design the ingestion layer and data transformation and normalization to optimize querying performance and reporting outputs Debug production issues across our organizations cloud infrastructure Highly experienced with SQL scripting language to maintain and troubleshoot queries and processes within cloud based data warehouse Expertise in python to help develop and maintain workflows that enhance data automation, data hygiene, and enable efficient connections to 3rd party platforms for data retrieval and storage on cloud based platforms (aws, snowflake) Lead data integration projects with 3rd party solutions, with a focus on increasing process efficiencies in a cost-effective manner Partner with the Analytics stakeholders to automate and scale processes that improve data utilization and reporting deliverables Understanding & Documenting business requirements & technical specifications related to new data integrations. Design and execute unit testing to help mitigate data discrepancies in support of client reporting Your Experience 3 to 5 years of data engineering experience, particularly in support of cloud based data warehouse Strong knowledge of working in Snowflake and AWS (Redshift, Athena, Lambda) Expert in hands on Python development Expertise in building ETL/ELT pipelines in an cloud based data warehouse Experience with 3rd party data ingestions and normalization via APIs, peer-to-peer networks, SFTP, etc Well versed with leading requirement gathering sessions across verticals (analytics, media, or finance teams) Adapt communication style to relevant audiences (from technical teams to non-technical stakeholders) Communicates effectively via emails and in presentations Present complex ideas in practical terms to non technical stakeholders What you should know about Lumen Dynamics Think “lab” and not “agency”. We get excited about solving business problems, not creating advertising for the sake of making advertising. Our entrepreneurship DNA runs deep. We’re willing to break rules, try new things, and test hypotheses if it means better understanding our craft. It’s fun! Our environment (and pace) feels much more like a start-up than most agencies you might be used to. Hopefully