Bruntworkwear

Bruntworkwear

Data Engineer

North Reading, MA · Full-time

Sponsorship not specified$120k-$140kDetected 56 days ago
PythonFull-Stack DevelopmentData StructuresGitSQLBigQueryGCPTerraformDevOpsdbtData EngineeringData VisualizationLLMsRAGComplianceAgileJiraAuditingLogisticsCadenceCollaborationWritingPipeline Integrity

About the role

  • We're leading the way in redefining the workwear category.
  • This range reflects the base salary that we reasonably expect to pay for this position at the time of posting.
  • We look for individuals who thrive on challenges, will be passionate about our brand, and believe that teamwork is necessary for success.

Responsibilities

  • Reporting to the SVP of Technology within the DevOps team, you will partner closely with two data analysts and our full-stack developers.
  • You will take ownership of the data environment, modernize our existing transformation logic while building the semantic layers and RAG-compatible data stores that will power BRUNT's next generation of intelligent, AI-driven applications.
  • Infrastructure as Code: Utilize tools like Terraform to support reproducible, version-controlled environment provisioning across GCP projects.
  • ELT/ETL Pipelines: Build, maintain, and optimize robust data flows from critical source systems into Google BigQuery.
  • Design and implement scalable ingestion solutions for non-Fivetran data sources, including structured replacements for file-based ingestion methods.
  • Performance Tuning: Implement table partitioning, clustering, and incremental load strategies across high-volume tables to optimize query performance and reduce compute costs.
  • Testing Frameworks: Implement validation checks, schema contracts, and anomaly detection to guarantee the accuracy of data reaching our gold tier.
  • Data Security: Lead the PII field inventory and column-level security access controls to ensure strict CCPA compliance.
  • Data Governance: Maintain a centralized data dictionary and field-level definitions that serve both technical and non-technical audiences.
  • Semantic Layer: Partner with Full Stack Developers to build a semantic layer over BigQuery, enabling governed, AI-queryable access to data domains.

Requirements

  • 4-7 years of data engineering experience with demonstrated ownership of production data pipelines, cloud warehouses, and ELT/ETL architectures.
  • Strong hands-on proficiency with Google BigQuery, including schema design, query optimization, partitioning, clustering, and GCP cost management.
  • Advanced SQL skills (ability to audit and refactor complex legacy stored procedures) paired with proficiency in Python for API-based ingestion and automation.
  • Deep experience administering managed ingestion platforms like Fivetran and a strong working knowledge of dbt for transformation layer testing and documentation.
  • Working knowledge of cloud data governance, including PII handling, column-level security, and access control implementation.
  • The BigQuery Core: Strong hands-on proficiency with Google BigQuery, including schema design, query optimization, partitioning, clustering, and GCP cost management.
  • Data Ingestion & Coding: Advanced SQL skills (ability to audit and refactor complex legacy stored procedures) paired with proficiency in Python for API-based ingestion and automation.
  • Logistics: Must be 18+ with full-time availability (including occasional off-hours support for critical pipeline incidents) and the ability to reliably commute to the office 4x per week

Compensation

  • $120,000 - $140,000 USD
  • No matter what experience you have within our industry we encourage you to apply. At BRUNT, we believe that a strong crew is assembled with people from different backgrounds.
  • We look for individuals who thrive on challenges, will be passionate about our brand, and believe that teamwork is necessary for success. Show us how your experiences have shaped you and how you can contribute to BRUNT. We can't wait to hear from you!
  • Must be 18+ with full-time availability (including occasional off-hours support for critical pipeline incidents) and the ability to reliably commute to the office 4x per week
  • In accordance with applicable salary transparency laws, we are providing the good-faith salary range for this position.
  • This range reflects the base salary that we reasonably expect to pay for this position at the time of posting.
  • The anticipated salary range for this role is:

Benefits

  • Healthcare: Comprehensive medical, dental, and vision insurance options.
  • Retirement: 401(k) plan with Company Match.
  • Paid Time Off: 15 days of PTO, plus 11 paid holidays and sick leave.
  • Incentives: Performance-based bonus eligibility and Equity if applicable.
  • Lead the knowledge transfer and stabilization of existing BigQuery stored procedures, with a strategic vision to migrate them to dbt over time.
  • Fivetran Administration: Own the health and optimization of 40+ source datasets, managing sync schedules and expanding coverage as new systems onboard.

Company info

  • BRUNT is at a pivotal inflection point, transitioning our fast-scaling data environment from a functional BigQuery warehouse into a governed, AI-ready data platform.
  • We are seeking a hands-on Data Engineer to serve as our principal engineering resource, bringing the discipline, documentation rigor, and modern tooling needed to harden and scale our data infrastructure for our next phase of growth.
  • At BRUNT, we believe that a strong crew is assembled with people from different backgrounds.

This listing is sourced directly from Bruntworkwear's careers page and normalized into a canonical job model.