Full-Time Senior Business Intelligence Engineer

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. Work closely with our CMO, CFO, and other leaders and ICs in Marketing, Sales, Product, CS, and Finance.
2. 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.
3. 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.
4. Perform ad hoc analyses on financial and other metrics, on sales and marketing activities, and on customer behavior and needs.
5. Build strong relationships with teams and individuals throughout our organization to understand existing needs and find opportunities to use analytics to accelerate business growth.
6. 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.
7. Deliver strategic insights and produce reports on customer usage and behavior for marketing purposes.
8. 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.

What is the last date for applying to the job?

Which countries are accepted for this remote job?