Job Description
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…
Job Tags
Full time, Remote work, Flexible hours