Data Science Consultant

Avicado

17h•Remote

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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
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
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
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
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
Present dashboards, insights, and recommendations to stakeholders
Advise clients on data strategy, reporting improvements, and governance
Support adoption through training, documentation, and knowledge transfer