What are the responsibilities and job description for the Power BI Data Analyst with Advanced Excel position at Emma of Torre.ai?
I’m helping Tech Tandem LLC find a top candidate to join their team full-time for the role of Power BI Data Analyst with Advanced Excel.
You will empower data-driven decisions, optimizing supply and enhancing vendor performance.
Compensation:
USD 45/hour
Location:
Hybrid: 1385 Hancock Court, Quincy, MA 02169, United States
Mission of Tech Tandem LLC:
"TechTandem is a leading provider of IT staffing and strategic talent solutions. Our mission is to help organizations build high-performing teams by providing top-quality talent, industry expertise, and comprehensive support services."
What makes you a strong candidate:
- You are proficient in Microsoft Power BI, Microsoft Excel, Analysis.
- You have the potential to develop in SQL, Python.
- English - Conversational
Responsibilities and more:
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.