Save Job
Posted 3h ago

Data Analyst, Data Pipeline

@ SPINS
Chicago or United States
$55k-$60k/yrHybridFull Time
Responsibilities:extracting data, transforming data, normalizing data
Requirements Summary:Bachelor's degree preferred; attention to detail; familiarity with Excel, JSON, relational databases; able to design and improve data extraction and classification processes.
Technical Tools Mentioned:Microsoft Excel, BigQuery, SQL, JSON, Microsoft Power BI
Job Description

Who We Are

For over 20 years, SPINS has been a leader in recognizing the transformative power of data in retail. We offer our clients cutting-edge tools to attract attention from a fast-growing segment within the Health & Wellness industry, the values-based consumer. Nearly half of shoppers prioritize products that emphasize wellness, social responsibility, and sustainable practices. SPINS retail consumer insights, analytics, and consulting services give our clients a competitive advantage to increase their share of this growing market. Our data is the most comprehensive and accurate in the industry, allowing clients to power AI models and machine learning algorithms that help them better understand and meet their customers' needs. At SPINS, behind all of our impressive data is our real differentiator, our people. We pride ourselves on our collaborative, flexible, and communicative culture that puts people at the center of everything we do.

Data Analyst, Data Pipeline

Our Product Intelligence data pipeline is continually onboarding and analyzing a massive amount of new food, nutrition, and consumer products onto our platform. This requires ongoing data attribute creation, analysis, data accuracy, and maintaining rigorous food, nutrition, and product data standards and attribution.

To support our data pipeline, the Data Analyst, Data Pipeline, operates as part of the team responsible for extracting, transforming, and delivering data from multiple sources within the Product Intelligence (PI) ecosystem. This role supports the PI group’s needs around the Tasker tool. Tasker is the core technology the PI Engine uses to collect, extract, and deliver data to different endpoints, leveraging a variety of data collection services: automations (data science), internal product research team, external MTurkers.

To do this work, the Analyst will use a variety of tools and data languages (such as Excel, BigQuery, SQL, JSON, and others). They will use those tools to review large product datasets, design data extraction workflows, and to optimize our out data extraction processes. This role will also work on the data transformations and mappings needed to deliver our Product Intelligence datasets to a variety of end recipients (both internal and external consumers of the data).

This role will work cross-functionally with a variety of team members across data operations, data pipeline, R&D, data quality, and customer support. These interactions will have a focus on continually improving our Product Intelligence attribute offerings, accuracy, and overall data quality.

Product Intelligence data is the fuel for SPINS programs and the backbone of SPINS health & wellness insights. As such, Product Intelligence is one of the major pillars of SPINS and therefore it is essential to our success that this role upholds the tenets of data harmonization, attribute data creation and adherence to quality standards, continuous process improvement, and increases the overall quality across our data pipeline processes. This role is an excellent entry point for exposure to the world of big data for health and wellness CPG.

Qualifications Required:

  • Bachelor’s degree, preferably in Science, Computer Science, Data Analytics, Data Science, Statistics, Engineering, Business or Food Science
  • Strong attention to detail, with ability to analyze large volumes of product data to draw insights, guide product classifications, improve attribution, and support cross-organizational projects
  • Familiarity with Excel, JSON, relational databases, and/or other data management tools
  • A detailed-oriented, process-driven mindset used to identify, measure, and improve data classification processes
  • Adept at learning new technologies and business functions, working proactively to problem solve and take initiative
  • Ability to understand and interpret simple coding language, database infrastructure, and data structures
  • Self-motivated; able to work effectively in a fast-paced environment under pressure, adhering to deadlines
  • Ability to work independently as well as part of a cross-functional team

Qualifications Desired:

  • Minimum 1-2 years’ experience in related field
  • Exposure to retail or consumer packaged goods data
  • Familiarity with business intelligence data applications (e.g. PowerBI, etc.) and SQL or JSON languages
  • Experience/familiarity in food, dietary supplements, or personal care product labeling/regulatory knowledge, specifically health and wellness products

Essential Functions and Responsibilities:

  • Use a variety of data tools to develop, test, and implement data extraction processes
  • Clean, normalize, and transform extracted data into a standard format to be used across our databases, applications and tools
  • Identify any data issues, analyze the root cause and implement the fix to prevent recurrence
  • Work with key stakeholders to proactively identify opportunities to improve or expand existing pipelines and systems
  • Assist and participate in developing and implementing standard operating procedures (SOPs) for PI workflows and processes
  • Manage MTurk workers by monitoring performance, providing timely feedback and coaching
  • Generate and communicate status on assigned tasks and projects
  • Handle competing priorities and heavy project workloads

Salary Range: $55,000 to $60,000

Note: Applicants must be authorized to work for any US employer. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

#LI-AC1 #LI-Hybrid

What SPINS Offers

We have enjoyed tremendous growth over the years and, as a leader in a fast-growing industry, we have no plans to slow down!  While all that growth brings excitement, it is also an opportunity for SPINS to show it values the health and wellness of its team members. 

  • We embrace hybrid work options so that you have the flexibility to create a work/life balance that actually works!
  • Each employee is allotted paid time to use to volunteer with an organization of their choice and charitable donations are matched.
  • Semi-annual company-wide employee survey that is used to shape company programs, perks, and culture.

  The SPINS Way

  • Direct – We communicate with clarity, honesty and respect in all situations and embrace opportunities to provide solution-oriented feedback.
  • Determined – We are committed to overcoming all obstacles to achieve results. We adapt to change, seek opportunities to learn and rapidly translate that learning into action.
  • Passionate – We go above and beyond to help our partners achieve their goals. We challenge assumptions and are comfortable forging new paths.
  • Collaborative – We leave our egos at the door, believing that working together we will produce an outcome that’s greater than each individual contribution.

For details about the information SPINS’s collects about our applicants and how we use it, please see the SPINS Privacy Policy here.