Apply on Employer Site

Spark Foundry · 2 weeks ago

Manager, Data Engineer (Media Agency)

New York, NY

Full-time

Onsite

Mid, Senior Level

$87K/yr - $137K/yr

3+ years exp

Spark Foundry is a global media agency focused on enhancing brand engagement through innovative media strategies. The Manager, Data Engineer role is pivotal in developing a business intelligence platform to support media and marketing data, ensuring effective data management and visualization for clients.

AdvertisingMarketing

H1B Sponsor Likely

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

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

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

Solid ability to evaluate new technologies and present findings to team

Contribute to knowledge sharing efforts and mentorships

Complete other duties as assigned

Qualification

ETL developmentBusiness Intelligence platformsDatabase managementSQL skillsData visualization toolsPythonCloud technologiesTeam managementAnalytical skillsProblem-solving skillsCommunication skillsTime management

Required

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

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

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

Preferred

Experience managing team of 2 or more associates/analysts preferred

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

Experience working with AWS or other cloud technologies

Benefits

Medical coverage

Dental

Vision

Disability

401K

Parental and family care leave

Family forming assistance

Tuition reimbursement

Flexible time off

Company

Spark Foundry

Glassdoor3.9

Spark Foundry is one of six global media agency brands within Publicis Media.

Founded in 2016

New York, New York, USA

1001-5000 employees

http://www.sparkfoundryww.com/

H1B Sponsorship

Spark Foundry has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (79)

2024 (30)

2023 (8)

2022 (3)

2021 (5)

2020 (3)