Analytics Engineer
Census is how data teams at companies like Figma, Notion, Rippling, Clearbit, and Fivetran build better business operations.
With Census, analysts can turn their data warehouse into a single source of truth and publish their insights directly into the apps that marketing, sales, and success teams use daily. With richer customer data, these teams can build better campaigns, understand what users are doing, and ultimately drive more sustainable revenue.
Backed by a16z and Sequoia, we're a hybrid team headquartered in San Francisco who love taking annoying problems most people avoid and building elegant solutions for them. We believe that data should be used for more than just making charts. This is why we built the first integration platform that works directly within cloud data warehouses.
Your Mission
We're on the lookout for an exceptional Analytics Engineer to join our small and dynamic team. In this role, you'll serve as a vital link between non-technical stakeholders and our data, enabling us to provide unparalleled value through cutting-edge BI and operationalized data solutions. By building strong relationships with stakeholder teams and leveraging the latest data stack technology, you'll help them achieve their data objectives and drive the company's success to new heights!
You’ll be a key part of the effort to scale up our core data infrastructure using dbt and Snowflake, modeling product and business data in a young, complex data ecosystem and providing technical guidance and thought leadership that will shape our data for the future.
Your Responsibilities
- Take charge of designing, creating, and managing datasets, metrics, and schemas that empower self-serve analytics
- Leverage product and business data to drive impact for a range stakeholders including sales, marketing, operations, and customer success
- Spearhead initiatives that enable our teams to make data-driven decisions and oversee analytics projects from ideation to implementation.
- Proactively identify opportunities to scale insights through automation, optimization, and self-serve tooling
- Help build out the predictive analytics engine to improve selling and business strategy
- Establish tooling and monitoring for enhancing data quality and robustness and drive data quality across the organization
- Documenting data architecture, metrics, and facilitate stakeholder enablement
Is This You?
Here is what our dream candidate looks like:
- Proficient in data architecture, analysis, and translating data into valuable insights
- Skilled in utilizing SQL for data manipulation and proficient in creating effective data visualizations
- Experience working with dbt and cloud data warehouses such as Snowflake or Redshift
- Excellent analytical, problem solving, and troubleshooting skills to manage complex process and technology issues
- Passionate about building scaled data architecture, partnering with stakeholder teams, and solving business problems with data
- Bachelor’s Degree
Extra Credit
- Experience with analyzing data in Python
- Ability to communicate data and insights clearly to both technical and non-technical audiences
- Strong eye for building efficient data architecture, optimizing SQL queries, and writing elegant code
- Passion for collaboration, ideation, and creative problem solving
- Strong opinions about the right way to build out robust data systems
- Empathy in understanding stakeholder needs
- Curiosity in learning, exploring, and experimenting with better processes