Analytics Engineer at Sprout Social

| Chicago | Remote
Sorry, this job was removed at 6:07 a.m. (CST) on Sunday, October 17, 2021
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.
At Sprout Social, we build software used by 30,000 companies to create stronger relationships with their customers and create the world's most beloved brands. As a SaaS product used 24/7/365 by organizations of all sizes, sectors, and geographies, we consume and generate vast amounts of data which hold great potential to improve our business and products.
Our Data Science and Analytics team empowers stakeholders across Sprout to access data to drive their decision making. Our warehousing systems touch and are used by all parts of Sprout's business, and our team plays a central role in ensuring the quality, accuracy, and visibility of that data. Our team uses a variety of technologies, including SQL, Python, Redshift, Airflow, DBT, Great Expectations and Git.
We're building diverse, collaborative teams that get the best results sustainably. Embedded within the Data Science and Analytics team, you will work with business stakeholders, analysts, and data engineers to ensure that Sprout's business gets access to timely and accurate data to drive decision making and reporting. Relying on your experience with data warehousing and writing SQL, you will gather business requirements and translate them into well-documented, tested and accurate data artifacts.
We're looking for a collaborative, organized, detail-oriented, motivated, and inquisitive learner to help take our data warehousing game to the next level. If you confidently write SQL, translate business requests into data artifacts, are comfortable communicating with both engineers and business stakeholders, and are passionate about learning, we'd love to talk with you!
Qualifications
These are the minimum qualifications that our hiring team is looking for in this role:
  • 4+ years in the Data space as an analyst, engineer, or equivalent.
  • 2+ years experience designing, implementing, operating, testing, and extending data models in a relational database
  • 2+ years of experience working with both technical and business stakeholders to achieve consensus in defining data warehousing requirements.
Additionally, these are the preferred qualifications that would indicate a particularly strong candidate:
  • Experience with our tech stack: Git/Github, DBT, Redshift, Python, Jupyter Notebooks, Great Expectations, & Amundsen (or equivalent metadata management tool).
  • 2+ years experience building reports and dashboards in a data visualization tool.
  • 1+ years creating project plans to identify tasks, milestones, and deliverables.
Within 1 month, you will:
  • Complete Sprout's New Hire training program alongside other new Sprout team members.
  • Learn about Airflow, DBT, and the rest of our data stack supporting our ETL and ELT processes.
  • Pair with our data engineers and business analysts to understand the systems we have for publishing data.
  • Become familiar with data sources available in our data lake.
Within 3 months, you will:
  • Leverage Data Build Tool (DBT) and internal tools to add data sources to our production data warehouse.
  • Write tests against existing data sources using Great Expectations.
  • Begin documenting information about our warehouse data sources including lineage and data definitions in our metadata management system.
  • Work with data engineers and our analytics manager to help re-architect critical portions of our data warehouse.
  • Establish relationships with business stakeholders to understand their domain and data needs.
Within 6 months, you will:
  • Work with business stakeholders and analysts to create and/or update existing data sources for their reporting and analysis needs.
  • Execute on reorganizing parts of our data warehouse.
  • Serve as on-call for support rotations.
  • Leverage tests you and others have written to monitor data flowing through our systems.
  • Continue to document and develop tests to monitor and alert on critical data sources in our warehouse.
  • Form a career growth plan with your manager and work towards it.
Within 12 months, you will:
  • Expand your skills by learning from data engineers, analysts, and data scientists around Sprout.
  • Own one or more stakeholder relationships.
  • Serve as a subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately
  • Take ownership over the data flowing through our event-tracking systems by helping establish and refine governance practices and coordinating with engineering.
  • Find new opportunities for improving data integrity, visibility and accessibility.
  • Guide and educate other data users around Sprout to self-serve their data needs.
  • Surprise us! Use your unique ideas and abilities to change your team in beneficial ways that we haven't even considered yet.
Of course what is outlined above is the ideal timeline, but things may shift based on business needs and other projects and tasks could be added at the discretion of your manager.
About Sprout Social
Sprout Social powers open communication between individuals, brands and communities through elegant, sophisticated software. We are relentless about solving hard problems for our customers and committed to both customer and team success. Our team's shared belief in Sprout's mission promotes a culture of openness, empowerment and fun.
We're proud to regularly be recognized for our team, product and culture. Our benefits program includes:
  • Insurance and benefit options that are built for both individuals and families
  • Progressive policies to support work/life balance, like our flexible paid time off and parental leave program
  • High-quality and well-maintained equipment-your computer will never prevent you from doing your best
  • Wellness initiatives to ensure both health and mental well-being of our team
  • Ongoing education and development opportunities via our [email protected] program, employee-led diversity, equity and inclusion initiatives and mentorship programs for aspiring leaders
  • Growing corporate social responsibility program that is driven by the involvement and passion of our team members
  • Beautiful, convenient and state-of-the-art offices in Chicago's Loop and downtown Seattle, for those who prefer an office setting
