Marketing Data Engineer/Analytics Engineer

Summary

Join Automattic's Growth Infra team as a Marketing Data Engineer and contribute to building an internal marketing automation platform. You will design, develop, and maintain ETL pipelines, ensuring data quality and building scalable data architecture. This role blends data engineering and analytics engineering, requiring collaboration with various stakeholders. You'll have the opportunity to work on innovative projects and directly impact marketing efficiency. The position offers a fully remote work environment and a competitive salary.

Requirements

• Proven experience designing and maintaining ETL pipelines using tools such as Meltano, Fivetran, Airflow, or similar
• Strong proficiency in SQL, including advanced concepts like window functions and CTEs (Common Table Expressions)
• Experience with data validation, testing, and ensuring high data quality in complex workflows
• Solid understanding of data architecture principles, including building scalable and efficient models for marketing and analytics
• Familiarity with marketing data and segments, including CRM, attribution, and campaign performance metrics
• Strong programming skills in Python or a similar language commonly used in data engineering
• Excellent problem-solving skills and a proactive approach to identifying and resolving pipeline issues
• Exceptional communication skills to explain technical concepts to both technical and non-technical stakeholders
• A commitment to documenting processes and promoting best practices for maintainable data infrastructure

Responsibilities

• Design, develop, and maintain ETL (extract, transform, and load) pipelines
• Build and manage scalable ETL pipelines and data integration processes using tools like Meltano, Fivetran, or custom-built solutions
• Implement robust data validation checks and mechanisms to ensure the integrity, quality, and reliability of marketing data
• Architect and develop data models to support marketing segmentation, personalization, and automation
• Partner with stakeholders, including marketers, analysts, and engineers, to gather requirements, define solutions, and deliver reusable data models for marketing campaigns
• Monitor, troubleshoot, and optimize ETL pipelines to ensure efficiency and reliability over time
• Contribute to the design and implementation of data architecture supporting the internal marketing automation platform
• Ensure all solutions adhere to security, privacy, and compliance standards
• Participate in code reviews, documentation efforts, and knowledge-sharing activities to foster collaboration and continuous learning
• Identify opportunities to streamline processes, reduce technical debt, and promote best practices for data engineering
• Stay informed about emerging trends and technologies in data engineering and marketing automation

Benefits

Fully-remote company with an open vacation policy