Senior Analytics Engineer, Sprout Social
All-in-one social media management platform
Job no longer available
All-in-one social media management platform
1001+ employees
Job no longer available
1001+ employees
Company mission
To help organizations of all sizes become better marketers and create the world’s most beloved brands.
Role
Who you are
- 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
- 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!
Desirable
- 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
What the job involves
- Our Data Science and Analytics team empowers stakeholders across Sprout to access data to drive their decision making
- 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
- 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
Our take
Engagement tools for social media are proving increasingly vital with the rise of social commerce, and brands need to keep a careful eye on customer satisfaction and interaction if the company is to net a profit from this market. Sprout Social is a social media management platform for brands and agencies of all sizes, allowing users to post, manage engagement, and access analytics on a single hub.
With plenty of big-name customers, including Unicef, Chipotle, and Subaru, Sprout Social has established a trusted and effective brand of its own. It dodged direct competition with social engagement platform Hootsuite by expressly prioritising its customer service tools, where Sprout Social appears to be generally recognised as superior.
To double down on serving the social commerce market and carve out a distinctive niche ahead of this e-commerce trend’s anticipated success, Sprout Social has integrated with platforms such as Shopify, Canva and Facebook Shops. It is also a member of the TikTok marketing partner program and has continued to receive accolades for its software.
Steph
Company Specialist at Welcome to the Jungle
Insights
21% employee growth in 12 months
Company
Funding (last 2 of 5 rounds)
Dec 2018
$40.5m
SERIES D
Feb 2016
$42m
SERIES C
Total funding: $101.5m
Company benefits
- 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
Company HQ
Chicago Loop, Chicago, IL
Leadership
Justyn Howard
(Co-Founder & CEO)They were Senior Account Executive at New Horizons, and worked in Learn.com's Executive Account Sales department.
Aaron Rankin
(Co-Founder & Board Member)They have a Master's in Information Systems Management from Carnegie Mellon and were an IT Architect at IBM. They were also a Software Engineer at Endeca, and they are currently an investor with Rankin Family Ventures.
Peter Soung
(Co-Founder & Head of Growth)They studied Computer Science at Penn State before working at IBM as a Software Engineer. They also worked as a Sales Engineer at companies such as Endeca.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Share this job
View 5 more jobs at Sprout Social