Senior Business Intelligence Engineer, WordPress VIP

Automattic; San Francisco (CA); Remote; USD 100,000 - 180,000; Full time

Job summary

Automattic is seeking a Senior Business Intelligence Engineer to join their analytics team. This role involves collaboration across departments, designing ETL pipelines, creating BI dashboards, and providing strategic insights to support business growth. The ideal candidate will have a strong background in data analysis and business intelligence tools, with excellent communication skills to convey insights effectively.

Benefits

Fully remote work environment

Open vacation policy

Comprehensive benefits

Qualifications

• Experience with ETL workflows and tools like Airflow, Python, SQL.
• Proficient in SQL, including window functions and CTEs.
• Strong communication skills to convey technical data.

Responsibilities

• Design database models and develop ETL pipelines.
• Create dashboards and reports in Looker for data analysis.
• Monitor and optimize marketing campaign performance.

Skills

ETL workflows

SQL

Business Intelligence

Data analysis

Communication

Tools

Airflow

Looker

Salesforce

Hubspot

Hadoop

Snowflake

Redshift

Job description

Senior Business Intelligence Engineer, WordPress VIP

We’re Automattic, the company behind WordPress.com, Jetpack, and WooCommerce. We're looking for a Senior Business Intelligence Engineer to join our analytics team.

As a Senior Business Intelligence Engineer on the WordPress VIP team, you will:

1. Collaborate with senior leaders and teams across Marketing, Sales, Product, Customer Support, and Finance.
2. Design database models and develop ETL pipelines using tools like Airflow to integrate data from sources such as Hubspot, Salesforce, Pendo, Gainsight, Google Sheets, and our proprietary platform, making data accessible via SQL databases and Looker.
3. Create dashboards and reports in Looker to analyze enterprise data, including customer usage, churn, revenue metrics, and sales funnels.
4. Perform ad hoc analyses on financial metrics, sales and marketing activities, and customer behavior.
5. Build strong relationships across teams to identify analytics needs and opportunities for business growth.
6. Improve data quality by auditing sources, documenting issues, and collaborating on resolutions to establish a reliable 'source of truth.'
7. Provide strategic insights and generate reports on customer behavior to support marketing strategies.
8. Monitor and optimize marketing campaign performance, ROI, customer acquisition, and engagement metrics.

We’d love to hear from you if:

• You have experience developing and optimizing ETL workflows with tools like Airflow, Python, SQL, Spark.
• You are proficient in SQL, including window functions and CTEs.
• You have designed interactive BI dashboards that enable data-driven decision-making.
• You have experience with sales and marketing tools like Salesforce, Hubspot, and Bizible.
• You have worked with Hadoop ecosystems such as Impala, Hive, Spark, or cloud data warehouses like Snowflake or Redshift.
• You are passionate about business intelligence solutions and adaptable to different platforms.
• You excel at collaborating with diverse teams, including executives and developers.
• You prioritize user experience in dashboards and reports, highlighting trends and anomalies effectively.
• You understand SaaS metrics and have experience delivering analytics solutions across teams.
• You possess excellent communication skills in English, capable of conveying technical data to non-technical partners.

Note: We are prioritizing candidates in North American time zones. Salary range: $100,000-$180,000 USD. Compensation reflects potential contribution and impact. We offer a fully remote work environment, open vacation policy, and comprehensive benefits. Learn more about our company and culture on our blog and benefits page.

About Automattic

We’re the team behind WordPress.com, WooCommerce, Tumblr, and more. Our mission is to democratize publishing, commerce, and messaging, making the web a better place. With over 1400 employees worldwide, we value diversity, open source, and inclusive growth. We are committed to accessibility and equal opportunity employment.