Back to jobs

Senior Consultant - Data Analyst

U.S. - Remote

Transforming The Way Construction Owners Use Technology & Data

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 Senior Consultant – Data 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

 

Create a Job Alert

Interested in building your career at Avicado ? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Which of the following best describe your experience areas? (Select all that apply) *

 

  • Designing dashboards in Tableau

  • Designing dashboards in Power BI

  • Writing advanced SQL queries

  • Building ETL/ELT pipelines

  • Working directly with construction PMIS data

  • Leading client discovery sessions

  • Advising on enterprise data integrations

  • Managing stakeholder relationships

 

What construction software have you configured or integrated data from? (Select all that apply) *
Select...

U.S. Standard Demographic Questions

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Avicado ’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.