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.

#LI-DNI

We welcome you to apply, even if you don't check all the boxes. Our passion is scouting life-long learners who are driven by curiosity, and who feel connected to our brands and share our desire to make an impact. We’re always seeking bright new talent who leverage their unique experiences to discover, grow and evolve with our teams.

Benefits + Perks

Health & Well-being - Eligible associates and family members receive medical, dental, prescription and vision insurance, family planning (fertility, adoption & surrogacy support), fitness discounts, medical travel and more.

Associate Discount - We love our products just as much as you do! That’s why we offer a great associate discount across all of our brands (J.Crew, J.Crew Factory, and Madewell).

Flex Fridays - In addition to our hybrid work model, we also close our office at 1:00 PM every Friday year-round.

Community Impact - We support the communities where we live and work through our philanthropic efforts and the J.Crew Cares Program.

Winter Break - In addition to our PTO package, J.Crew Group offers a winter break at the end of December to eligible full-time associates at the Home Office to provide time to refresh and recharge.

Note: Availability of these benefits and perks may be subject to work location & employment type and may have certain eligibility requirements.

At J.Crew Group (JCG) we aim to pay competitively for our company’s size and industry. The base salary offered will take into account internal equity and may vary depending on the candidate’s geographic region of work premises, job-related knowledge, skills, and experience among other factors. The base salary is just one component of J.Crew Group’s competitive total rewards strategy that also includes the opportunity for bonus, competitive benefits and perks.

One of our core focuses here at JCG is creating a community and culture that builds belonging. We are deeply committed to our Diversity, Equity and Inclusion efforts, and we warmly welcome job applicants of all backgrounds.

JCG is proud to affirmatively provide equal opportunity to all associates and qualified applicants without regard to race, color, religion, national origin or citizenship, age, sex, marital status, ancestry, legally protected physical or mental disability, veteran status, gender identity, sexual orientation or any other basis protected under applicable law.

116929