• HubSpot
  • $91,060.00 -134,310.00/year*
  • Cambridge , MA
  • Information Technology
  • Full-Time
  • 101 Auburn St

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 provide access to the data they need to manage our business intelligently. We tackle HubSpot s hardest data challenges, manage our BI infrastructure, and provide leverage to each other and to a network of business analysts throughout the company.

As a Data Warehouse Engineer on the Business Intelligence team, you will:

  • Take on HubSpot s biggest and most complex data challenges related to internal reporting and analytics
  • Find efficient ways to work with large data sets (terabytes of data)
  • 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 collaboratively deliver on projects.

Ideal candidates will have experience in:

  • Participating in and leading the technical execution of business intelligence and analytics related projects of large scope and complexity.
  • Developing data models using T-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.
  • Familiarity with Redshift, Snowflake and participating in code reviews is a bonus.

Confidence can sometimes hold us back from applying for a job. But we'll let you in on a secret: there's no such thing as a 'perfect' candidate. HubSpot is a place where everyone can grow. So however you identify and whatever background you bring with you, please apply if this is a role that would make you excited to come into work every day.

About HubSpot

HubSpot helps millions of organizations grow better, and we d love to grow better with you. Our business builds the software and systems that power the world s small to medium-sized businesses. Our company culture builds connections, careers, and employee growth. How? By creating a workplace that values flexibility, autonomy, and transparency. If that sounds like something you d like to be part of, we d love to hear from you.

You can find out more about our company culture in the HubSpot Culture Code , which has more than 4M views, and learn about our commitment to creating a diverse and inclusive workplace , too. Thanks to the work of every HubSpotter globally who has helped build our remarkable culture, HubSpot has been named a top workplace by Glassdoor, Fortune, Entrepreneur, and more.

HubSpot was founded in 2006. We re headquartered in Cambridge, Massachusetts, and we have offices in Dublin (Ireland), Sydney (Australia), Portsmouth, New Hampshire, Singapore, Tokyo (Japan), Berlin (Germany), Paris (France) and Bogot (Colombia).

By submitting your application, you agree that HubSpot may collect your personal data for recruiting, global organization planning, and related purposes. HubSpot's Recruiting Privacy Notice explains what personal information we may process, where we may process your personal information, our purposes for processing your personal information, and the rights you can exercise over HubSpot s use of your personal information.

Associated topics: data architect, data integration, data integrity, data manager, data management, etl, erp, mongo database administrator, sql, sybase

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...