Apply on Employer Site

Spark Foundry · 2 weeks ago

Associate Director, Data Engineering (Media Agency)

New York, NY

Full-time

Hybrid

Senior Level, Lead/Staff

$111K/yr - $174K/yr

5+ years exp

Spark Foundry is a global media agency that aims to enhance engagement and transactions for brands through innovative media solutions. The Associate Director, Data Engineering will collaborate with a team to build enterprise-scale data solutions, focusing on customer data hubs and data warehouse solutions.

AdvertisingMarketing

H1B Sponsor Likely

Responsibilities

Deliver quality work on defined tasks with little oversight and direction

Ensure all deliverables are of high quality throughout the project by adhering to coding standards and best practices and participating in code reviews

Participate in integrated test sessions of components and subsystems on test and production servers

Serve as technical resource during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into data integration and database system designs

Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs

Use information gained through prior experience, knowledge sharing with other Technology Associates, education and training to resolve issues and remove project barriers

Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed

Qualification

Data engineeringData integrationData warehouse designData modelingSQL languagesETL ToolsCloud servicesProgramming languagesCode repositoriesSoft skills

Required

5-8 years in a data engineering role with demonstrable experience with data integration and data warehouse projects

Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business's operational and analytics databases

Works with the business's data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any issues

Defines and builds the data pipelines that will enable faster, better, data-informed decision-making within the business

Experience designing and building data warehouses, customer profile databases, data marts, etc

Experience with data modeling, warehouse design, and fact/dimension concepts

Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL)

Ability to work collaboratively in teams with other specialized individuals

Able to work in a fast-paced, technical environment

Good verbal and written communication skills

Preferred

Prefer some experience in at least one programming language (i.e. Python, Java, Scala, C#, etc.)

Prefer some experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.)

Experience in Amazon Redshift is a plus

Experience with marketing data (Google Double-Click, Site Analytics, Paid Search, etc.) is also a plus

Understanding and experience working with cloud platform services: Redshift, Aurora, Data Factory, SQL DW, Azure Datawarehouse, Data Lake, BigQuery, etc

Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)

Understanding of development and project methodologies

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)