Business Intelligence Engineer

Role Description

Avicado has been doing meaningful business intelligence work for years - building dashboards, engineering data pipelines, and maintaining cloud infrastructure - but the people doing it have always had competing priorities. The work has been valuable, but it's never had a dedicated owner. The Business Intelligence Engineer will change that. This person will be the primary support pillar for Avicado's data and reporting infrastructure end-to-end:

• Stabilizing the dashboard portfolio we've built.
• Maturing the cloud pipelines that feed it.
• Building toward a future where leadership has reliable, timely data to make decisions about staffing, delivery, and revenue - across every part of the organization.

They'll do this in close partnership with IT on security and access, and with data owners across the internal team on accuracy. As Avicado embeds AI deeper into how we operate, this role is the foundation that makes that possible - clean, well-structured data is what AI tooling runs on.

If you enjoy solving complex data problems, building scalable cloud solutions, and helping business leaders make better decisions through trusted data, this is the opportunity for you!

Qualifications

• 5+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a similar role.
• Hands-on experience with Google Cloud Platform, particularly BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage.
• Strong Python development experience building and maintaining ETL pipelines.
• Strong SQL skills with experience working in cloud data warehouses.
• Strong experience designing and building Tableau dashboards from the ground up.
• Experience maintaining production reporting environments and troubleshooting data pipelines.
• Familiarity with Git/GitHub version control workflows.
• Strong analytical and problem-solving abilities with exceptional attention to detail and data accuracy.
• Excellent communication skills with the ability to translate business needs into technical solutions.
• Experience using AI-assisted development tools such as Claude Code, GitHub Copilot, Codex, Cursor, or similar coding assistants.

Requirements

• Serve as the primary day-to-day operator of Avicado's GCP data environment - BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage.
• Write and maintain Python-based ETL scripts that pull data from source platforms (Toggl, Rippling, Xero, Salesforce, etc.) and land it in BigQuery.
• Extend the pipeline portfolio to bring new data sources online - including CRM data not yet flowing into the warehouse.
• Automate recurring operational workflows that currently run manually or locally.
• Follow version control best practices via GitHub.
• Serve as the primary owner of Avicado's dashboard portfolio across all internal teams.
• Translate business logic from stakeholders into reliable, well-designed dashboards.
• Build net-new dashboards for audiences that don't have reliable reporting today.
• Own the full lifecycle of each dashboard.
• Own data integrity within the analytics layer.
• Maintain naming conventions, dataset organization, and schema documentation in BigQuery.
• Work closely with stakeholders across Business Operations, Finance, People & Talent, Sales, and IT.
• Be the first point of contact when a dashboard breaks or a pipeline fails.
• Partner with IT on data security, permissioning, and access governance.

Benefits

• Competitive compensation
• Health insurance
• 401k with employer match
• Flexible PTO
• Remote work
• Philanthropic Matching Gift Program
• And more…