Business Intelligence Engineer

🔥 8 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Avicado

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2015

🏗️ Construction

💼 Consulting

🤝 B2B

Construction • Consulting • B2B

Avicado is a construction technology consulting firm that helps owners of large capital programs use technology and data to improve project outcomes. They provide advisory services, managed services, system implementation, custom integrations, assessments, reporting and dashboarding, training, and staff augmentation focused on project management information systems (PMIS), integrations with financial/ERP systems, and advanced analytics. Avicado serves institutional and commercial owners across sectors such as commercial, data centers, education, government, healthcare, manufacturing, power/energy, transportation, and water/wastewater, and works with tools like Procore, Trimble, and Autodesk to optimize capital programs and project controls.

📋 Description

• 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. • Write and maintain Python-based ETL scripts that pull data from source platforms and land it in BigQuery. • Extend the pipeline portfolio to bring new data sources online. • Automate recurring operational workflows that currently run manually or locally. • Follow version control best practices via GitHub, ensuring infrastructure changes are tracked, reviewable, and documented. • Serve as the primary owner of Avicado's dashboard portfolio across all internal teams. • Translate business logic from stakeholders into reliable, well-designed dashboards that people actually use. • Build net-new dashboards for audiences that don't have reliable reporting today. • Own the full lifecycle of each dashboard: data source connections, SQL statements, refresh schedules, QC, documentation, and resolving bugs when things break. • Own data integrity within the analytics layer. • Maintain naming conventions, dataset organization, and schema documentation in BigQuery. • Work closely with stakeholders 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.

🎯 Requirements

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

🏖️ Benefits

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