Data Engineer (Marketing Analytics)

New York Technology Partners · New york city metropolitan area, United States

We are seeking an experienced Analytics Engineer (Data Engineer) to support an internal marketing and data analytics team. This individual will work alongside an established Data Engineer to design, build, and maintain scalable data pipelines, integrate data from various marketing and enterprise platforms, and develop reliable datasets for analytics and reporting.

The ideal candidate will have extensive hands-on experience working with marketing data and marketing technology ecosystems, strong Python and SQL skills, experience with modern cloud data platforms, and a solid understanding of Salesforce data structures and integrations.

Key Responsibilities

• Design, build, and maintain scalable data pipelines that ingest and integrate data from marketing platforms, Salesforce, APIs, and other enterprise systems.
• Develop and optimize data transformations and models to support marketing analytics, reporting, dashboards, and advanced analytics.
• Build and maintain API-based integrations and custom Python solutions for automated data ingestion.
• Extract, transform, and integrate Salesforce CRM data into cloud data platforms.
• Integrate data across marketing technology platforms, including CRM, campaign management, digital marketing, media, and customer data systems.
• Ensure data quality, accuracy, and reliability through validation, testing, monitoring, and troubleshooting.
• Collaborate with marketing and analytics stakeholders to understand data requirements and deliver actionable datasets.
• Create and maintain technical documentation, metadata, data definitions, and data lineage.
• Support the development of AI-ready datasets and leverage modern AI tools to improve engineering workflows.

Required Qualifications

• 5+ years of experience in Data Engineering, Analytics Engineering, or a similar data-focused engineering role.
• Extensive hands-on experience working with marketing data and marketing analytics, including integrating data from marketing platforms, campaign systems, CRM platforms, or customer data sources.
• Strong proficiency in Python and SQL, including developing and maintaining production-grade data pipelines.
• Hands-on experience with at least one of the following: Databricks, Google BigQuery, or Snowflake.
• Required Salesforce experience, including working with Salesforce data, understanding CRM data structures, and integrating Salesforce with other platforms.
• Experience building and maintaining REST API integrations, including authentication, pagination, error handling, and monitoring.
• Strong understanding of data modeling, data warehousing, ETL/ELT processes, and data pipeline architecture.
• Experience developing datasets for downstream analytics, dashboarding, reporting, and analytical modeling.
• Experience implementing data quality checks, validation, testing, and troubleshooting production data pipelines.
• Experience creating technical documentation, metadata, and data definitions.
• Familiarity with modern AI tools for engineering, debugging, testing, and documentation.