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 various business use cases. 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.
- Working with other Analytics Engineers to share thoughts, offer recommendations, provide mentorship to ensure the team is operating with the best practices.
Here’s what we’re looking for:
- 7+ years of experience handling extensive and intricate datasets sourced from diverse channels, including product, marketing, sales, finance, operations, and customer acquisition.
- Significant work experience in Data Modeling and Data Architecture within a production environment, specifically with distributed databases like Redshift.
- Expertise designing, building and deploying production data pipelines/ETLs in Python (Airflow and dbt experience a plus)
- Extensive understanding of relational databases and familiarity with the modern data stack.
- Ensure data integrity and accuracy by conducting regular data audits, identifying and resolving data quality issues, and implementing data governance best practices.
- Stellar SQL skills, with specific experience in Redshift as a notable advantage.
- Experience in BI and data visualization (Tableau experience a plus).
Our cash compensation amount for this role is targeted at $140,000-$174,000/year in Denver, Chicago, Miami, Austin and Atlanta, $153,000-$189,000/year in Los Angeles and Seattle, and $170,000- $210,000/year for San Francisco and New York.
Gusto has physical office spaces in Denver, San Francisco, and New York City. Employees who are based in those locations will be expected to work from the office on designated days approximately 2-3 days per week (or more depending on role). The same office expectations apply to all Symmetry roles, Gusto's subsidiary, whose physical office is in Scottsdale.
Note: The San Francisco office expectations encompass both the San Francisco and San Jose metro areas.
When approved to work from a location other than a Gusto office, a secure, reliable, and consistent internet connection is required.
Our customers come from all walks of life and so do we. We hire great people from a wide variety of backgrounds, not just because it's the right thing to do, but because it makes our company stronger. If you share our values and our enthusiasm for small businesses, you will find a home at Gusto.
Gusto is proud to be an equal opportunity employer. We do not discriminate in hiring or any employment decision based on race, color, religion, national origin, age, sex (including pregnancy, childbirth, or related medical conditions), marital status, ancestry, physical or mental disability, genetic information, veteran status, gender identity or expression, sexual orientation, or other applicable legally protected characteristic. Gusto considers qualified applicants with criminal histories, consistent with applicable federal, state and local law. Gusto is also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you require assistance in filling out a Gusto job application, please reach out to candidate-accommodations@gusto.com.