We’re Part and Sum, a collective of curious people who help our clients bring new ideas to market and use data to grow businesses. Our strategy consulting work is powered by customer insights and our media agency work is designed to help us learn and drive continuous improvement. We have an impressive track record for a small-ish team - we work with the biggest brands in the world (alongside smaller brands, too) and we have ambitions to expand our influence over the next decade.

As a Data Analytics Engineer, you’ll perform visualizations, troubleshoot tagging issues, generate Mixpanel reports, handle tagging implementation, manage ETLs (Extract, Transform, Load), and work with APIs.

What you’ll do:

• Support clients’ data infrastructure which includes Looker, Funnel, GTM, Customer Data Platform, Data Warehouse
• Educate the organization on analytical approaches to drive business decisions
• Research, design, and implement best practices in managing data platforms
• Partner with strategy and growth marketing teams to build reusable data infrastructure, analytics, and dashboards
• Stay up-to-date on new analytics platforms, visualization platforms, etc.
• Provide technical guidance and POV on data analysis
• Communicate with clients and internal team members complex or technical concepts in a simple and understandable manner
• Automate, clean, and transform data in Excel/Google Sheets, Funnel, Looker, and/or BigQuery
• Perform data cleaning and modeling in Python/SQL/Funnel/Looker
• Create standardized visualizations to compare performance marketing KPIs
• Maintain and troubleshoot Looker Dashboards
• Analyze and interpret data from ad platforms, focusing on performance metrics and KPIs
• Implement, troubleshoot, and consult clients with tracking, conversion tagging and conversion API integration.

Who you are:

Must Haves

• You have a basic understanding of ad platforms, performance data, and KPIs
• You are proficient in Excel/Google Sheets, Funnel, and Looker