Manager, Data Engineering (CPG Client)

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

Overview

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.

Responsibilities

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 leveraging 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 utilizing 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 expertise in ETL, API development, and Business Intelligence platforms

Clearly define project deliverables, timelines, and dependencies for junior team members, internal stakeholders and clients

Collaborate on an inclusive team, where members openly communicate and collectively problem-solve

Strong ability to evaluate new technologies and present findings to team

Contribute to knowledge sharing efforts and mentorships

Complete other duties as assigned.

Qualifications

Bachelor’s degree or combination of education, and equivalent work experience is preferred in the field of computer science, management information systems or Information Technology

3 years’ related experience ETL development and business intelligence platform management

Understanding of BI / ETL development in the IT industry with recent development, system administration, application tuning and debugging experience.

3 plus years’ development experience with database engines including Presto, Mongo db and Hadoop.

3 years’ experience in ETL development, Strong Database (Modeling, SQL), SQL Server, Hadoop, AWS Redshift, Qubole.

Experience managing team of 2 or more associates / analysts preferred

Strong database modeling and SQL skills. Ability to write complex SQL statement, Procedures and data automation programs

Knowledge of ETL tools like Airflow, AWS Glue, Alteryx, SSIS, Qubole / Spark is a must

Knowledge of Python or similar programming languages required

Proficiency with Datorama, Tableau, or other data visualization tools is preferred

Experience working with AWS or other cloud technologies

Advanced user Microsoft Office Suite and reporting tools

Demonstrated expertise in core MS Excel functions (vlookup, pivot tables, data visualization)

Experience in designing jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification.

Strong analytical and problem-solving skills

Strong verbal / written communication and interpersonal skills is required

Self-starter with ability to thrive in a fast-paced environment and able to function independently while providing status updates to a team of analysts

Cooperative, flexible, conscientious, dependable, resourceful, self-motivated, and team-oriented

Problem solving, time management, and critical thinking skills with a professional and positive attitude

Ability to work independently and as part of an agile team, participating in daily stand-ups, sprint planning and sprint review

Character :

The following qualities help drive success as member of the Spark Data and Analytics team :

Entrepreneurial, engaging, resourceful, curious, and self-directed spirit

Willing and easily roll sleeves up or down; love the nitty-gritty and the strategy

Collaborative approach to building cohesive, strong teams

Loving and living the intersections between brands, people, media, communications

Relentlessly passionate and resolute

Planning and time management excellence.

Embrace challenges

Proactive, especially in pushing for new opportunities, approaches, and ideas.

Keenly focused on action and solutions; thrives with deep critical thinking and analysis.

Pioneering insight attitude and research in-the-know.

Resourcefulness, flexibility and adaptability, strong ability to pivot when the need arises.

Inspired to be part of the insight journey / revolution with a growing, dedicated team

Additional information

Our Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off. If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com .

Compensation Range : $87,210 - $125,265 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer / temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 03 / 24 / 2025.

All your information will be kept confidential according to EEO guidelines.

LI-EO1

25-2644

Salary : $87,210 - $125,265