Senior Business Intelligence Engineer

Avicado; United States; On-site; CLP 36,934,441 - 55,401,661; Full time

Benefits offered by this job

Competitive compensation

Health insurance

401(k) with employer match

Flexible PTO

Philanthropic matching gift program

Job summary

Avicado is hiring a Business Intelligence Engineer to enhance their data infrastructure and dashboards. This role will stabilize their reporting systems and ensure data integrity.

The ideal candidate should possess 5+ years of relevant experience, strong Python and SQL skills, and familiarity with Google Cloud Platform. Enjoy a supportive work environment with competitive compensation, health benefits, and a flexible work schedule.

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 and related tools.
• Strong analytical and problem‑solving abilities with exceptional attention to detail.

Responsibilities

• Operate Avicado's GCP data environment and write ETL scripts.
• Own Avicado's dashboard portfolio across all internal teams.
• Ensure data integrity within the analytics layer and troubleshoot issues.

Skills

Python development

SQL

Google Cloud Platform

Data integrity and governance

Dashboard development

Analytical skills

Education

5+ years of experience in Business Intelligence

Tools

Tableau

Git/GitHub

Job description

Transforming The Way Construction Owners Use Technology & Data

Avicado has been doing meaningful business intelligence work for years—building dashboards, engineering data pipelines, and maintaining cloud infrastructure—yet 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 role supports Avicado’s data and reporting infrastructure end‑to‑end: stabilizing the dashboard portfolio, maturing the cloud pipelines that feed it, and building toward a future where leadership has reliable, timely data for staffing, delivery, and revenue decisions. The engineer partners closely with IT on security and access, and with data owners on accuracy.

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.

What you’ll do…

• Cloud Data Infrastructure
  • Operate Avicado's GCP data environment—BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage—in partnership with IT on access, security, and provisioning.
  • Write and maintain Python‑based ETL scripts that pull data from sources such as Toggl, Rippling, Xero, Salesforce, etc., and load it into BigQuery.
  • Extend the pipeline portfolio to onboard new data sources, including CRM data not yet flowing into the warehouse.
  • Automate recurring operational workflows—scheduled data quality checks, automated exports, and scheduled GCP functions—to replace manual or one‑off scripts.
  • Follow version control best practices via GitHub, ensuring infrastructure changes are tracked, reviewable, and documented.
• Dashboard Development & Maintenance
  • Own Avicado's dashboard portfolio across all internal teams—Operations, Finance, People & Talent, and Sales.
  • Translate business logic from stakeholders into reliable, well‑designed dashboards.
  • Build and maintain dashboards using Tableau (or other visualization tools as the ecosystem evolves).
  • Create net‑new dashboards for audiences lacking reliable reporting, 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, quality checks, documentation, and bug resolution.
• Data Quality & Governance
  • Ensure data integrity within the analytics layer—pipelines land data correctly, views are accurate, and dashboards reflect source systems.
  • Diagnose data issues and decide whether they stem from pipelines, dashboards, or source systems, routing the problem to the appropriate owner.
  • Maintain naming conventions, dataset organization, and schema documentation in BigQuery.
  • Serve as the internal expert on how data flows between systems and identify where breaks occur.
• Cross‑Functional Collaboration
  • Work closely with stakeholders in Business Operations, Finance, People & Talent, Sales, and IT to understand reporting needs and translate them into solutions.
  • Act as the first point of contact when a dashboard breaks or a pipeline fails—own the resolution, not just escalation.
  • Partner with IT on data security, permissioning, and access governance.

You should have

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

Preferred Qualifications

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

Characteristics of an ideal candidate

• Responsive; reacts quickly and positively to clients and teammates.
• Innovative; drives innovation through new and unique solutions while embracing creative ideas.
• Entrepreneurial; takes initiative, delivers results, and creates value for clients.
• Empowered; brings solutions instead of problems.
• Performance‑driven & accountable; sets goals and challenges a high‑performance culture.
• Even‑tempered; handles pressure and thrives in a fast‑paced environment.
• Coachable; recognizes strengths and weaknesses and is open to guidance.

Why Avicado

• Competitive compensation
• Health insurance
• 401(k) with employer match
• Flexible PTO
• Remote work
• Philanthropic matching gift program and more

EOE