Senior Data Engineer

| Chicago | Hybrid
Sorry, this job was removed at 12:09 p.m. (CST) on Wednesday, March 4, 2020
Find out who's hiring remotely in Chicago.
See all Remote Data + Analytics jobs in Chicago
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 20,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. We’re looking for a passionate data engineer to contribute to our data engineering practice within the data analytics and data science teams to ensure business stakeholders and data scientists get the data they need to drive reporting, analytics and machine learning at Sprout.

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

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!

We’re looking for Data Engineers that have a great track record of:

  • Building and maintaining ETL pipelines and data warehousing.
  • Conducting software development in Python and/or Java, owning the entire development lifecycle, from development and testing, to deployment, monitoring and maintenance.
  • Experience with relational and non-relational databases.
  • 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. 

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 other senior data engineer to learn about the libraries and processed owned by data engineering.
  • Begin meeting with data science 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:

  • Develop data processing pipelines using EMR and Spark.
  • Serve as on-call for support rotations.
  • Take ownership and improve existing ETL jobs in Airflow, processing hundreds of millions of data points a day.
  • Help develop 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 the data science team to iterate more quickly on new ETL and data sources.
  • Own the event-generation service used across Sprout’s products.
  • 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.

Optional: When applying, please share work samples, projects, or publications.

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.

Team Sprout is a group of very talented, smart and passionate people with broad interests and backgrounds. We’re proud to regularly be recognized for software, product and company culture achievements. Our team’s shared belief in Sprout’s mission promotes a culture of openness, empowerment and fun. We have built a benefits program to match the strength of our team. This program includes:

  • Insurance and benefit options that are built for both individuals and families, including generous company contributions
  • Progressive benefit programs, like our parental leave program 
  • High-quality and well-maintained equipment - your computer will never prevent you from doing your best
  • Beautiful, convenient and state-of-the-art offices in Chicago and Seattle
  • Solid programs in some of the staples: transportation, disability and life insurance
  • Wellness initiatives to ensure both health and financial well-being of our team
  • Breakfast and lunch options onsite, and more healthy snack options and beverages than you can imagine
  • Growing corporate social responsibility program that is driven by the involvement and passion of our team members

Sprout Social is proud to be an Equal Opportunity Employer and an Affirmative Action Employer. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, genetic information, marital status, order of protection status, citizenship status, or other applicable legally protected characteristics. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law. 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. Requests for accommodation will be considered on a case-by-case basis. 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. We value the things that make us different and want to see how you can make our team better!

Read Full Job Description
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • SwiftLanguages
    • D3JSLibraries
    • ReactLibraries
    • ReduxLibraries
    • DjangoFrameworks
    • HadoopFrameworks
    • 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 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
Flexible work schedule
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
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
Some meals provided
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
Continuing education available during work hours
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