Data Engineer

Summary

Join our team as a Data Engineer and contribute to building, maintaining, and optimizing our data infrastructure. You'll architect and manage resilient data systems, troubleshoot complex data issues, and continuously improve data processes.

Requirements

• 7+ years of expertise with SQL, particularly in Redshift and BigQuery, for querying, transforming, and managing large datasets, with additional experience in Python for data processing and automation
• Proficient with data visualization tools like Tableau, Looker, or Power BI to create dashboards that effectively communicate complex data to stakeholders
• Skilled in leveraging DBT (Data Build Tool) for data transformations, source control, and collaborative workflows, creating efficient, scalable data pipelines
• Strong knowledge of data pipeline automation and experience in maintaining ETL/ELT processes for high-volume, multi-source data environments
• Experience in establishing strong database architecture and implementing data governance practices to ensure data integrity, accessibility, and compliance
• Analytical and problem-solving skills with the ability to interpret and synthesize data into actionable insights for both technical and non-technical audiences
• Understanding of statistical analysis, predictive modeling, and machine learning, with the ability to apply these techniques to support advanced insights and forecasting

Responsibilities

• Develop, maintain, and optimize data pipelines and ETL/ELT processes using Redshift, BigQuery, and other data systems to support digital marketing and operational reporting needs
• Design and manage data architectures that ensure efficient cross-channel integration, enabling a comprehensive view of marketing and digital performance
• Utilize APIs, data connectors, and automation tools to facilitate the ingestion, transformation, and reliable flow of data across sources such as websites, social media, email campaigns, and advertising platforms
• Build and maintain robust data models to improve reporting accuracy and empower decision-making across business units, especially in digital and marketing analytics
• Collaborate with cross-functional teams to develop and sustain analytical frameworks that align data structures with evolving business needs
• Clean, preprocess, and transform raw data to ensure consistency and integrity, effectively handling missing values, anomalies, and inconsistencies
• Actively monitor and troubleshoot data pipelines, ensuring high data quality, reducing disruptions, and responding quickly to any issues
• Conduct exploratory data analysis (EDA) to uncover trends and patterns, enabling actionable insights and enhancing understanding of campaign performance
• Support campaign optimization by creating predictive models, forecasting trends, and analyzing customer behavior using statistical and machine learning techniques where applicable
• Design and build interactive dashboards and reports in Tableau, Looker, or other visualization tools to deliver real-time insights to stakeholders, ensuring metrics are both clear and actionable