Senior SQL Data Analyst, DAAP at SPINS LLC

| Chicago
Sorry, this job was removed at 11:13 a.m. (CST) on Thursday, May 9, 2019
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
DAAP - Data Agnostic Analytics Platform
  • Data Harmonization
  • Data Customization
  • Data Analytics
  • Custom Platform Delivery

We help clients solve Big Data Constraints.

DAAP integrates data sources (SPINS, IRI, Nielsen, Whole Foods Market, Costco, Amazon, and more) into a single platform that provides one common view of category hierarchies and brand/sub-brand structures. We build a custom harmonized database that cleans and integrates the data so it can be used for the development of insights and tactical, strategic recommendations. We are looking to add a Sr. SQL Data Analyst to our team.

Responsibilities:

  • You will be responsible for assisting and managing weekly tasks to include but not limited to the following:
    • Existing SQL process maintenance
    • SQL process enhancements
    • Production process automation
  • You will be responsible for assisting and managing monthly tasks to include but limited to the following:
    • Support monthly production data ingestion
    • Monthly data extraction processing
  • You will assist in the development of our next generation data engine. This will be a dynamic, database driven SQL engine utilizing the Google Big Query database platform.
  • The new data engine will include the following focus, but not limited to:
    • Data ingestion engine
    • Data processing engine
    • Data extraction engine
    • Data acquisition processes
    • Data scrubbing processes

Qualifications:

  • Proven capabilities, including 4+ years of work experience
  • Experience with key business concepts/analysis and working knowledge of the CPG/Retail industry is highly desirable
  • Strong emphasis on SQL
  • Must haven proven database experience. SQL Server, MySQL, Oracle, and/or Big Query (big plus)
  • Experience with Denormalized data
  • Experience with large data sets, data shaping and data processing
  • Experience with scripting languages such as Python and/or Powershell for automated processes and scalability
  • Experience with Linux and Windows
  • Preferred experience with Excel, Tableau, R, Google Cloud Platform, Alteryx, Machine Learning and programming (Java, Python, .NET, VBA)
  • Experience capturing and translating business requirements into technical solutions
  • Strong communication skills with the ability to collaborate with individuals with varying levels of technical abilities
  • Ability to work independently in a fast-paced environment
  • Motivated, results driven attitude

Perks:

  • Health, dental and vision insurance
  • 401k (Traditional and Roth) plus company match
  • FSA for medical and dependent care expenses
  • Pre-tax commuter benefit
  • Life insurance
  • Short- and long-term disability
  • Paid maternity and paternity leave
  • Bike storage
  • Fresh and healthy snacks
  • Vibrancy 360 Wellness Program: Yoga and fitness classes, onsite massage, volunteer opportunities, company happy hours, product demos, outings, and more.
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • ScalaLanguages
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • ConfluenceManagement
    • JIRAManagement
    • SalesforceCRM

Location

We are just steps from the Merchandise Mart, located in the bustling River North neighborhood of Chicago.

An Insider's view of SPINS LLC

What’s the vibe like in the office?

The beauty of our mission lies in the fact that we're impacting all consumers to live healthier and more vibrant lives, and this transcends to our own team members within the office. With our mission in mind, we cultivate an office environment and culture where we support team members to live their best lives.

Rosemary

Chief People Officer

How do you collaborate with other teams in the company?

If you work on the QA engineering team, you will learn about all of our different products and work with the various development and product intelligence teams that make up SPINS. You will gain an understanding of how our company works from end to end.

AJ Rudolph

Manager, Data and Software Quality

How has your career grown since starting at the company?

Over the years, I've worked for both corporate and not for profit organizations and SPINS feels the most nurturing and organic. Individuals and teams are empowered to define a path to success. If you are curious and passionate, you can forge multi-disciplinary partnerships & make a difference beyond the boundaries of your specific department/role.

Andrea

Senior Product Owner

What makes someone successful on your team?

We bring creativity to obstacles, living principles that drive innovation. We work smart; always striving and learning. We want you to chime in. We want you to be you. We're diverse, confident, collaborative, and unafraid. We don't punish progress which sometimes takes two steps back. We refactor. We're quality, at velocity.

Troy

Chief Technology Officer

What are SPINS LLC Perks + Benefits

Culture
Volunteer in local community
Eat lunch together
Intracompany committees
Group brainstorming sessions
Pair programming
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Sabbatical
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Happy Hours
Professional Development Benefits
Lunch and learns
Cross functional training encouraged
Promote from within

Additional Perks + Benefits

Paid Maternity & Paternity Leave: SPINS provides six weeks of paid maternity leave (or more broadly speaking, primary caregiver leave), and six weeks of paid paternity leave (or secondary caregiver leave).

Flexible Schedule: Our teams offer flexible options to serve business goals and accommodate personal needs.

Full access to SPINS’ comprehensive wellness program "Vibrancy 360" which includes: chef led cooking demonstrations, yoga, natural/organic fare in kitchens, office gym with personal training sessions, running club, volunteer opportunities, massages, meditation, in-office happy hours

More Jobs at SPINS LLC7 open jobs
All Jobs
Dev + Engineer
HR
Project Mgmt
Sales
Developer
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Sales
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView SPINS LLC's full profileSee more SPINS LLC jobs