[Remote] Data Analyst Consultant

Note: The job is a remote job and is open to candidates in USA. Avicado is a technology consultancy focused on enhancing client experiences through cloud-based tools and applications. They are seeking a Data Analyst Consultant to lead data visualization and analytics solutions for clients, blending technical execution with client-facing consulting to improve decision-making and data capabilities.

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

Skills

• 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
• 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

Benefits

• Competitive compensation
• Health insurance
• 401k with employer match
• Flexible PTO
• Remote work
• Philanthropic Matching Gift Program  And more…
• Competitive benefits
• Remote work experiences
• Flexible work arrangements
• Various career development opportunities
• Employee resource groups

Company Overview