Senior Consultant - Data Analyst

Summary

Join Avicado as a Senior Consultant – Data Analyst and lead data and analytics initiatives from end to end. Partner with clients, consultants, and internal teams to leverage Project Management Information Systems (PMIS) in construction. Develop dashboards, automate workflows, write SQL scripts, and architect ELT dataflows. Consult on data collection, validation, and analysis, serving as a PMIS subject matter expert. Lead discovery sessions, build relationships with stakeholders, and drive projects to completion. Deliver exceptional service and contribute to a high-performance, remote team.

Requirements

• Minimum 3-5 years of hands-on experience with construction PMIS tools such as e-Builder, Procore, Unifier, or Primavera P6; including configuring, querying, and integrating PMIS data with BI tools
• Highly proficient in Tableau and/or Power BI
• Highly proficient in SQL
• Project control systems experience, specifically using tools like e-Builder, Procore, Oracle, Primavera
• Self-guided problem-solving in data analysis
• Attention to detail
• Professional written and verbal communication skills
• Strong organizational, presentation, and interpersonal skills

Responsibilities

• Developing aesthetically appealing dashboards to track KPIs
• Building solutions to automate existing manual workflows and reports
• Writing SQL scripts to power dashboards and answer ad hoc questions as they arise
• Architecting and designing ELT dataflows
• Working with Data Engineers to support pipeline development
• Consulting on processes of data collection, validation, and analysis
• Serving as a resource for e-Builder, Primavera Unifier, Primavera P6, & Procore data questions
• Serve as a subject matter expert on PMIS tools (e.g., e-Builder, Procore, Unifier, Primavera P6, Primavera Unifier), advising clients on data integration, reporting, and process automation best practices
• Lead discovery sessions with construction stakeholders to assess current PMIS usage, identify data opportunities, and propose scalable analytics solutions
• Establishing and maintaining relationships with multiple stakeholder groups
• Taking initiative and ownership over your role and driving projects to completion
• Establish and maintain relationships with the key stakeholders
• Deliver a “higher level of service,” a core value of the Avicado mission statement

Preferred Qualifications

• Experience with enterprise level system integrations
• Experience in the Construction industry as it relates to business processes or project management
• Deep experience with construction PMIS and understanding of project controls, scheduling, budgeting, and owner reporting workflows
• Lead client engagements as a trusted advisor, translating business needs into scalable data solutions with a PMIS-first lens
• Mentor junior analysts on PMIS platform utilization, data architecture, and dashboard development
• Proficiency in Python, Jupyter Notebooks, VSCode, DataBricks, or similar (a plus)

Benefits

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