Whenever possible, Sprout wants to provide our team with the flexibility to work in the location that makes the most sense for them. For those that prefer an office setting, this role may be based in our Chicago or Seattle locations. If you prefer to work from your home, we can accommodate that for many locations across the United States. We are not set up in all states, however, so please take a look at the drop down box in our application to see whether your state is listed.
Sprout Social is proud to be an Equal Opportunity Employer and an Affirmative Action Employer. We do not discriminate based on identity-
race, color, religion, national origin or ancestry, sex (including sexual identity), age, physical or mental disability, pregnancy, veteran or military status, unfavorable discharge from military service, genetic information, sexual orientation, marital status, order of protection status, citizenship status, arrest record or expunged or sealed convictions, or any other legally recognized protected basis under federal, state, or local law. Learn more about our commitment to diversity, equity and inclusion in our 2021 DEI Report.
If you need a reasonable accommodation for any part of the employment process, please contact us by email at [email protected] and let us know the nature of your request and your contact information. We'll do all we can to ensure you're set up for success during our interview process while upholding your privacy, including requests for accommodation. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
For more information about our commitment to equal employment opportunity, please click here (1) Equal Opportunity Employment Poster (2) Sprout Social's Affirmative Action Statement (3) Pay Transparency Statement.
When you apply for employment with Sprout Social, we will process your job applicant data, including your employment and education history, transcript, writing samples, and references as necessary to consider your job application for open positions. For more information about our privacy practices please visit our Privacy Policy. California residents have additional rights and should review the Additional Disclosures for California Residents section in our Privacy Policy.
Additionally, Sprout Social participates in the E-Verify program in certain locations, as required by law.
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
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • SwiftLanguages
    • D3JSLibraries
    • ReactLibraries
    • ReduxLibraries
    • DjangoFrameworks
    • HadoopFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • MySQLDatabases
    • RedisDatabases
    • SalesforceCRM

Location

131 S Dearborn, 7th Floor, Chicago, IL 60603

An Insider's view of Sprout Social

What’s the vibe like in the office?

We are invited to bring our authentic selves to work. The result is a culture without pretense.

Aja Saunders

Receptionist Systems Specialist

What's the biggest problem your team is solving?

The Growth Activation squad is focused on the challenge of retaining trial users and converting them into subscribers. We find solutions by A/B testing our features, using data science for quantitative analysis, using user interviews for qualitative analysis and working with other teams at Sprout on Growth strategies.

Andrew Kos

Senior Software Engineer

How has your career grown since starting at the company?

When I first joined Sprout, I could count the entire Sales team on one hand. Since then, my career has taken a variety of paths, from training and enablement to assisting our Sales team from a strategic perspective as a Solutions Engineer. Thanks to a workplace environment that fosters growth, I’ve been able to advance my career at Sprout.

Jordan Balkin

Solutions Engineer, Sales & Success

How do you empower your team to be more creative?

Instead of turning down ideas that seem unattainable, we encourage our teams to think through how we can solve challenges in unique ways. By testing and experimenting, we create an environment that fosters innovation and promotes creative thinking.

Jamie Gilpin

CMO

What's something quirky about your company?

At the conclusion of our company wide Kickoff party, tubs of McDonalds cheeseburgers mysteriously appear and rain down on us like a blizzard in the Chicago winter. But a good blizzard.

Molly Jones

Senior Employee Experience Manager

What are Sprout Social Perks + Benefits

Sprout Social Benefits Overview

We’re proud to regularly be recognized for our team, product and culture. Our benefits program includes:

- Insurance and benefit options that are built for both individuals and families
- Progressive policies to support work/life balance, like our flexible paid time off and parental leave program
- High-quality and well-maintained equipment—your computer will never prevent you from doing your best
- Wellness initiatives to ensure both health and mental well-being of our team
- Ongoing education and development opportunities via our [email protected] program, employee-led diversity, equity and inclusion initiatives and mentorship programs for aspiring leaders
- Growing corporate social responsibility program that is driven by the involvement and passion of our team members
- Beautiful, convenient and state-of-the-art offices in Chicago’s Loop and downtown Seattle, for those who prefer an office setting

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Documented equal pay policy
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity manifesto
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available
Customized development tracks
More Jobs at Sprout Social1 open job
All Jobs
Sales
Sales
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Sprout Social's full profileSee more Sprout Social jobs