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:

• Work closely with our CMO, CFO, and other leaders and ICs in Marketing, Sales, Product, CS, and Finance.

• Design database models and build ETL pipelines via Airflow and other tools to access data from sources such as Hubspot, Salesforce, Pendo, Gainsight, Google Sheets, and our proprietary platform and make it available through a relational SQL database and Looker.

• Build Looks and Dashboards in Looker to analyze common enterprise technology data, including: customer product usage, churn, net revenue retention, sales productivity, CAC payback periods, and sales and marketing funnels.

• Perform ad hoc analyses on financial and other metrics, on sales and marketing activities, and on customer behavior and needs.

• Build strong relationships with teams and individuals throughout our organization to understand existing needs and find opportunities to use analytics to accelerate business growth.

• Assist the organization in raising data quality by double-checking and auditing data from different sources, documenting issues, driving resolutions together with other teams, and creating the central “source of truth” for all our data.

• Deliver strategic insights and produce reports on customer usage and behavior for marketing purposes.

• Performance Tracking: Monitor and track marketing campaign performance, including ROI, customer acquisition, and engagement metrics. Identify areas for improvement and optimization.

We’d love to hear from you if:

• You have experience developing and optimizing ETL workflows using common data engineering tools (e.g., Airflow, Python, SQL, spark) to centralize data from disparate systems into a single source of truth.

• You’re proficient in SQL: window functions and CTEs are part of our daily work.

• You have designed and developed interactive BI dashboards and reports that provide actionable insights for stakeholders across the organization, enabling data-driven decision-making.

• Experience in sales and marketing tech stack systems like Salesforce, Hubspot, and/or Bizible. 

• You’ve worked in a Hadoop ecosystem before (in the day-to-day, we use Impala, Hive, and Spark) or have experience with Snowflake or Redshift.

• You know and love working on business intelligence solutions: we use Looker as our platform, but experience with a different tool and an ability to learn can go a long way.

• You’re highly collaborative and experienced in working with business owners, executives, developers, and creative teams to discuss data, strategy, and tests.

• You care deeply about the user experience when it comes to dashboards and reports, and have crafted creative solutions to identify and surface trends, changes, and anomalies in reporting.

• You have experience working across teams to deliver analytics solutions and are familiar with the common metrics of software as a service (SaaS) business.

• You have excellent verbal and written communication skills in English.

• You’re able to communicate clearly with and about data to technical and non-technical partners.

Curious about who we are and what we work on? Read our blog!

Salary range: $100,000-$180,000 USD - Please note that salary ranges are global, regardless of location, and we pay in local currency.

We are searching for high-caliber candidates with the skills and qualities to have a net positive for Automattic. Pay will reflect the potential contribution and the impact you can bring, which may, in some cases, go beyond the range stated.

We’re pleased to offer a straightforward, competitive base salary, providing financial clarity without complex variable components. This isn’t your typical work-from-home job—we are a fully-remote company with an open vacation policy. Read more about our compensation philosophy. To see a full list of benefits by country, consult our Benefits Page. And check out these links to learn more about How We Hire and What We Expect from Ourselves.