Seasonal Data Engineer Python Jobs in Boston, MA

Job Summary:
BRUNT Workwear is redefining the workwear category by engineering better boots and apparel for tradesmen and women. They are seeking a hands-on Data Engineer to modernize their data infrastructure and support the transition to an AI-ready data platform, partnering closely with data analysts and full-stack developers.
Responsibilities:
• Lead the knowledge transfer and stabilization of existing BigQuery stored procedures, with a strategic vision to migrate them to dbt over time.
• Utilize tools like Terraform to support reproducible, version-controlled environment provisioning across GCP projects.
• Establish strict Git history and peer visibility practices so no critical data logic exists without documented context.
• Build, maintain, and optimize robust data flows from critical source systems into Google BigQuery.
• Own the health and optimization of 40+ source datasets, managing sync schedules and expanding coverage as new systems onboard.
• Design and implement scalable ingestion solutions for non-Fivetran data sources, including structured replacements for file-based ingestion methods.
• Implement table partitioning, clustering, and incremental load strategies across high-volume tables to optimize query performance and reduce compute costs.
• Implement validation checks, schema contracts, and anomaly detection to guarantee the accuracy of data reaching our gold tier.
• Lead the PII field inventory and column-level security access controls to ensure strict CCPA compliance.
• Maintain a centralized data dictionary and field-level definitions that serve both technical and non-technical audiences.
• Partner with Full Stack Developers to build a semantic layer over BigQuery, enabling governed, AI-queryable access to data domains.
• Build and optimize data stores for Retrieval Augmented Generation (RAG) to power BRUNT’s next generation of intelligent applications.
• Partner with data analysts to ensure gold-tier datasets are performant and well-structured for Looker Studio dashboards, managing your workflow via Jira within an Agile sprint cadence.
• Serve as the technical data engineering point of contact within the DevOps team, translating business-driven data requirements into engineering specifications and delivery plans.
Qualifications:
Required:
• 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.
• Familiarity with Terraform for infrastructure-as-code and Looker Studio (or similar BI tools) to ensure gold-tier data yields performant reporting.
• A proven track record of operating as a senior individual contributor in lean environments, with a knack for inheriting, auditing, and modernizing legacy data systems.
• Experience working within Agile/Scrum sprint frameworks using Jira, alongside strong technical writing skills for mapping data lineage and runbooks.
• 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.
Preferred:
• Familiarity with Retrieval Augmented Generation (RAG) data structures and experience building semantic layers for LLM or AI agent consumption.
Company:
BRUNT Workwear is a consumer brand that provides work boots and clothing. Founded in 2020, the company is headquartered in Boston, USA, with a team of 51-200 employees. The company is currently Growth Stage.