Data Analytics Engineer

Partandsum; New York, Los Angeles (NY, CA); Hybrid; USD 50,000 - 120,000; Full time

Job summary

Join a dynamic team as a Data Analytics Engineer where your skills will help clients leverage data for growth. In this role, you'll be responsible for creating visualizations, managing data infrastructures, and automating data processes. This innovative firm values creativity and autonomy, empowering you to make impactful decisions. You'll collaborate with strategy and marketing teams, ensuring that data drives business decisions while enjoying a supportive environment that promotes personal and professional development. If you're passionate about data and eager to contribute to exciting projects, this opportunity is perfect for you.

Benefits

Competitive Base Salary

Health Benefits

401k with Match

Flexible WFH Policy

Responsible PTO Policy

Paid Family Leave

Home Office Stipend

Professional Development Budget

Company Retreats

Sabbaticals

Qualifications

• Proficient in data visualization and cleaning using tools like Looker and Funnel.
• Strong communication skills to convey complex data insights simply.

Responsibilities

• Support clients' data infrastructure and educate on analytical approaches.
• Automate and transform data in Excel, Google Sheets, and other platforms.

Skills

Data Visualization

Data Cleaning

Communication Skills

Attention to Detail

Understanding of Ad Platforms

Education

Bachelor's Degree in a related field

Tools

Looker

Funnel

Excel

Google Sheets

Python

SQL

BigQuery

Google Analytics

PowerBI

Tableau

Job description

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:

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

Who you are:

Must Haves

1. You have a basic understanding of ad platforms, performance data, and KPIs
2. You are proficient in Excel/Google Sheets, Funnel, and Looker
3. You have excellent verbal and written communication skills
4. You have strong attention to detail

Nice to Have

1. You have a good understanding of paid media platforms, tracking, and KPIs.
2. You have experience running Casual Impact, Brand/Geo Lift Analysis and Forecasting
3. You are familiar with Google Analytics, GA4, DOMO, PowerBI, and Tableau

Why work at Part and Sum:

1. Autonomy: Each team member has clarity and support in their role, but is also given the freedom to tackle work in their own way. Bring your own perspectives and approaches; feel equipped to confidently make choices for you and your clients.
2. Creativity in systems: We build businesses and entire systems. Marketing is a starting point, not the sum of our impact.
3. Craft: We support your career growth through thoughtful work, collaboration, and professional development opportunities.
4. Our expectations match your own: We’re a team of smart, driven folks doing the best work of our careers. We have high expectations, but support each other in achieving them.
5. Ownership: We’re in this together, and believe everyone’s incentives should be aligned. We share profits, equity, and our business health metrics with the full team.
6. Tight feedback loops: We believe in clear feedback and effective communication. We ask a lot of questions and work together to find answers.
7. Good enough > perfect: We’re not interested in perfection. It doesn’t exist. We learn by putting good-enough things in the market as soon as possible and iteratively improving.
8. We’re kind: We’re a thoughtful, nice, and considerate bunch of people.
9. We have fun: We take our work seriously, but not ourselves.

Perks and Benefits

The Essentials

1. Competitive Base Salary: We are competitive and transparent about our pay bands. Your base salary offer will be determined by your career experience and skill level demonstrated throughout the interview process.
2. Associate: $50,000 - $75,000 with a midpoint of $62,500
3. Mid-Level: $65,000 - $105,000 with a midpoint of $85,000
4. Senior: $80,000 - $120,000 with a midpoint of $100,000
5. Profit Sharing: Additionally, target variable compensation for team members based on seniority are:
6. Mid-Level: 5-10% (that is $3,250 - $10,500 on top of the base salary)
7. Senior: 5-10% (that is $4,000 - $12,000 on top of the base salary)
8. Health Benefits: We offer a variety of health insurance options available on the first day after the first month of employment.
9. 401k: Set your future self up for financial success! Employees can start contributing to their 401k after 30 days of employment. We offer up to a 3% match.
10. Flexible WFH Policy: For this role, we are looking for candidates exclusively in NY or LA; however, we are generally flexible about where the team works. Our NY and LA-based team members work from the local office at least 1 day a week (typically Thursdays).
11. Responsible PTO Policy: In addition to US holidays, we are flexible and collaborative about planning and taking time off.
12. Family Leave: We offer 3 months of paid family leave for birthing parents and 2 months for non-birthing parents. All parents can choose to take additional time off.

Personal and Professional Development

1. Home Office Stipend: We provide a laptop and monitor plus an additional $500 to set up your home office.
2. Office Office: We have IRL office spaces in NY and LA (as well as Amsterdam, Sydney, and London). Our team is expected to work from the NY and LA offices at least 1 day a week.
3. Professional Development: All full-time team members receive an annual professional development budget that increases with your tenure.
4. Retreats: Join us for company get-togethers each year.
5. Sabbaticals: Take a 6-week break, fully paid, after every 5 years.

Other Details

This is a full-time opportunity with a preference for individuals living in the New York and Los Angeles Metropolitan Areas.

Travel may be required both locally and domestically. This will be less than 25% of total work time.

Fill out this application and someone from our hiring team will be in touch!

Our application consists of audio, fill-in, and check-box responses.