Sprout Social is looking for a Senior Analytics Engineer to join its Data Science and Engineering team.

Why join Sprout’s Data Science and Engineering team? 

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 Engineering 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, visibility, and usability of that data. Our team uses a variety of technologies, including SQL, Python, Redshift, Airflow, DBT, Great Expectations and Git.

What you’ll do

• Embedded within the Data Science and Engineering team, you will work with our business partners, 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. 
• Leveraging your experience with dimensional data modeling, you will help refine and define the path towards a more mature data warehousing capability to empower Sprout’s business and enable ever-growing size and uses of our data. 
• You will help Sprout’s broader data community to leverage the power of our data by mentoring analysts about SQL, DBT, and data modeling, attending office hours, presenting in our Data Analysis and Visualization guild meetings, and help create and maintain content to educate Sprout’s broader analytics community.

What you’ll bring

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, are familiar with dimensional data modeling, and are passionate about learning, we’d love to talk with you!

The minimum qualifications for this role include:

• 4+ years in the Data space as an analyst, engineer, or equivalent.
• 3+ years experience designing, implementing, operating, testing, and extending data models.
• 3+ years of experience working with both technical and business stakeholders to achieve consensus in defining data warehousing requirements. 
• Familiarity with Dimensional modeling concepts for data warehousing.

Preferred qualifications for this role include:

• Experience with cloud data warehousing technologies such as Redshift and experience tuning SQL to leverage the underlying database.
• Demonstrated ability to analyze, reverse engineer, and optimize existing SQL.
• 2+ years managing projects, including helping define deliverables, breaking down tasks and milestones, and communicating expectations to stakeholders. 
• Experience with our tech stack: Git/Github, dbt, Redshift, Python, Jupyter Notebooks, Great Expectations, & Amundsen (or equivalent metadata management tool).
• Experience mentoring or coaching others around SQL and data modeling.
• 2+ years experience building reports and dashboards in a data visualization tool and/or leveraging Python to analyze and manipulate data. 
• Experience working with CRM data, such as Salesforce or Hubspot.

How you’ll grow

Within 1 month, you’ll plant your roots, including:

• Completing Sprout’s New Hire training program alongside other new Sprout team members.
• Learning about Airflow, DBT, and the rest of our data stack supporting our ETL and ELT processes.
• Pairing with our data engineers and analytics engineers to understand the systems we have for publishing data.
• Becoming familiar with data sources available in our data lake.

Within 3 months, you’ll start hitting your stride by:

• Leveraging Data Build Tool (DBT) and internal tools to add data sources to our production data warehouse.
• Writing tests against existing data sources using Great Expectations.
• Shadowing support rotations and office hours to learn how to manage our systems and help educate and support our partners around the business. 
• Beginning documenting information about our warehouse data sources including lineage and data definitions in our metadata management system.
• Working with data engineers and our analytics manager to help re-architect critical portions of our data warehouse.
• Establishing relationships with business stakeholders and analysts to understand their domain and leverage that knowledge to create and/or update existing data sources for their reporting and analysis needs.

Within 6 months, you’ll be making a clear impact through:

• Executing on reorganizing parts of our data warehouse using dimensional data modeling techniques.
• Serving as on-call for support rotations and participating in office hours. 
• Creating content that helps educate end-users about our data resources and how to use them. 
• Leveraging tests you and others have written to monitor data flowing through our systems.
• Continuing to document and develop tests to monitor and alert on critical data sources in our warehouse.
• Forming a career growth plan with your manager and work towards it.

Within 12 months, you’ll make this role your own by:

• Expanding your skills by learning from data engineers, analysts, and data scientists around Sprout.
• Owning one or more stakeholder relationships.
• Serving as a subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately.
• Taking ownership over the data flowing through our event-tracking systems by helping establish and refine governance practices and coordinating with engineering.
• Finding new opportunities for improving data integrity, visibility and accessibility.
• Guiding and educating 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.

Our Benefits Program

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 and  employee-led diversity, equity and inclusion initiatives.
• 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. Sprout maintains a remote workforce in many places in the United States. However, we are not set up in all states, so please look at the drop-down box in our application to see whether your state is listed. Few roles require an office setting. If your position requires a physical presence in a Sprout office, it will be evident in the job listing and your offer letter.

The base pay range for this role is $110,000 - $125,000 USD annually. Individual base pay is based on various factors, including relevant experience and skills, the responsibility of the role, and job duties/requirements. In addition to base pay, some Sales and Success roles can earn sales incentives.

Sprout’s compensation ranges are intentionally broad to allow for our team members' growth within their role. These ranges were determined by a market-based compensation approach; we used data from trusted third-party compensation sources to set equitable, consistent and competitive ranges. We also evaluate compensation bi-annually, identify any changes in the market and make adjustments to our ranges and existing employee compensation as needed.

Base pay is only one element of an employee's total compensation at Sprout. Every Sprout team member has an opportunity to receive restricted stock units (RSUs) under Sprout’s equity plan. Employees (and their dependents) are covered by medical, dental, vision, basic life, accidental death, and dismemberment insurance, and Modern Health (a wellness benefit).  Employees are able to enroll in Sprout’s company’s 401k plan, in which Sprout will match 50% of your contributions up to 6% with a maximum contribution. Sprout offers “Flexible Paid Time Off” and ten paid holidays. We have outlined the various components to an employee’s full compensation package here to help you to understand our total rewards package.

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 accommodations@sproutsocial.com 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.

#LI-REMOTE