Analytics Engineer
The Analytics Engineering team provides all parts of Intercomโs business with the right set of accurate and up-to-date data tables that form the basis of all of our most important operational and strategic data-driven decisions. The team uses their deep knowledge of how GTM and Product teams work to anticipate their data needs. They use their deep technical expertise to design the right data models and reliably turn these models into high-quality core data assets in our data warehouse. The team are experts at driving data model efficiencies and solving data quality issues at their root cause.
This team is the glue between all of our Analyst teams and our Data Infrastructure teams. They speak everyone's language and make everything go faster.
What will I be doing? ๐
- Partnering with the data infrastructure engineering team to understand and help evolve and maintain our data warehouse and the ELT that feeds it.
- Build a best in class data platform to drive critical business decisions
- Partnering with all of our internal analyst teams to understand the questions they are trying to answer and help them arrive at the right answers.
- Simplify and improve data collection and reporting processes to automate manual workflows and eliminate manual dependencies
- Reconcile data issues and alerts between various systems, finding opportunities to innovate and drive improvements
What skills do I need? ๐
- 3+ years experience working as an Analytics Engineer
- You write advanced SQL with a preference for well-architected data models, optimized query performance, and clearly documented code
- Youโre familiar with the modern data stack. dbt and Snowflake experience are a big plus.
- A growth mindset and eagerness to learn.
- You exhibit great judgment and sharp business and product instincts that allow you to differentiate essential versus nice-to-have and to make good choices about trade-offs
- You practice excellent communication skills, and you tailor explanations of technical concepts to a variety of audiences
Nice to haves ๐
- Exposure to Apache Airflow or other DAG frameworks โ we use Airflow to orchestrate and schedule all of our data workflows and transformations
- Worked in Tableau, Looker, or similar visualization/business intelligence platform
- Experience with operational tools and business systems such Google Analytics, Marketo, Salesforce, Segment, or Zuora
- Familiarity with Python
The base salary range for candidates within the San Francisco Bay Area is $143,200 - $230,000