Power BI Data Analyst with Advanced Excel at Tech Tandem LLC

Job Role: Power BI Data Analyst with Advanced Excel. Location: Hybrid Role - 2-3 days Quincy, MA. Type: Apex W2. Job Description: * Interview process: 1 interview with Manager, 1 interview with Manager + Team. Analytical interview includes reviewing datasets in Excel and discussing interpretation. Includes a technical Excel exercise. Project Scope: * Analyze seasonal and holiday purchase trends (e.g., St. Patrick’s Day corned beef) to ensure accurate supply planning and avoid overbuying. * Develop and enhance vendor performance views in Power BI, including trade rates and other key metrics, to support category managers. * Collaborate with category managers to identify opportunities for improved performance through data-driven solutions. * Support promotional planning and themed activities by providing structured analytics and insights. * Identify best and worst-performing trade partners and work jointly on improvement strategies. Key Responsibilities: * Process and analyze category data to draw meaningful conclusions and highlight anomalies. * Build and maintain Power BI dashboards and views for margin governance and category performance. * Provide structured analytics to empower decision-making for category managers. * Assist in promotional target setting and performance tracking. Required Skills & Qualifications: * Advanced Excel proficiency, including complex functions. * Power BI experience. * Prior business experience. Preferred Qualifications: * Background in retail or merchandising. * Familiarity with SQL and/or Python.

Power BI Data Analyst with Advanced Excel

Emma

Responsibilities

Skills wanted:

Language(s) required:

Abhishek Singh

Abhishek Singh

About Tech Tandem LLC:

mission:

techtandem.io/

Admin access needed