Senior Analytics Engineer (Remote)

Remote US

Senior Analytics Engineer

Sprout Social is looking for a Senior Analytics Engineer to join its Data Foundations Team 

Why join Sprout’s Engineering team? 

With collaborative cross-functional teams that span mobile, front-end, back-end, data, QA and site reliability engineering—the Sprout Engineering team is a place to sharpen your craft and solve hard problems with the smartest people in the industry. You’ll get to work on a “tech-giant” scale with smaller, supportive teams where every engineer has the chance to make an impact on our company, and our customers. The best part? In our industry, you often have to switch jobs or even companies to learn a new part of a tech stack or business. But at Sprout, our product is a suite, so you just need to move teams. You’re able to diversify your skills, which not only benefits your team—but also your career. 

What you’ll do

The Data Foundations team is a new organization within Sprout Engineering whose mission is to build out the next generation of data management infrastructure, classification, and standards for the company. As a cross-functional team of platform, data, and analytics engineers, we work with stakeholders from across the company, including product managers, software engineers, data scientists, and front-office leadership. We are at the beginning of a multi-year journey to transform the way Sprout manages data, and the effects will have a profound impact on our product and internal operations. Working within a cross-functional data squad you’ll partner with product managers, business analysts, engineers, and business stakeholders, to build and operate high-quality data products for use across the company. 

• Aligned with 1 or more data domains, you will work with your cross-functional teams to deliver trustworthy high-signal and high-impact data products used across the company 
• Relying on your experience with data warehousing and writing SQL, Python, and other skills, you will work with your colleagues to define requirements and translate them into well-documented, tested, and accurate data products. 
• Leveraging your experience with dimensional data modeling, you will help refine and define the path toward a more mature data warehousing capability to empower Sprout’s business and enable the ever-growing size and uses of our data. 
• Help define the strategic direction of our new data platform architecture by working with the team platform engineers and product managers designing our new self-service data architecture
• You will help Sprout’s broader data community to leverage the power of our data by mentoring analysts about SQL, DBT, and data modeling, educating on our technical visions, attending office hours, presenting in our Data Analysis and Visualization guild meetings, and helping 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 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 the implementation of Data Mesh and Data Products
• 2+ years managing projects, including helping define deliverables, breaking down tasks and milestones, and communicating expectations to stakeholders.
• 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.
• 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 of 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:

• 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 and business analytics team to understand the systems we have for publishing data
• Begin meeting with business analytics stakeholders to understand existing responsibilities and needs.
• Familiarize with the team strategy and Data Mesh approach

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

• Contribute to ongoing projects and on-call support
• Leverage Data Build Tool (DBT) and internal tools to add data sources to our production data warehouse.
• Begin documenting information 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 platform
• Establish a relationship with business stakeholders to understand their domain and data needs

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

• Join road mapping and take on their own projects
• Work with business stakeholders and analysts to create and/or update existing data sources for their reporting and analysis needs
• Execute reorganizing parts of our data warehouse
• Leverage tests you and others have written to monitor data flowing through our systems
• Form a career growth plan with your manager and work towards it.

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

• Have developed familiarity with several existing data areas and products
• Work with PMs and stakeholders on longer-term strategy finding additional opportunities for improving data integrity, visibility, and accessibility
• Expand your skills by learning from engineers, analysts, and data scientists around Sprout.
• 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.

Individual base pay is based on various factors, including work location, relevant experience and skills, the responsibility of the role, and job duties/requirements. In the United States, we have two geographic pay zones. You can confirm the pay zone for your specific location with your recruiter during your interview process. For this role, our current base pay ranges for new hires in each zone are:

• Zone 1: $115,000 to $135,000 USD annually
• Zone 2: $110,000 to $125,000 USD annually

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