Senior Business Intelligence Engineer

Summary

Join Automattic, the company behind WordPress.com, Jetpack, and WooCommerce, as a Senior Business Intelligence Engineer. Work closely with leadership and individuals across Marketing, Sales, Product, CS, and Finance. Design database models and build ETL pipelines to access data from various sources. Build Looker dashboards to analyze enterprise technology data, including customer usage, churn, and sales productivity. Perform ad-hoc analyses and deliver strategic insights. Assist in raising data quality and create a central data source. Monitor and track marketing campaign performance, identifying areas for improvement.

Requirements

• 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

Responsibilities

• 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

Benefits

• 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