Data Engineer

Surf Internet - Naperville, IL

Naperville, IL

Telecommunications

About the position

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.

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.

Requirements

• Bachelor's degree in Computer Science, Data Engineering, or a related field.
• Proven experience as a Data Engineer, with a focus on marketing data, ETL pipelines, and data activation.
• Expertise in Azure cloud platform and Azure Databricks for data storage, processing, and analytics.
• Strong proficiency in SQL for data extraction, transformation, and management.
• Hands-on experience with modern data pipeline tools such as Fivetran, dbt, or similar tools for building scalable ETL workflows.
• Experience with CDP activation tools like Hightouch, and integration with various marketing platforms (e.g., HubSpot, Google Ads, Facebook Ads, etc.).
• Proficiency in Python or other programming languages to build data workflows and automation.
• Experience with application caching systems to improve data access speed and ensure consistency across marketing tools.
• Strong knowledge of data governance, data quality, and best practices for managing large datasets.
• Ability to work collaboratively with cross-functional teams including marketing, data science, and product teams to deliver data-driven insights.
• Excellent problem-solving skills and ability to troubleshoot complex data issues.