Senior Business Intelligence Engineer, WordPress VIP

Automattic Careers; United States; Remote; USD 100,000 - 180,000; Full time

Job summary

A leading company is seeking a Senior Business Intelligence Engineer to join their analytics team. This fully remote role involves designing ETL pipelines, building dashboards in Looker, and collaborating with various departments to drive data-driven decision-making. Candidates should have strong SQL skills and experience with data visualization tools. The position offers a competitive salary and the opportunity to work in a diverse, global environment.

Benefits

Open vacation policy

Competitive base salary

Fully remote work

Qualifications

• Experience developing ETL workflows and optimizing data processes.
• Proficient in SQL, with a focus on window functions and CTEs.
• Experience designing interactive BI dashboards for stakeholders.

Responsibilities

• Design database models and build ETL pipelines using Airflow.
• Build Looks and Dashboards in Looker to analyze enterprise technology data.
• Monitor marketing campaign performance and identify areas for improvement.

Skills

ETL workflows

SQL

Data analysis

Collaboration

Data visualization

Tools

Looker

Airflow

Salesforce

Hubspot

Hadoop

Job description

Senior Business Intelligence Engineer, WordPress VIP

Remote

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 . #LI-DNI

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.

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.

Create a Job Alert

Interested in building your career at Automattic Careers? Get future opportunities sent straight to your email.

Apply for this job

indicates a required field

First Name *

Last Name *

Preferred First Name

Email *

Phone

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Tell us how this position fits into an Analytics organization, and how your experience and skills qualify you to play that role. *

Tell us about the time when you used analytics to accelerate business growth. How did you identify the opportunity, what actions did you take and what were the exact results of your contributions? *

How did you hear about this role? * Select...

If you selected "Automattic Employee" or "Other" above, can you tell us more?

What region of the world do you live in? * Select...

Do you have a LinkedIn profile? If so, please provide a link.

Have you reviewed the compensation details (salary range) provided in the job description above? * Select...

Please indicate your salary expectation for this role. *

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Automattic Careers’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305

Page 1 of 1

OMB Control Number 1250-0005

Expires 04/30/2026

Voluntary Self-Identification of Disability

Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Intellectual or developmental disability
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
• Short stature (dwarfism)
• Traumatic brain injury

Disability Status Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.