Data Engineer

VaynerX (https://vaynerx.com) is the most contemporary family of companies, working together to build and grow brands. Subsidiaries include VaynerMedia, Eva Nosidam Productions, The Sasha Group, Gallery Media Group, Tingley Lane Trading, VaynerSpeakers, and VaynerCommerce.

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 VaynerMedia 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.

• 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

• 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

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 that, and the opportunity to collaborate with the talented and enthusiastic crew, work with big brands excites you, as it does us. We can’t wait to meet you.