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!
We are currently prioritizing candidates who reside in North American time zones.
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.
About Automattic
We’re the people behind WordPress.com, WooCommerce, Tumblr, Simplenote, Jetpack, Longreads, Day One, PocketCasts, and more. We believe in making the web a better place.
We’re a distributed company with more than 1400 Automatticians in nearly every corner of the globe, speaking over a hundred different languages. Enriched by this diversity, we’re united by a singular mission: to democratize publishing, commerce, and messaging so anyone with a story can tell it, anyone with a product can sell it, and everyone can manage their communications from a single source. In short, we help maintain a balance in society, creating and continually refining powerful tools people can use to compete fairly—regardless of income, gender, politics, language, or where they live in the world.
We believe in Open Source, and the vast majority of our work is available under the GPL. Automattic is a Most Loved Company and Disability Confident Committed. (Here’s what that might mean for you.) Learn more about our dedication to diversity, equity, and inclusion and our Employee Resource Groups.
If you need disability-related accommodations during the application or interview process, please fill out this form. We are committed to ensuring an accessible hiring process for all candidates.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Top Skills
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
