remoteonsite
Data Analyst - JCPenney
Data Analyst
Data Analyst role focused on extracting insights from retail and e‑commerce data using SQL, Python, Tableau, and advanced Excel techniques to drive business decisions and optimize supply chain performance.
About the role
Key Responsibilities
- Design, develop, and maintain complex SQL queries and data models to support cross‑functional reporting and analytics.
- Extract, clean, and transform large datasets from multiple retail and e‑commerce sources using Python and pandas.
- Create interactive dashboards and visualizations in Tableau to communicate key metrics to stakeholders.
- Perform statistical analysis and trend forecasting to identify opportunities for sales growth and operational efficiency.
- Collaborate with product, marketing, and supply‑chain teams to define data requirements and deliver actionable insights.
Requirements
- 3+ years of experience in data analysis within a retail or e‑commerce environment.
- Proficiency in SQL (T‑SQL, PostgreSQL) and Python for data manipulation.
- Strong Tableau skills with a portfolio of published dashboards.
- Advanced Excel knowledge, including pivot tables, VLOOKUP, and macros.
- Solid understanding of statistical methods and experience with hypothesis testing and regression analysis.
Skills
data analysissqlpythontableauexcel