Senior SQL Data Analyst, DAAP

| Chicago

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
loading ...
Emailed

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

How do you collaborate with other teams in the company?

If you work on the engineering team, you get to understand the end to end process. You are not siloed to one team, you can move into areas you’re interested in. It helps you understand the business

Subha Adusumalli

Engineering Manager

How has your career grown since starting at the company?

I’ve worked with corporate companies for many years and I really love the organic feel of SPINS. I have opportunities and encouragement to do what I need to do to get my work done. If you’re willing to put in time and work hard and passionate, you can do so much more than your job, I get to touch so many things.

Janice Yee

Senior Software Engineer

What are SPINS LLC Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
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
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Happy Hours

Additional Perks + Benefits

Paid Maternity & Paternity Leave: SPINS provides six weeks of paid maternity leave (or more broadly speaking, primary caregiver leave), and two 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 LLC15 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Product
Sales
Design + UX
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
HR
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago