200+ applicants

This job has closed.

Company

HubSpot · 1 day ago

Senior Analytics Engineer

United States

Full-time

Remote

Mid, Senior Level

$118K/yr - $190K/yr

3+ years exp

Maximize your interview chances

AnalyticsCopywriting

Comp. & Benefits

H1B Sponsor Likely

Insider Connection @HubSpot

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Collaborate with technical and non-technical stakeholders, bridging the gap between business problem and technical solution

Own and champion Product Operations’ “crown jewel” data assets that answer HubSpot’s most critical operational questions, reinforcing them as Source of Truth across the organization

Develop scalable data models that enable performant analysis into Hubspot’s products and business

Curate, organize and document Product Operations data and reporting environments across Looker, dbt and Amplitude

Collaborate closely with Hubspot’s BI and Data Engineering teams to expand data access and availability

Codify and democratize best practices for SQL query optimization/reusability and reporting, leveraging HubSpot’s data assets, and analytics development within Snowflake SQL, dbt, LookML, and git

Define teamwide coding standards, documentation requirements and development processes (code reviews, testing requirements, etc)

Scope requirements with internal stakeholders and lead working groups to usher projects through their entire lifecycle while building clear roadmaps for cross-functional team members

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Advanced SQLCloud data warehousesData pipeline managementAnalytics developmentLookerData quality validationGitHub EnterpriseETLELT jobsTeam trainingJSON FlatteningProcess improvementsPatienceDocumentation skills

Required

Leading the technical execution of high complexity business intelligence and analytics projects in code with the use of CTEs, nested queries, or other similar techniques

Experience with complex datasets and computer science fundamentals, including software development lifecycle (SDLC)

Experience building and optimizing data pipelines, architectures and data sets; experience diagramming architecture and entity relationships with Lucidcharts (for example)

Understanding of multi-step ETL and ELT jobs / data pipelines and working with job scheduling systems, with an ability to reverse engineer and refactor existing technical projects

Strong understanding of the analyst’s workflow as it relates to both structured and unstructured datasets

Exceptional ability to document technical designs

3+ years of hands on experience experience with advanced SQL (writing and optimizing), cloud data warehouses (eg Snowflake, Redshift, Bigquery) and relational databases

Ability to collaborate through code-management/version control tools like GitHub Enterprise (for peer-reviews, feature branches, resolving conflicts and commits)

Experience training and onboarding colleagues (especially at-scale, or in a remote-first or global environment)

Effective communication across multiple modes (video, wikis, decks, guided exercises) and a knack for choosing the best format for the task and audience at hand

Writing and reviewing end-user and technical documents, including requirements and design documents for existing and future data systems, as well as data standards and policies

Preferred

Exposure to data pipeline and workflow management tools (i.e. Airflow, Google Cloud Composer, Luigi, etc)

Experience with script based analytic transformation tools (dbt, AWS Glue, Talend, etc)

2+ years of experience with data quality and validation exercises in data science, business analytics, business intelligence (BI), or comparable big data 'like' environments

Experience with JSON Flattening and extracting internal elements

Conceptual knowledge of Looker (LookML, Looks and Dashboards) or equivalent BI visualization tool (e.g. Tableau, Qlik, Power Bi)

Experience identifying and driving process improvements around data use to drive team effectiveness

Best practice definition: identifying the minimal set of rules for the greatest teamwide gains in clarity, accuracy, discoverability, and reusability

Patience, empathy, finding success in the team’s success

Benefits

Equity plan to receive restricted stock units (RSUs)

Overtime pay

Company

HubSpot

Glassdoor

4.0

HubSpot develops cloud-based, inbound marketing software that allows businesses to transform the way that they market online.

Founded in 2006

Cambridge, Massachusetts, USA

5,001-10,000 employees

http://www.hubspot.com

H1B Sponsorship

HubSpot has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (61)

2022 (103)

2021 (88)

2020 (33)