About the Team

The Analytics Engineering team at Gusto is a central hub for data, analytics, and operational excellence. We ensure the availability, reliability, and quality of our data assets.

As an Analytics Engineering Manager, you'll lead a team responsible for defining and managing critical datasets. These datasets are essential for data practitioners to develop metrics, conduct analyses, and drive data-informed decision-making at Gusto.

You'll collaborate closely with an established team of experienced leaders in Engineering, Product, Design, Data Science, Revenue, Marketing, and Sales.

About the Role
Gusto is currently seeking an experienced Analytics Engineering Manager to join our team! As an Analytics Engineering Manager, you'll play a crucial role in driving our Growth and Expansion efforts by developing and maintaining the foundational data infrastructure. You'll collaborate with stakeholders and data professionals to build and maintain data products that empower users across the organization to explore and answer data-related questions.

Your responsibilities will include managing end-to-end data pipelines, focusing on transformation, design, documentation, and user-friendliness. Ultimately, your work will factor into ensuring our customers maximize the value from our product offerings.

Here’s what we’re looking for:

• 10+ years of working with complex datasets from various sources, including product, marketing, sales, finance, operations, and customer acquisition.
• 4+ years of managing Analytics Engineering teams or equivalent roles.
• Ability to excel in both people management and individual contributor roles.
• Significant experience in data modeling and architecture within production environments, particularly using Redshift, DataBricks, or Snowflake.
• Expertise in designing, building, and deploying production data pipelines and ETLs using Python, with a preference for Airflow and dbt.
• Extensive knowledge of relational databases and familiarity with modern data stack technologies.
• Proven ability to ensure data integrity and accuracy through regular audits, issue resolution, and implementation of data governance best practices.
• Experience in business intelligence and data visualization tools, such as Tableau.
• Exceptional SQL skills are critical.

Here’s what you’ll do day-to-day:

• Design and implement Gusto's production data warehouse, defining a set of schemas to enhance data analysis for Growth and Expansion. Develop use-case-specific data tables by skillfully combining and engineering essential elements across diverse data domains.
• Construct robust data ingestion pipelines from both internal and external sources, including APIs, ensuring structural integrity, adherence to data quality standards, and establishing traceability from the consumption layer back to the raw data layer.
• Empower users throughout the organization to independently explore and answer data-related queries using well-organized and intuitive datasets.
• Lead Quality Assurance and Data Quality initiatives to streamline development timelines, minimize errors, and uphold the reliability of analytical products. Implement monitoring mechanisms for crucial tables.
• Optimize data warehousing processes by refining naming conventions, enhancing data modeling, and implementing best practices for data quality testing.
• Offer recommendations to enhance the reliability, user-friendliness, and performance of the Data Team's technical infrastructure.
• Share knowledge, provide mentorship, and ensure your team adheres to best practices.

Our cash compensation amount for this role is targeted at $166,000-$206,000/year in Denver, Chicago, Miami, Austin and Atlanta, $181,000-$223,000/year in Los Angeles and Seattle, and $195,000- $241,000/year for San Francisco and New York. Final offer amounts are determined by multiple factors, including candidate experience and expertise, and may vary from the amounts listed above.