Power BI Analytics Consultant | Client Impact

Avicado Construction Technology Services, LLC; Northern (KY); Hybrid; USD 75,000 - 120,000; Full time

Benefits offered by this job

Health insurance

401k with employer match

Flexible PTO

Remote work experiences

Career development opportunities

Employee resource groups

Job summary

Avicado Construction Technology Services, LLC is seeking a Data Analyst Consultant to lead data visualization and analytics initiatives across a client portfolio. The role blends hands‑on technical delivery with client‑facing consulting to unlock insights and scale data capabilities.

You will engage with clients, define KPIs, design dashboards, and mentor junior analysts while ensuring scalable, enterprise‑grade solutions.

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.

Responsibilities

• Lead Power BI and analytics engagements from requirements gathering through delivery.
• 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 projects.
• Design and develop interactive Power BI dashboards and reports.
• Translate business requirements into 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.

Skills

Data analytics

Power BI

BI development

DAX

Power Query

Data modeling

SQL

APIs

Excel

Data visualization

Tools

Power BI

Power Automate

Power Apps

Snowflake

Azure

Google BigQuery

SQL

APIs

Job description

Avicado Construction Technology Services, LLC is seeking a Data Analyst Consultant to lead data visualization and analytics initiatives across a client portfolio. The role blends hands‑on technical delivery with client‑facing consulting to unlock insights and scale data capabilities.

You will engage with clients, define KPIs, design dashboards, and mentor junior analysts while ensuring scalable, enterprise‑grade solutions.