Data Engineer

What's up?

We're VaynerMedia!

We are a contemporary global creative and media agency with an expertise in driving relevance for clients and delivering impactful business results. The independently-owned agency was founded in 2009 and has offices in New York, Los Angeles, London, Singapore, Australia, Thailand, Japan and Mexico City. VaynerMedia has been recognized for its work at Cannes Lions, the Clio Awards and The Webby Awards. It is part of the VaynerX family of companies.

Culture is our key and Empathy is how we build it

. VaynerMediaAPAC 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. Day in and day out, we propel some of the biggest brands in the world to the intersection of attention and culture. In APAC, we are proudly +200, servicing a diverse client all around the region.

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

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 VaynerMedia

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.