• Serve as the primary operator of the GCP data environment: BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage, in close partnership with IT on security and access • Write and maintain Python-based ETL pipelines pulling from source platforms (Toggl, Rippling, Xero, Salesforce, and others) and landing data in BigQuery • Extend the pipeline portfolio to bring new data sources online and unlock reporting capabilities that do not currently exist • Automate recurring operational workflows currently running manually or locally: scheduled data quality checks, automated exports, and replacing one-off scripts with reliable GCP functions • Own the full Tableau dashboard portfolio across all internal teams: data connections, SQL, refresh schedules, QC, documentation, and bug resolution • Build net-new dashboards for audiences that don't have reliable reporting today, including executive, director, and operational views covering project financials, service line performance, and renewal visibility • Own data integrity within the analytics layer: diagnose whether issues are pipeline problems, dashboard logic problems, or source data issues, and route accordingly • Maintain naming conventions, schema documentation, and dataset organization in BigQuery • Be the first point of contact when a dashboard breaks or a pipeline fails — own resolution, not just escalation • Partner with stakeholders across Business Operations, Finance, People & Talent, Sales, and IT to translate business needs into working data solutions

• Design, develop, enhance, and maintain interactive dashboards, visualizations, analyses, and datasets in Amazon QuickSight. • Build high-performance dashboards optimized for large data volumes, usability, refresh efficiency, and operational reliability. • Develop and maintain curated datasets, semantic reporting layers, and reusable data models that support enterprise reporting needs. • Create standardized dashboard templates, QuickSight themes, KPI definitions, calculated fields, and modular reporting components for reuse across programs and business units. • Implement row-level security, role-based access controls, and governance controls to protect data and ensure proper user access. • Collaborate with business stakeholders, analysts, and technical teams to gather requirements and translate them into scalable BI solutions. • Enable self-service analytics by developing reusable reporting frameworks, documentation, training materials, and user guidance. • Integrate and optimize data sources from AWS services such as Redshift, Athena, S3, RDS, and Glue Data Catalog, and coordinate with data engineering teams to ensure data quality and availability. • Optimize the use of SPICE and direct query approaches to balance dashboard performance, refresh schedules, and cost efficiency. • Monitor and tune query and reporting performance across source systems and datasets and provide recommendations for cost-efficient reporting architectures. • Establish and maintain BI development standards, naming conventions, version control practices, and dashboard governance processes. • Support testing, defect resolution, release activities, and continuous improvement of BI products and analytics services. • Leverage AI-assisted development tools and emerging generative AI capabilities to improve dashboard development, reporting automation, documentation, and analytics delivery while following organizational security and governance standards.

