Steve Madden is looking for a Junior Business Intelligence Analyst to join the Digital Wholesale team. The role involves building and maintaining reporting, analyzing data trends, and utilizing AI tools to enhance efficiency and insights in the digital wholesale business.
Build, maintain, and improve weekly reporting across Amazon, Zappos, and digital wholesale accounts — sales, traffic, glance views, conversion, inventory, and ad performance in partnership with the account team
Pull data yourself from multiple sources; do not wait for someone to hand you a clean file — go find it, clean it, and make it usable
Identify trends, anomalies, and patterns in the data; flag what is interesting, not just what was asked for
Support the build-out of the digital wholesale reporting infrastructure; this is early-stage work and you will have a hand in shaping what gets built
Maintain data accuracy and consistency across reports; catch errors before they reach leadership
Work in BI tools (Google Data Studio, Looker, Power BI, or comparable) to build and maintain dashboards that give the team a clear, real-time view of the business
Write and run SQL queries to pull data directly from source systems; comfort with basic to intermediate SQL is required — you do not need to be a data engineer, but you need to be able to get the data yourself
Build and manage complex Excel models; pivot tables, lookups, and dynamic reporting are core to this role — advanced Excel is not optional
Explore and recommend AI tools that can accelerate reporting, automate repetitive data tasks, or surface insights faster; bring ideas to the Director and test them
Stay current on BI and analytics tooling; if there is a better way to do something, find it and propose it
Use AI tools actively in your day-to-day work — to draft analysis, identify patterns, summarize data, and move faster on repetitive tasks
Identify reporting or data workflows that could be automated; bring a solution, not just the observation
Experiment with new AI capabilities as they emerge; be the person on the team who knows what is possible and pushes the team to use it
Help build the case for AI and automation investment by documenting time savings and output improvements from tools you introduce
Support the Director and the Marketing Manager with data pulls, ad hoc analysis, and reporting needs; turn requests around quickly and accurately
Partner with the Data and Reporting team to understand how Amazon and wholesale data flows into the enterprise BI environment; learn the architecture, not just the outputs
Bring analytical support into account management and sales conversations when needed; translate data into clear takeaways that non-analysts can act on
Document your work; build reports and models that others can use and update — not black boxes that only you understand
Serve as the Digital Wholesale team's primary partner to the DTC Business Intelligence team; stay connected to their work, understand their data models, and identify where digital wholesale and DTC data can tell a unified story
Participate in cross-functional BI discussions; bring the wholesale and Amazon perspective into conversations about enterprise reporting standards, shared KPIs, and data infrastructure
Align on metrics definitions and reporting methodology with the DTC BI team; inconsistent definitions across channels create confusion at the leadership level — be the person who catches and resolves those gaps
Share what you are building with the DTC BI team and learn from what they have already built; do not recreate infrastructure that already exists
Flag opportunities where a combined DTC and wholesale data view would improve decision-making; bring the idea, sketch the use case, and help make it happen
Ask questions before assuming — if a number looks off, dig in; if a trend is unexpected, find out why before reporting it
Come to every conversation with a point of view on what the data says; do not just present the numbers, tell the team what they mean
Bring solutions, not problems; if you find a gap in the data, a broken report, or a missing metric, propose how to fix it
Treat every dataset as a puzzle — the most valuable insights are usually the ones nobody thought to look for
Qualification
Required
Bachelor's degree in business, analytics, economics, statistics, information systems, or a related field; recent graduates are encouraged to apply
Advanced proficiency in Microsoft Excel; you are comfortable with pivot tables, VLOOKUP/XLOOKUP, INDEX MATCH, dynamic arrays, and building models that other people can use
Working knowledge of SQL; you can write basic to intermediate queries to pull and filter data from a database — coursework, personal projects, or internship experience all count
Familiarity with at least one BI or data visualization tool (Google Data Studio, Looker, Power BI, Tableau, or comparable); you have built a dashboard or a report that someone else relied on
Genuine curiosity about data; you do not just answer the question asked — you look around it, behind it, and ahead of it
Entrepreneurial mindset and bias for action; you take initiative, find a way forward, and do not wait to be told what to do next
Strong problem-solving instincts; you break down ambiguous questions, work through them systematically, and come back with a clear answer
Active AI enthusiast; you already use AI tools in your work or studies and are excited about what they can do for analytics and reporting
Located in or able to commute to the New York Metro area; on-site presence required
Preferred
Internship or project experience in e-commerce, retail, wholesale, or a data-heavy business environment
Exposure to Amazon Vendor Central, Seller Central, or retail media reporting; familiarity with metrics like glance views, TACOS, or unit session percentage is a plus
Experience with Python or R for data manipulation; not required, but a sign you are serious about analytics
Comfort working in fast-moving, ambiguous environments where the process is still being built
Benefit
Health and dental insurance
Life insurance
Disability insurance
401K
Paid holidays
A generous paid time-off policy
Career opportunities within a dynamic team
Steve Madden is a designer and marketer of fashion footwear, accessories, and apparel.
