Madewell Data Engineer

Location: Long Island City, NY 11101

*** Mention DataYoshi when applying ***

Data Engineer
(Reports to Head of Data and Analytics)

You’ve got to…

  • Get us – a passion for the brand that shows up in everything you do, everyday.
  • Be a strategic thinker – spend time and energy on what drives the greatest results.
  • Look under rocks, be curious, ask questions and use your smarts to think boldly and do the right thing.
  • Be a team player – cultivate productive relationships with cross-functional business partners.
  • Communicate consistently, with purpose and an understanding of your audience.
  • Be a multi-task master – make quick decisions under tight timelines.
  • Be nimble and comfortable with change.
  • Work independently and take the lead, even when all of the pieces are not in place.
  • Articulate your point of view and have the courage and conviction to stand up for your beliefs.
  • Have a great fashion esthetic and be all over what’s happening in the industry.
  • Always be on, up for anything and ready to have fun along the way.

We want you to…

  • Translate business requirements into effective and resilient data pipelines and data models
  • Implement best practices to ensure data quality throughout our data pipelines and integrations
  • Recommend improvements and modifications to existing data integrations and ETL/ELT
  • Handle various data formats including structured (databases) and semi-structured (XML, JSON, csv)
  • Design and develop scalable, high performing data models for a wide range of business groups, including Store Operations, Financial Planning, Allocation, Merchandising, Web and Marketing
  • Forge a strong partnership with our business stakeholders to ensure success of data initiatives
  • Evangelize a data-driven culture and processes using modern tools and methodologies
  • Administer Snowflake database and data orchestration tools
  • Strive to implement data governance throughout the enterprise
  • Identify operational data issues and recommend strategies to resolve data problems.
  • Resolve critical data issues as they arise
  • Have experience designing and developing enterprise data warehouses
  • Be able to work with minimum supervision and proactively prioritize tasks

Oh, and by the way, you…

  • Have a bachelor’s degree. Preferred bachelor’s degree in a Technical Field;
  • 4+ years of experience in the data warehouse space in hands-on roles
  • 4+ years of experience in writing complex SQL and ETL/ELT processes, preferably in a retail, brand manufacturing or consumer-facing company
  • 4+ years of experience with schema design and dimensional data modeling
  • 1+ years of experience with object-oriented programming languages, like Java or Python
  • Preferred experience in a retail, CPG or e-commerce company

We are committed to affirmatively providing equal opportunity to all associates and qualified applicants without regard to race, color, ancestry, national origin, religion, sex, marital status, age, sexual orientation, gender identity or expression, legally protected physical or mental disability or any other basis protected under applicable law.

*** Mention DataYoshi when applying ***