Unifier Technical Analyst

Transforming The Way Construction Owners Use Technology & Data If you like technology, solving problems, working with a dynamic team in a fast-paced environment, and providing excellent customer service, this is the position for you! The Unifier Technical Analyst is a crucial contributor to supporting our clients’ Unifier environments, reporting needs, and day-to-day operational activities. You will love this job if… You are a high performer, self-starter, and love to learn. You take ownership of projects and drive 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… SQL & Reporting Support Write, troubleshoot, and optimize SQL queries. Update and maintain SQL-based reports, including reading existing logic. Perform data validation, cleanup, and quality checks. Excel & Google Sheets Build and maintain structured trackers and data models. Use advanced formulas, pivots, and transformations for reporting and analysis. Clean, organize, and analyze large datasets. Unifier System Support Support the Unifier solution owner with day-to-day tasks. Learn Unifier configuration, workflows, and BP structures on the job. Assist with troubleshooting business processes (BPs) and workflow issues. Support updates to Unifier modules and reporting data structures You should have Strong SQL experience (writing, optimizing, and debugging queries). Advanced Excel/Google Sheets skills. Proven technical aptitude and a fast-learning mindset. Strong analytical and problem-solving abilities. Attention to detail, organization, and structured work habits. Excellent communication and collaboration skills. Preferred Qualifications Experience with Oracle Primavera Unifier (basic familiarity with shells, BPs, or data structures). Understanding of construction or cost-management concepts (cost codes, commitments, SOVs). Experience working with or around construction technology systems. 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 Construction Technology Services, 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