At Avicado, we help some of the world's largest organizations make better decisions through technology, data, and process optimization. Our consultants partner directly with Fortune 500 clients to solve complex business challenges across construction, operations, finance, and supply chain.

We're looking for a Business Intelligence Consultant who enjoys solving business problems with data. This person will partner with Supply Chain and Operations teams to design reporting solutions, automate manual processes, build scalable data pipelines, and develop dashboards that enable smarter decision-making.

You'll thrive in this role if you're equally comfortable talking with business stakeholders, writing SQL, building dashboards, and identifying opportunities to improve how data flows across enterprise systems.

You will love this job if… 

• You enjoy solving business problems using data. 

• You can translate operational challenges into technical solutions. 

• You enjoy working directly with stakeholders and consulting with clients. 

• You like building scalable reporting rather than maintaining spreadsheets. 

• You are curious, proactive, and continuously learning new technologies. 

• You enjoy working in a collaborative remote environment.

What you’ll do… 

• Partner with Supply Chain, Operations, Finance, and Project teams to understand reporting and analytics needs. 

• Design, develop, and maintain enterprise dashboards and KPI reporting. 

• Build and optimize SQL queries, views, and data models that support operational reporting. 

• Integrate data from multiple enterprise systems into centralized reporting solutions. 

• Improve data quality, governance, and documentation across reporting environments. 

• Translate business requirements into scalable technical solutions. 

• Present findings and recommendations to both technical and non-technical stakeholders. 

• Collaborate with software engineers and business partners to develop internal data applications. 

• Identify opportunities to automate manual reporting processes. 

• Leverage AI tools responsibly to improve development efficiency and accelerate solution delivery.

You should have 

• Bachelor's degree in computer science, Information Systems, Analytics, Engineering, Finance, Mathematics, or related fields. 

• 5+ years of experience in Business Intelligence, Analytics, Data Engineering, or similar roles. 

• Advanced SQL experience. 

• Experience designing enterprise dashboards using Tableau, Power BI, or similar BI tools. 

• Experience integrating data from multiple business systems. 

• Experience supporting Supply Chain, Procurement, Manufacturing, Logistics, or Construction organizations.

• Strong understanding of relational databases and data modeling. 

• Experience developing KPIs and executive reporting. 

• Familiarity with AI-assisted software development tools

• Excellent analytical and problem-solving skills. 

• Strong communication skills with both business and technical stakeholders. 

• Experience gathering business requirements and translating them into technical solutions.

Nice Experience to Have  

• Experience working with Node.js web applications. 

• Professional Python experience for automation or ETL development.

• Experience with modern ETL orchestration tools. 

• Experience working with ERP systems. 

• Experience integrating systems such as Procore, Oracle Unifier, Primavera P6, SAP, Oracle ERP, O9 or similar enterprise platforms. 

• Experience working in Agile consulting environments. 

Characteristics of an ideal candidate  

• 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  

Why Avicado  

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

About Avicado  

Avicado, LLP 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

Transforming The Way Construction Owners Use Technology & Data