Manager, Data Engineer; Media Agency

Company description

Spark Foundry is a global media agency that exists to bring HEAT – Higher Engagement, Affinity, and Transactions – to brands. By combining flawless media fundamentals with aggressive innovation, Spark inspires consumers to pay more attention, to care more about our clients’ brands, and to buy more products and services from them.

Balancing the nimble spirit of a startup with the powerhouse soul of Publicis Media, Spark Foundry delivers the best of both worlds to a client roster that spans some of the world’s best and most beloved brands and companies. We combine boutique-caliber insights and service with the buying clout and first-look access of a global leader, bringing the heat to challenger brands that want to act like giants, and to giant brands that want to act like challengers.

With a bottom‑up culture that celebrates diversity and aims for all voices to be heard, Spark has become a magnet for the industry’s best talent, with one of the best retention rates in the industry. And by applying a whole‑person approach to professional and personal development, Spark develops a workforce that is well prepared for today’s challenges, and also poised to create meaningful careers in the years to come.

Because we know that heat arises at the intersection of complementary forces, our professionals come from myriad disciplines and backgrounds: data, analytics, and insights; content and creative production; communications and strategy; finance and marketing; and sociology, psychology, and other liberal arts disciplines.

The Manager, Data Engineering & ETL Development is a key driver to build data platform leveraging best in class ETL practice and is also a strategic thinker and a talented data visualization expert with emphasis on dashboard reporting.
The primary responsibility will be developing business intelligence platform to support media and marketing data for our clients. This position will allow you to be a significant contributor as part of the team to support easy access of data and visualizations to fuel stronger insights and media optimizations.

This position requires strong technical and tactical skill sets with an eye for numbers, intellectual curiosity, proficiency at problem solving, and a critical understanding of online media. The candidate must have a proven track record in managing ETL’s, APIs and business intelligence platforms. Candidate should be a team player. A “roll up the sleeves” approach is mandatory and a “get it done” attitude is a must.

Specific responsibilities include coordination between the research, analytics & media teams ensuring high quality data projects are effectively delivered.

Successful candidates will be multi‑dimensional ‘rising‑stars’ who are able to employ complex problem solving skills, and are able to communicate these succinctly to a broad client and media stakeholder audience.

• Responsible for loading and validating data into the data warehouse from various source systems
• Analyze, develop, fix, test, review and deploy functionality, and bug fixes in ETL data pipelines
• Query tuning, diagnosis, and resolution of performance issues using ELT and push‑down if required
• Building Data mappings between Source to Target systems
• Provides support for technical issues and ensuring system availability
• Work with business customers to identify and develop additional data and reporting needs
• Understand how business intelligence platform/data technologies work and offer the ability to explain technical concepts in ordinary terms (be technically savvy – understand the opportunities and limitations)
• Establish and manage data integrations using a taxonomy nomenclature to make recommendations for data visualization to showcase media performance through the use of Datorama or Tableau
• Perform regular quality assurance/quality control checks on assigned client campaigns to ensure the data is processing accurately
• Design and build backend data streams and processes to automate reporting capability with data visualization tools
• Contribute to client status and reporting calls, including presentation of reporting as required
• Develop subject matter…