Apply on Employer Site

Hearts & Science · 3 hours ago

Associate Director, Data Engineering and Operations

New York, NY

Full-time

Hybrid

Lead/Staff, Director/Executive

$70K/yr - $125K/yr

5+ years exp

Hearts & Science is a data-driven marketing agency focused on personalized digital marketing. The Associate Director of Data Engineering and Operations will lead the development and optimization of ETL jobs and data warehouse solutions while mentoring team members and collaborating with various stakeholders on data solutions.

Marketing & Advertising

H1B Sponsor Likely

Hiring Manager

Cristian Campozano

Responsibilities

Contribute to the growth of the enterprise data warehouse (EDW) by working alongside stakeholders to produce accurate information within database objects used in reporting, strategic planning and decision making

Assist the Senior Director in developing long-term strategies and capacity planning for meeting future data warehouse and data automation needs

Meet with end-users and data SMEs to clarify requirements and business rules needed to design, develop and implement ETL/ELT processes

Collaborate with peer Data Engineers to build upon and support our CI/CD pipelines hosted within our extensive GIT repository

Mentor our emerging Data Analysts, including providing feedback and suggestions for their planned workflows prior to deployment into production

Respond, investigate and correct reported data inaccuracies within the EDW compared to source and business-expected results

Establish relationships with external and internal POCs to ensure seamless inbound and outbound Data Delivery expectations are met

Implement and support backend maintenance processes that enforce ongoing data optimization and corporate retention policies while ensuring the historical data needs of the client are met

Document and maintain all the processes and procedures pertaining to ETL and data warehouse usage/development, contributing to the team knowledgebase when applicable

Qualification

Data pipeline designAWS CloudSQLPythonBig Data TechnologiesETLData visualizationProject ManagementCross-functional teamworkCommunication skillsTime management

Required

Bachelor's in Computer Science or similar technical degree within a STEM field

5+ years of hands-on experience in building data pipelines using traditional ETL tech stack, platform APIs and big data technologies

5+ years of experience in programming languages including as Python and working within a Linux based environment

Experience designing, deploying and supporting production cloud services in AWS ecosystem including EC2, S3 and Redshift

Can speak to concepts and designs/benefits to multiple audiences as well as interpret high level business requirements from conversation

Able to work within a cross-functional team environment with people from multiple business units, vendors, countries, and cultures

Working experience within the advertising/media industry with knowledge of basic media math

Preferred

Experience in Social Media Datasets such as Twitter, Facebook, Instagram is a plus

Experience in Google Campaign Manager, Xandr, or Adobe Analytics datasets is a plus

Experience with Google Cloud products is a plus

Experience with Microsoft PowerAutomate is a plus

Experience using Project Management tools such as Jira is a plus

Experience creating data visualizations and using tools such as Tableau is a plus

Benefits

Health insurance

Vision insurance

Dental insurance

401(k)

Healthcare Flexible Spending Account

Dependent Care Flexible Spending Account

Vacation days

Sick days

Personal days

Paid parental leave

Paid medical leave

STD/LTD insurance benefits

Company

Hearts & Science

Glassdoor3.5

Hearts & Science, an Omnicom Media Group agency, transforms data signals into meaningful connections between brands and consumers that drive exponential growth.

Founded in 2016

New York, NY, US

1001-5000 employees

http://www.hearts-science.com

H1B Sponsorship

Hearts & Science 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 (10)

2024 (13)

2023 (2)

2022 (9)

2021 (2)

2020 (4)