Would it inspire you to contribute to the growth of a product that ignites the creativity of millions of content creators? WeVideo is a powerful, easy to use, cloud-based video creation platform. We are a leading choice for digital video editing used in more than 6500 K-12 schools by educators, schoolchildren worldwide, and by individual creators and small businesses.

We have an immediate opening for a Senior Data Analyst. You will be working within the Analytics team at WeVideo to help build out and grow our data infrastructure. The team plays a central role in shaping the data ecosystem in our company, and enables business performance by providing users across the company with the insights, tools, infrastructure, and consulting to make data-driven decisions. Our org is hungry for data and needs you to help us get to the next level.

What You Will Do In This Role

• Understand Hubspot (marketing), Salesforce (sales), Mixpanel (product usage) data models and how to take advantage of them in our BigQuery data warehouse. Collaborate and partner with Product Analytics, Marketing & Sales team members to support strategy execution.

• Be the technical lead to enable Data Integration projects and consolidate data from different business systems into the warehouse.

• Use high fluency with SQL to write optimized data transformations, blend datasets, develop optimized views and metrics for aggregation, visualization and advanced analytics.

• Automate and monitor dataflows to manage extraction of data into BigQuery (using no-code connectors) and write-back data to the source systems, using ‘modern data stack’ SQL-based tools and no-code automation.

• Build dashboards, run analysis, develop insights, support decision-making across the company's business - primary BI tools currently are Data Studio (reporting), Tableau (general analysis) and Mixpanel (product analysis)

Skills And Experience You Possess

• 2 years in data engineering with a Bachelor's degree in CS, Data Science, or similar technical field, or equivalent professional experience.

• Demonstrated success building and automating batch data pipelines, as well as end-to-end Monitoring and Alerting solutions.

• High fluency with advanced SQL in BigQuery environment

• Proficient in creating high quality, fast services and projects in Python.

• Experience building data pipes using GCP/AWS

• Strong communication skills and interest in working with Marketing & Sales teams

Benefits & Perks

• Potential remote opportunity

• Medical, dental, vision and company 401(k) matching

• Generous PTO policy

• Free lunch and snacks

• Enough free caffeine to keep you up for 2 weeks straight

• Employee development resources

Why You Might Like Working Here

• We’re a small, close-knit team that enjoys working and learning from each other.

• Flexible, collaborative culture that values work-life balance

• People stick around. Some of your future colleagues have been for over 8 years.