Data & Analytics Support Analyst

Overview

Johnson Brothers Liquor Company is a leading family-owned distributor of wine, spirits, and beer, delivering exceptional service since 1953. We proudly represent the world's top beverage brands and are committed to excellence, innovation, and growth. Johnson Brothers offers exciting opportunities in a variety of areas. Join our passionate team and help shape the future of the beverage industry!

The Data & Analytics Support Analyst is a key member of our team, responsible for supporting a mission-critical Power BI reporting application environment. This client-facing role ensures smooth operations by troubleshooting issues, managing bug fixes and enhancements, and analyzing usage trends to optimize performance. Acting as a bridge between business stakeholders and development teams, the analyst ensures solutions meet requirements and deliver value.

• Primary ownership: act as the center‑point contact; ramp quickly to SME for Quota Management project within Enterprise Information Management Data & Analytics team.
• Front‑end (Power BI): build/redesign reports and models; optimize DAX, visuals, and load times.
• Back‑end (Data/SQL): validate/troubleshoot with SQL; drive upstream fixes with ETL/data engineering.
• Internal client engagement: clear, structured communication with Sales/Sales Ops and internal teams; set expectations and provide status.
• Proactive analytics: analyze usage/business trends; recommend KPI refinements, visualizations, simplifications, provide actionable business insights.
• Data integrity & governance: enforce RLS/OLS, security groups, active directories, apply classifications to content to protect/govern it, maintain workspace standards; develop and own data dictionaries.
• Process & enablement: document and maintain step-by-step SOPs, knowledge-base articles, FAQs, troubleshooting guides; reduce repeat incidents.
• Secondary work: support additional projects when bandwidth permits; prioritize Quota Management.

• Strong Power BI (report development, DAX, modeling, performance tuning).
• Solid SQL for validation and troubleshooting; familiarity with ETL/integration and governance.
• Experience with RLS/OLS, sensitivity labels, and workspace management.
• Exposure to Microsoft Fabric back‑end (Data Pipelines, Lakehouse/Warehouse, One Lake) and Azure Data Factory/Synapse; able to validate source‑to‑model flows, troubleshoot refresh/pipeline failures, and drive upstream fixes with engineering.

• Clear, concise communication with internal stakeholders (Sales/Sales Ops, data/engineering): status, risks, decisions; translates business needs into actionable technical changes; writes lean docs/KB.
• Timeliness & transparency: meets SLAs, provides early escalation on blockers, and publishes post‑incident reviews/release notes.
• Collaboration & expectation‑setting: partners with business and internal teams; facilitates backlog grooming/prioritization sets clear completion criteria.
• Structured troubleshooting & root‑cause analysis: hypothesis‑driven, evidence‑based; validates fixes and closes the loop with users.
• Ownership mindset: prioritizes the primary Quota Management project; protects focus while coordinating handoffs for secondary items. Continuously seeks opportunities to enhance visualizations, refine metrics, streamline processes, and drive better business outcomes
• Detail oriented with a commitment to data accuracy and quality.

• 4-7 years delivering production BI for internal stakeholders; primary owner/SME of a single program (ideally sales BI).
• Power BI: built/refactored reports and semantic models; tuned DAX and model design to improve speed and reliability.
• SQL: investigated data quality issues; reconciled to sources; pushed upstream fixes with engineering/contractors.
• Partnered on ETL/governance across Fabric/ADF/Synapse; diagnosed refresh/pipeline failures and resolved root causes.
• Internal client engagement: clear, timely, transparent status; translated business questions into metrics and report changes.
• Implemented RLS/OLS, sensitivity labels, and workspace hygiene; maintained data dictionary/SOP/KB to cut repeat tickets.
• Managed…