The Data Engineer in the Marketing Department will design, implement, and manage data infrastructure and modern data pipelines to support the marketing operations and analytics needs. This role will focus on ensuring the smooth flow of data from various sources into centralized platforms, providing the necessary data for audience segmentation, campaign execution, reporting, application development, and customer app tools. The Data Engineer will work closely with cross- functional teams to ensure data is accurate, reliable, and accessible for marketing initiatives, utilizing a wide range of technologies including Microsoft Azure, Azure Databricks, common application caching tools, SQL, data pipeline tools, and CDP tools like Hightouch.
Reports to: Director of Digital Strategy
Job Status: Exempt
Job Role and Responsibilities:
- Design, develop, and maintain data pipelines using modern ETL/ELT tools to integrate data from multiple sources such as CRM systems, marketing platforms, and other third-party data sources.
- Build and optimize scalable data infrastructure, ensuring that data is stored, processed, and delivered efficiently to meet marketing and business requirements.
- Work within Azure Databricks to build scalable, high-performance data models and workflows that support marketing insights.
- Implement CDP (Customer Data Platform) activation tools like Hightouch to enable data activation and seamless integration across various marketing platforms.
- Develop and manage application caches to ensure faster data access for marketing tools and ensure data consistency across systems.
- Design and implement data models that support audience segmentation, targeting, personalized marketing strategies, and customer app tools.
- Perform data transformation and cleaning to ensure high-quality, accurate data is available for marketing analytics, dashboards, and reporting.
- Develop and maintain modern ETL/ELT pipelines, integrating data across multiple systems, such as CRM platforms, marketing analytics, and third-party tools.
- Collaborate with marketing and analytics teams to understand data requirements and provide actionable data insights for campaign optimization and reporting.
- Monitor, optimize, and troubleshoot data pipeline performance to ensure reliable and timely data delivery for marketing operations.