Senior Data Engineer (Data Architecture)

Wpromote · New York

Data & AIData Strategy and AnalyticsRemoteFull Timeposted 12d ago

The Role

As a Senior Data Engineer (Data Architecture), you will help design, build, and evolve the data infrastructure powering Polaris, Wpromote’s proprietary technology platform. You will work across Product, Data Engineering, and client teams to build reliable data solutions while helping us move from primarily client-specific implementations toward standardized, reusable, and scalable data capabilities.

This role will spend approximately 50–75% of its time supporting shared data products, platform capabilities, and data architecture, with the remaining time focused on individual client pipelines and solutions.

As our platform grows, we need to identify where common client requirements can become shared capabilities - particularly across strategic verticals such as Retail Media, B2B, and other emerging areas of the business. You will initially own components and technical designs within our broader architecture, with the opportunity to take increasing ownership of shared architectural patterns and data products.

A major focus of this role will be strengthening our engineering foundations around data quality, standardization, testing, observability, and maintainability.

At Wpromote, we believe that great work is only possible with great people. Our goal is to build a better, more inclusive work environment and support our people at every stage of their careers by prioritizing a strong work-life balance through our policies and benefits listed below. As a Best Place to Work according to both Ad Age and Glassdoor and Adweek’s Fastest Growing Digital Agency, we are moving fast to expand our teams and bring new experts into the fold to keep pushing the boundaries of what’s possible in marketing.

We offer:

-Remote-first culture

-Unlimited PTO

-Extended Holiday break (Winter)

-Flexible schedules

-100% paid parental leave

-401(k) matching

-Medical, Dental, Vision, Life, Pet Insurance

-Sponsored life insurance

-Short Term Disability insurance and additional voluntary insurance

-Annual Class Pass credits and more!

The anticipated annual salary for this role will range from $105,000-$135,000, based on consideration of a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, education and certifications, competitive benchmarks, scope of responsibility, market dynamics, geographic location, and respective state’s salary threshold for exempt employees. The total compensation package for this role will include benefits (listed above).

*This position may be performed remotely in most states within the US, with some exclusions

**While this role offers the flexibility to work remotely, we have office hubs in Los Angeles, Chicago, and New York, where you can join in on learning and development opportunities, fun events, take advantage of a space to work, and collaborate in person!

***This position is not eligible for immigration sponsorship

Important Notice: Beware of Job Scams

Wpromote recruiting communications will only be sent through our official channels via wpromote.com email addresses. If you see a posting elsewhere that is not reflected on Wpromote.com/careers, it may be a fraudulent posting. We do not require payment or fees during the hiring process nor do we request sensitive information, such as Social Security numbers or payment details. Please safeguard yourself against possible scams and contact us if you encounter any suspicious activity.

#LI-JJ

#LI-Remote

You Will Be

Designing, building, deploying, and maintaining scalable data pipelines and shared data products using BigQuery, dbt, Python, and orchestration frameworks.

Partnering with Product, Engineering, and client teams to translate business requirements into reliable and scalable technical solutions.

Identifying recurring patterns across client implementations and turning them into reusable models, frameworks, and shared capabilities, including solutions for verticals such as Retail Media and B2B.

Developing reusable dbt models, macros, Python utilities, ingestion patterns, and configuration-driven solutions that balance standardization with client-specific flexibility.

Strengthening data quality and reliability through automated testing, validation, reconciliation, monitoring, and observability.

Improving existing pipelines and architecture for greater scalability, maintainability, performance, and cost efficiency.

Integrating and normalizing data from APIs and third-party platforms across the MarTech and AdTech ecosystem.

Managing production data pipelines across Wpromote’s client portfolio, troubleshooting complex issues, and identifying systemic improvements that prevent recurrence.

Contributing to technical design, architecture discussions, code reviews, and engineering standards while providing technical guidance to other Data Engineers.

Using AI-assisted development tools to accelerate development, codebase exploration, debugging, testing, documentation, and code review while maintaining accountability for production code and sharing effective practices with the broader team.

You Must Have

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.

5+ years of experience in data engineering, analytics engineering, data architecture, or a related field.

Demonstrated experience independently designing and delivering production data pipelines and data models.

Advanced proficiency in SQL and BigQuery, with strong knowledge of relational and analytical database concepts.

Intermediate to advanced programming skills in Python.

Strong experience with dbt, including data modeling, testing, documentation, and reusable development patterns.

Strong understanding of data warehousing, dimensional modeling, data transformation, and data quality principles.

Experience improving or refactoring data systems for greater reusability, reliability, and scalability.

Familiarity with orchestration technologies such as Airflow, Dagster, AWS Glue, or Azure Data Factory, along with modern software engineering practices including Git, code review, CI/CD, and testing.

Strong problem-solving and communication skills, including the ability to navigate ambiguous requirements, evaluate technical tradeoffs, and communicate decisions to technical and non-technical stakeholders.

Strong business and marketing acumen, including familiarity with common marketing goals, KPIs, channels, and tactics.

Hands-on experience using AI-assisted software engineering tools such as Claude Code, OpenAI Codex, OpenCode, Cursor, GitHub Copilot, or similar tools, with the engineering judgment to review, test, and validate AI-generated solutions.

Experience within an advertising agency, consulting organization, or other multi-client environment, including mentoring or providing technical guidance to other engineers.

Nice To Have

Experience building reusable, configuration-driven, or multi-client data pipelines and consolidating bespoke implementations into shared solutions.

Experience with data observability, lineage, metadata management, or data quality platforms.

Experience creating and consuming APIs to ingest and process large datasets.

Experience with Retail Media, B2B, ecommerce, CRM, or other specialized marketing data.

Experience working with digital media and analytics platforms such as Google Ads, Meta, The Trade Desk, Amazon Ads, Google Analytics, or Adobe Analytics.

Experience developing agentic software engineering workflows or helping establish AI-assisted development practices and guardrails within an engineering team.

What Success Looks Like

Success in this role will center around three areas:

Delivery: You will become a trusted owner of complex data pipelines and shared components, independently delivering reliable, maintainable solutions while effectively supporting both product and client needs.

Standardization: You will strengthen our engineering foundations through improved data quality, testing, observability, documentation, and reusable development patterns, helping establish consistent standards for how data solutions are built across the organization.

Architecture: You will identify patterns across client implementations and help evolve them into shared data products, frameworks, and vertical-specific capabilities, taking increasing ownership of architectural decisions as you grow in the role.

Wpromote is committed to bringing together individuals from different backgrounds and perspectives, providing employees with a safe and welcoming environment free of discrimination and harassment. We strive to create a diverse & inclusive environment where everyone can thrive, feel a sense of belonging, and do impactful work together. As an equal opportunity employer, we prohibit any unlawful discrimination against a job applicant on the basis of their race, color, religion, gender, gender identity, gender expression, sexual orientation, national origin, family or parental status, disability*, age, veteran status, or any other status protected by the laws or regulations in the locations where we operate. We respect the laws enforced by the EEOC and are dedicated to going above and beyond in fostering diversity across our workplace.

Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Wpromote.

This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E Verify, or if you believe that your employer has violated its E-Verify responsibilities, please contact DHS.