Business Intelligence Engineer

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, and 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!

You will love this job if… 

• You are a high performer, self-starter, and love to learn.
• You take ownership of projects and drive impact.
• You connect and grow both inside and outside the organization.
• You like to have fun and be your authentic self.
• You embrace change and lead the way.

• Cloud Data Infrastructure

• Serve as the primary day-to-day operator of Avicado's GCP data environment - BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage - working in close partnership with IT on access, security, and provisioning. The pipelines built here increasingly feed AI tooling; building with that downstream consumption in mind matters.

• 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 - unlocking reporting capabilities that don't currently exist

• Automate recurring operational workflows that currently run manually or locally: scheduled data quality checks, automated exports to downstream tools and systems, and replacing one-off scripts with reliable, scheduled GCP functions

• Follow version control best practices via GitHub, ensuring infrastructure changes are tracked, reviewable, and documented.
• Dashboard Development & Maintenance

• Serve as the primary owner of Avicado's dashboard portfolio across all internal teams - Operations, Finance, People & Talent, and Sales.

• Translate business logic from stakeholders into reliable, well-designed dashboards that people actually use.

• Current tooling is Tableau; this person should be proficient but tool-flexible - our visualization ecosystem may evolve.

• Build net-new dashboards for audiences that don't have reliable reporting today — including executive, director, and operational views that surface project financial data, service line performance, and renewal visibility.

• Own the full lifecycle of each dashboard: data source connections, SQL statements, refresh schedules, QC, documentation, and resolving bugs when things break - routing upstream data issues to the right owner when the problem lives outside the analytics layer.
• Data Quality & Governance

• Own data integrity within the analytics layer - ensuring pipelines are landing data correctly, views are accurate, and dashboards reflect what the source systems actually say.

• When something looks off, diagnose whether it's a pipeline or dashboard problem (theirs to fix) or a source data problem (theirs to route to the right owner - project data, people data, contracts, etc.).

• Maintain naming conventions, dataset organization, and schema documentation in BigQuery.

• Serve as the internal expert on how data flows between systems and where it breaks - clean, well-documented data is also what makes AI tooling reliable downstream.
• Cross-Functional Collaboration

• Work closely with stakeholders across Business Operations, Finance, People & Talent, Sales, and IT to understand reporting needs across all internal teams and translate them into working solutions.

• Be the first point of contact when a dashboard breaks or a pipeline fails - own the resolution, not just the escalation

• Partner with IT on data security, permissioning, and access governance
  

• 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.

• Experience working in a professional service, consulting, accounting, legal, engineering, or similar project-based organization.
• Experience with Azure.
• Experience with data modeling and analytics best practices.
• Experience supporting executive reporting and operational analytics.

• Responsive; Avicado takes great pride in reacting quickly and positively to our clients and teammates, both internal and external 
• Innovative; a desire to drive innovation through new and unique solutions while embracing creative ideas
• Entrepreneurial; the drive to take initiative, deliver results, and create value for our clients
• Empowered; bring solutions instead of problems
• Performance Driven & Accountable; sets goals and challenges our high-performance culture
• Even-tempered; handles pressure and thrives in a fast-paced environment
• Coachable; recognizes strengths & weakness and open to guidance 

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

Avicado was established in 2015 with a focus on utilizing the latest cloud-based tools and applications to enhance our clients' experience. As a technology consultancy, we empower construction owners to make the most of their systems and data. Our team of experts collaborates with enterprise organizations such as data centers, universities, hospitals, and real estate developers to promote seamless interoperability across their teams and technologies. We are experiencing an exciting phase of expansion and actively searching for new talent to join our team.

We’re a close-knit team with a high-performance culture, but we don’t like to take ourselves too seriously.

Our diversity and inclusivity are a point of pride, and we have created a highly interactive remote work environment that encourages mutual respect and individuality while fostering opportunities for employees to excel both personally and professionally. We offer competitive benefits, remote work experiences, flexible work arrangements, various career development opportunities, employee resource groups, and more.

Avicado's unwavering dedication to creating a remarkable workplace experience has been widely acknowledged by experts in the industry. We are thrilled to have attained the highly coveted "Great Place to Work" certification and to have been included on Inc.'s esteemed Best Workplaces list for three consecutive years. Additionally, we are humbled to have received the AYA Award, which recognizes allies who promote equality and actively foster positive change for women in technology. At Avicado, we take great pride in fostering a culture that is both inclusive and supportive, especially for women in the technology industry.

These accolades are a testament to our ongoing efforts to foster a culture of inclusion, mutual respect, and professional growth for all members of our team.

If you are a self-motivated individual who wants to work with Fortune 500 clients in a rapidly growing company, we encourage you to join us!

EOE