[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.ResponsibilitiesLead Power BI and analytics engagements from requirements gathering through delivery and iterationServe as the primary point of contact for clients on reporting and analytics initiativesFacilitate workshops to define KPIs, reporting needs, and business requirementsManage timelines, deliverables, and expectations across multiple concurrent clients and projectsDesign and develop interactive Power BI dashboards and reportsTranslate business requirements into intuitive visualizations and user experiencesApply best practices in data storytelling, usability, and performanceBuild and optimize data models using star schema and best practicesDevelop DAX calculations, measures, and performance optimizationsUse Power Query to extract, transform, and structure data from multiple sourcesEstablish efficient data refresh strategies and performance optimization techniquesEnsure solutions are scalable, maintainable, and aligned with enterprise standardsTroubleshoot and resolve data, performance, and visualization issuesDelegate and review work from junior analysts and developersProvide mentorship and guidance to support team growthEnsure consistency, quality, and best practices across deliverablesPresent dashboards, insights, and recommendations to stakeholdersAdvise clients on data strategy, reporting improvements, and governanceSupport adoption through training, documentation, and knowledge transferSkills5–8+ years of experience in data analytics, BI development, or related roles3–5+ years of hands-on experience with Power BIProven experience leading end-to-end reporting or dashboard initiativesAdvanced expertise in Power BI, data modeling, and visualization best practicesStrong proficiency in DAX, Power Query (M), and data transformation techniquesExperience working with multiple data sources (SQL, APIs, warehouses, Excel, etc.)Strong analytical thinking, problem-solving, and communication skillsAbility to manage multiple priorities in a fast-paced environmentExperience in consulting or client-facing rolesFamiliarity with modern data platforms (Snowflake, Azure, Google BigQuery, etc.)Experience with ETL/ELT processes and data pipelinesExperience with Power Platform tools (Power Automate, Power Apps)Experience with governance, deployment pipelines, and Power BI Service administrationExperience supporting construction, capital projects, or data center environmentsBenefitsCompetitive compensationHealth insurance401k with employer matchFlexible PTORemote workPhilanthropic Matching Gift Program And more…Competitive benefitsRemote work experiencesFlexible work arrangementsVarious career development opportunitiesEmployee resource groupsCompany OverviewAvicado is a construction technology consultancy that offers cloud-based technologies for collaboration, communication and project controls. It was founded in 2015, and is headquartered in Miami, Florida, USA, with a workforce of 201-500 employees. Its website is https://www.avicado.com/.