Role Description As a Business Intelligence Engineer, you will take full ownership of a data and reporting ecosystem that has been built but never had a dedicated owner. The infrastructure is in place — Google Cloud pipelines, a Tableau dashboard portfolio, and integrations across the company's core platforms — and the business has outgrown the model of splitting this responsibility across people with other priorities. You will inherit this ecosystem, assess it, stabilize it, and then extend it. You will be the primary day-to-day operator of GCP data infrastructure, the sole owner of the internal Tableau environment, and the person who makes sure leadership across Operations, Finance, People & Talent, and Sales has accurate, timely data to make decisions. This role sits at the intersection of data engineering and business intelligence — approximately 60% backend data infrastructure and 40% BI and reporting. The right candidate is strong on both sides, not specialized in one. - Serve as the primary operator of the GCP data environment: BigQuery, Cloud Functions, Cloud Scheduler, and Cloud Storage, in close partnership with IT on security and access. - Write and maintain Python-based ETL pipelines pulling from source platforms (Toggl, Rippling, Xero, Salesforce, and others) and landing data in BigQuery. - Extend the pipeline portfolio to bring new data sources online and unlock reporting capabilities that do not currently exist. - Automate recurring operational workflows currently running manually or locally: scheduled data quality checks, automated exports, and replacing one-off scripts with reliable GCP functions. - Own the full Tableau dashboard portfolio across all internal teams: data connections, SQL, refresh schedules, QC, documentation, and bug resolution. - Build net-new dashboards for audiences that don't have reliable reporting today, including executive, director, and operational views covering project financials, service line performance, and renewal visibility. - Own data integrity within the analytics layer: diagnose whether issues are pipeline problems, dashboard logic problems, or source data issues, and route accordingly. - Maintain naming conventions, schema documentation, and dataset organization in BigQuery. - Be the first point of contact when a dashboard breaks or a pipeline fails — own resolution, not just escalation. - Partner with stakeholders across Business Operations, Finance, People & Talent, Sales, and IT to translate business needs into working data solutions. Qualifications - 5+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a hybrid of both. - Hands-on GCP experience: BigQuery (primary), Cloud Functions, Cloud Scheduler, and Cloud Storage — GCP is the operating environment and non-negotiable. - Strong Python development experience building and maintaining ETL pipelines; must write Python regularly, not occasionally. - Advanced SQL skills with experience querying cloud data warehouses and troubleshooting data quality issues. - Tableau proficiency: has built dashboards from scratch, not just consumed or made minor modifications to existing ones. - Experience maintaining production reporting environments and troubleshooting data pipelines end-to-end. - Familiarity with Git/GitHub version control workflows. - Strong ability to diagnose data problems across pipeline, dashboard, and source system layers independently. - Strong communication skills: able to explain technical data concepts to non-technical stakeholders across multiple business functions. - Experience using AI-assisted development tools (Claude Code, GitHub Copilot, Cursor, Codex, or similar) — Avicado is an AI-first company and AI usage is embedded in team culture. - English at B2 level or above; must be able to communicate clearly in a professional English-speaking environment. Preferred Qualifications - Background in professional services, consulting, accounting, legal, engineering, or similar project-based organizations — these environments most closely mirror Avicado's data complexity. - Experience at companies with 100-500 employees: understands the data needs of a mid-size professional services organization (too small = insufficient complexity; too large = too specialized). - Azure experience (Avicado has some Azure environment alongside primary GCP infrastructure). - Data modeling and analytics engineering best practices (dbt, dimensional modeling, or equivalent). - Experience supporting executive and director-level reporting and operational analytics. Benefits - Salary: $4,000 USD per month. - PTO: Unlimited PTO.

Role Description IT@JH Univ Data Analytics & Engineering is seeking a BI Administrator who will provide hands-on technical leadership for the administration, operational reliability, and governance support of Johns Hopkins’ enterprise BI platforms, including Tableau Cloud, Power BI, and emerging Microsoft Fabric. The position is responsible for day-to-day platform operations such as: - Configuration - Monitoring - Troubleshooting - Gateway and bridge coordination - Tier 2/3 support - Vendor escalation The role operates within a matrixed administrative model, working closely with partner BI administrators across other institutional areas to promote aligned practices, coordinated decision-making, and consistent platform support for a broad and diverse customer base. In addition, the role develops technical guidance and user-facing communications, supports licensing and cost recovery activities, and helps ensure these BI services remain secure, stable, scalable, and well governed for the institution. Qualifications - Bachelor's Degree - Six years of related experience - Additional education may substitute for required experience and additional related experience may substitute for required education beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula Requirements - Demonstrated experience administering cloud BI services and hybrid connectivity components (gateways/bridges) - Experience troubleshooting production incidents and maintaining operational documentation/runbooks - Comfort operating in cross-team governance processes and translating platform capabilities/risks into standards, communications, and operational practices Benefits - Starting Salary Range: $85,500 - $149,800 Annually (Commensurate w/exp.) - Employee group: Full Time - Schedule: Mon-Fri 8:30am-5:00pm - FLSA Status: Exempt - Location: Remote - Department name: IT@JH Univ Data Analytics & Engineering - Personnel area: University Administration