Data Engineer

| Chicago, IL +50 more | Remote | Hybrid
Sorry, this job was removed at 8:25 p.m. (CST) on Sunday, November 7, 2021
Find out who's hiring in Chicago, IL.
See all Data + Analytics jobs in Chicago, IL
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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.
Relying on your experience with data warehousing and writing ETL pipelines, you will enable analytics and data science teams to provide critical insights and new product features to Sprout. Our systems touch and are used by all parts of Sprout's business, from integrating data from across Sprout's varying databases and partner APIs, to creating and maintaining the event service leveraged by Sprout's product teams. Our team uses a variety of technologies, including Python, Java, Spark, Redshift, Airflow, EMR, Elasticsearch, Docker, and Kinesis.
We're building diverse, collaborative teams that get the best results sustainably. Embedded as a member of the data science and analytics team, you will work in tandem with data analysts, data scientists and business stakeholders to define requirements for data warehousing and services. As a data engineer, you will ensure business stakeholders and data scientists get the data they need to drive reporting, analytics and machine learning at Sprout.
We're looking for a creative, collaborative, highly motivated, and inquisitive learner to build great software with us. If you confidently write data pipelines and warehouses that process and store terabytes, can write Python or Java-based services to serve up data, 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:

  • 2+ years working as a data engineer, including building and maintaining ETL pipelines and data warehousing.
  • 2+ years conducting software development in Python and/or Java
  • Advanced SQL proficiency and experience with relational and non-relational databases.

Additionally, these are the preferred qualifications that would indicate a particularly strong candidate:

  • Programmatic development of ETL pipelines through software such as Airflow, Luigi, etc.
  • Experience using and deploying to cloud-based platforms such as AWS, Azure or Google Cloud.
  • Experience working with data scientists, analysts and other business stakeholders to define data warehousing needs.
  • Comfort with Git and the Linux command line.

Within 1 month, you will:

  • Complete Sprout's New Hire training program alongside other new Sprout team members.
  • Become familiar with data sources available in our data lake.
  • Learn about Airflow and our ETL processes.
  • Pair with our data engineers to learn about the libraries and processes owned by data engineering.
  • Begin meeting with data science and business analytics stakeholders to understand existing responsibilities and needs.

Within 3 months, you will:

  • Add data sources to our production data warehouse.
  • Modify and/or write new data pipelines using Airflow and push them to production.
  • Become familiar with our Java-based service used to store and process all events produced by Sprout's products.
  • Work with data science and business stakeholders to develop technical requirements for new data sources and services.

Within 6 months, you will:

  • Contribute to the development of new tooling to make it easier to pipe data between internal systems and external services.
  • Serve as on-call for support rotations.
  • Help deploy and manage software to make it easier analysts and analytics engineers to transform, manage, and provide visibility into data
  • Take ownership and improve existing ETL jobs in Airflow, processing hundreds of millions of data points a day.
  • Develop data processing pipelines using EMR and Spark.
  • Help develop and expand processes for monitoring and alerting around our data warehouse, ETL jobs and services.
  • Form a career growth plan with your manager and work towards it.

Within 12 months, you will:

  • Help develop new frameworks and libraries to allow stakeholders around Sprout to iterate more quickly on new ETL and data sources.
  • Help improve our existing deployment procedures.
  • Identify technical debt and performance bottlenecks within our systems, come up with a plan to improve the code, and get it pushed to production.
  • Create processes to improve the integrity of data stored in our data warehouse.
  • Expand your skills by learning from other engineers around Sprout.
  • Optimize Redshift tables for use in serving data into Tableau dashboards and data science models used by the whole company.
  • 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 Grow@Sprout 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
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Candidate Location Eligibility:
Ann Arbor, MI
Atlanta, GA
Austin, TX
Baltimore, MD
Boston, MA
Buffalo, NY
Charleston, SC
Charlotte, NC
Chicago, IL
Cincinnati, OH
Cleveland, OH
Columbus, OH
Dallas-Fort Worth, TX
Dayton, OH
Des Moines, IA
Detroit, MI
Greensboro, NC
Houston, TX
Indianapolis, IN
Jacksonville, FL
Kansas City, MO
Madison, WI
Memphis, TN
Miami, FL
Milwaukee, WI
Minneapolis–Saint Paul, MN
Nashville, TN
New York City, NY
Ogden, UT
Orlando, FL
Pensacola, FL
Peoria, IL
Philadelphia, PA
Phoenix – Mesa – Scottsdale, AZ
Pittsburgh, PA
Portland, ME
Portland, OR
Provo, UT
Raleigh-Durham, NC
Rochester, NY
Salt Lake City, UT
San Antonio, TX
Seattle, WA
Spokane, WA
St. Louis, MO
Tallahassee, FL
Tampa Bay, FL
Tucson, AZ
Washington DC
Wilmington, NC

Technology we use

  • Engineering
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • SwiftLanguages
    • D3JSLibraries
    • ReactLibraries
    • ReduxLibraries
    • DjangoFrameworks
    • HadoopFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • MySQLDatabases
    • RedisDatabases
    • SalesforceCRM

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 Grow@Sprout 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
Open door policy
OKR operational model
Team based strategic planning
Pair programming
Open office floor plan
Employee resource groups
Hybrid work model
President's club
Remote work program
Diversity
Documented equal pay policy
Dedicated diversity and inclusion staff
Mandated 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 insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Company equity
Employee stock purchase plan
We provide the opportunity for U.S. employees to purchase stock at a discounted price and share in the potential financial success and growth of the company.
Child Care & Parental Leave Benefits
Generous parental leave
Family medical leave
Vacation & Time Off Benefits
Unlimited vacation policy
Generous PTO
Paid volunteer time
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Free daily meals
Free snacks and drinks
Company-sponsored happy hours
Fitness stipend
Home-office stipend for remote employees
Onsite gym
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Mentorship program
Online course subscriptions available
Customized development tracks

More Jobs at Sprout Social

Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Sprout SocialFind similar jobs like this