HubSpot’s Business Intelligence team is chartered with making HubSpot smarter through enabling an ever-deeper understanding of its customers.  We’re not a centralized reporting-only team, we’re a team of data model developers who partner with our business leaders to understand the nuances of the data and HubSpot systems as well provide access to the data they need to manage our business intelligently.  We tackle HubSpot’s most complex data challenges, manage our BI data infrastructure, and provide leverage to each other and to a network of business analysts throughout the company. You will get to work in a best of breed tech stake that includes Airflow, Snowflake, dbt, and Looker.

In this role you'll get to:

• Take on HubSpot’s biggest and most complex data challenges related to internal reporting and analytics
• Find efficient ways to distill large scale data sets (terabytes of data) into meaningful metrics, thresholds, insights, forecasts and reports
• Perform complex root cause analysis of problems and subsequently, make and implement recommendations to prevent future occurrences
• Utilize data warehousing and code development best practices to enable access to information by creating and maintaining foundational data models.
• Provide self-service models to distributed operations teams (sales ops, services ops) to utilize for management reporting
• Work closely with other Data Analysts, Product Managers, Data Architect and Data Engineers to implement data strategies and collaboratively deliver on projects.
• Work with Data Product Managers to define/refine project requirements with business stakeholders.  Participate in key touchpoints to keep stakeholders informed throughout projects and provide documentation to enable your deliverables to speak for themselves
• Collaborate with both technical and non-technical areas of the business to share best practices and  bridge the gap between the business problem and the technical solution
• Establish and evangelize best data practices with distributed analysts

We are looking for candidates with:

• Experience participating in and leading the technical execution of business intelligence and analytics related projects of large scope and complexity
• Experience developing data models using SQL techniques (windows functions, JSON flattening, common table expressions, UDFs, etc.)
• Translating business use cases into a set of technical sub-tasks that build towards a final deliverable
• Working with columnar databases (e.g. Redshift, Snowflake)
• Working iteratively on projects as part of an Agile Scrum team composed of different functional roles

Even better if you have:

• Code development in a version control environment; you’re comfortable giving and getting code reviews
• Familiarity with Kimball Modeling in a modern data warehouse
• Data modeling of complex data sets into star or snowflake schemas, leveraging fact tables and (slowly changing) dimension tables
• Motivated to deliver measurable impact to the business