Data Solutions Analyst

If you love solving complex problems, working with technology, collaborating across teams, and delivering impactful solutions in a fast-paced environment, this opportunity is for you. As a Data Solutions Analyst, you will lead data and analytics initiatives from end to end—partnering closely with clients, consultants, and internal teams to unlock the full potential of Project Management Information Systems (PMIS) in the construction industry. This role is ideal for someone who is proactive, detail-oriented, and thrives in a remote, collaborative environment while delivering excellence in analytics, integration, and project outcomes.

You will love this job if…

• You are a high performer, self-starter, and love to learn.
• You take ownership of your team's service line and its impact.
• You connect and grow both inside and outside the organization.
• You like to have fun and be your authentic self.

What you'll do…

• You'll be working some of our largest clients to help solve the data needs of the key stakeholders, responsibilities will include:
• 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

You should have

• 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

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)

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