Lead Analyst - Business Intelligence

Our Story

We make modern classics with character. We believe in true timelessness, the integrity of well-made clothes, and since our inception, great quality at a great price. That’s in our DNA.

But, we know it’s not only about the clothes—it’s about the feeling it gives the people who wear them, whether they’re confidently giving a presentation in a well-tailored suit; basking in long salty beach days in vibrant, colorful sun-soaked swimsuits, or joyfully re-discovering their favorite Rollneck sweater in their closet again and again, season after season.

And ultimately, it’s about helping our customers be the best, most authentic versions of themselves.

And that’s what we’re after, to inspire people’s lives and style.

Our dedication to Diversity, Equity, Belonging & Sustainability has been celebrated with industry recognition, reflecting our commitment to fostering an inclusive and sustainable workplace.

TITLE:              Lead Analyst - Business Intelligence (J. Crew Group, LLC)

LOCATION:      New York, NY (A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with company policies.)

DUTIES:           Lead a team of analysts and take ownership of reporting requirements from MP&A (Merchant, Planning & Allocation) Team. Manage relationships with our business partners through effective communication, prioritization, and negotiation. Translate product roadmaps into clear and detailed requirements, including features, user stories, backlogs, and acceptance test criteria in Jira. Collaborate closely with diverse business stakeholders, acting as a bridge between technical teams and business users to ensure alignment and understanding of BI initiatives. Manage the end-to-end process of data standardization, requirement gathering, data modeling, and dashboard creation in an Agile environment using tools like Excel, Smartsheet and Jira. Perform quality assurance using various SQL statements in Snowflake for newly released data, ensuring data integrity and consistency. Design Interactive Power BI dashboards to display right KPIs as per the business group and work with technical and business partners to roll them out to all users. Build reports for data analysis in MS Excel using Power BI’s 'Analyze in Excel' Functionality. Manage the Version control of Power BI reports and dashboards by performing repository maintenance and tracking changes to data models and reports using GitHub tool. Validate metadata of the measures and dimensions of the data model utilizing Tabular Editor for Power BI to ensure accurate Data Dictionary management. Write and Execute Data Tests to catch bug and resolve using DBT Tool. Oversee the work of BI Developer consultants.

REQTS:             Must have a Master's degree or foreign equivalent in Analytics, Information Systems, Business Intelligence, or a related field plus three (3) years of experience in the retail industry in the position offered, or as a Data Analyst, Business Intelligence Analyst, or a related position. Must have three (3) years of experience with all of the following: Creating automated reporting solutions using Power BI, SAP BW HANA, and SAP Business Objects; Conducting data analysis using SQL in Snowflake; Overseeing projects that incorporate retail digital solutions into our data infrastructure; Translating product roadmaps for Merchant, Planning, and/or Allocation departments in a retail company into actionable requirements for Data Engineering and Business Intelligence teams; Overseeing the activities of citizen BI developers in retail business units to ensure compliance with the enterprise level standards and strategies; Creating executive and enterprise-level reports tailored to meet the diverse needs of cross-functional senior stakeholders, necessitating adept conflict resolution and alignment strategies; Managing multifaceted datasets with diverse structures, formats, and sources, and translating complex requirements into practical and effective solutions; Implementing and executing Agile/Scrum methodologies, optimizing processes, and actively engaging users in daily operations.

HOURS:            Full time; Mon- Fri (40 hrs/week)

SALARY:          $141,170 - $163,200 per year

INCENTIVES OFFERED THROUGH THE EMPLOYEE REFERAL AWARD PROGRAM ARE APPLICABLE TO THIS POSITION. 

<