[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