Data Science Consultant

Role Description

Avicado Construction Technology Services is seeking a Data Science Consultant to lead the design and delivery of data visualization and analytics solutions across a portfolio of clients. This role blends hands-on technical execution with client-facing consulting, enabling organizations to unlock insights, improve decision-making, and scale their data capabilities.

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 enjoy working directly with clients and solving complex problems.
• You thrive in fast-paced, ambiguous environments.
• You like to have fun and be your authentic self.

What you’ll do…

• Client Engagement & Project Leadership
  • Lead Power BI and analytics engagements from requirements gathering through delivery and iteration.
  • Serve as the primary point of contact for clients on reporting and analytics initiatives.
  • Facilitate workshops to define KPIs, reporting needs, and business requirements.
  • Manage timelines, deliverables, and expectations across multiple concurrent clients and projects.
• Dashboard Design & Development
  • Design and develop interactive Power BI dashboards and reports.
  • Translate business requirements into intuitive visualizations and user experiences.
  • Apply best practices in data storytelling, usability, and performance.
• Data Modeling & Transformation
  • Build and optimize data models using star schema and best practices.
  • Develop DAX calculations, measures, and performance optimizations.
  • Use Power Query to extract, transform, and structure data from multiple sources.
• Technical Delivery & Optimization
  • Establish efficient data refresh strategies and performance optimization techniques.
  • Ensure solutions are scalable, maintainable, and aligned with enterprise standards.
  • Troubleshoot and resolve data, performance, and visualization issues.
• Team Collaboration & Mentorship
  • Delegate and review work from junior analysts and developers.
  • Provide mentorship and guidance to support team growth.
  • Ensure consistency, quality, and best practices across deliverables.
• Stakeholder Communication & Enablement
  • Present dashboards, insights, and recommendations to stakeholders.
  • Advise clients on data strategy, reporting improvements, and governance.
  • Support adoption through training, documentation, and knowledge transfer.

Qualifications

• 5–8+ years of experience in data analytics, BI development, or related roles.
• 3–5+ years of hands-on experience with Power BI.
• Proven experience leading end-to-end reporting or dashboard initiatives.
• Advanced expertise in Power BI, data modeling, and visualization best practices.
• Strong proficiency in DAX, Power Query (M), and data transformation techniques.
• Experience working with multiple data sources (SQL, APIs, warehouses, Excel, etc.).
• Strong analytical thinking, problem-solving, and communication skills.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Experience in consulting or client-facing roles.
• Familiarity with modern data platforms (Snowflake, Azure, Google BigQuery, etc.).
• Experience with ETL/ELT processes and data pipelines.
• Experience with Power Platform tools (Power Automate, Power Apps).
• Experience with governance, deployment pipelines, and Power BI Service administration.
• Experience supporting construction, capital projects, or data center 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 & weaknesses and open to guidance.

Benefits

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