Data Engineer

Responsibilities

• HOW YOU'LL DO IT:
• PLATFORM STABILIZATION & MODERNIZATION
• Logic Migration: Lead the knowledge transfer and stabilization of existing BigQuery stored procedures, with a strategic vision to migrate them to dbt over time.
• Infrastructure as Code: Utilize tools like Terraform to support reproducible, version-controlled environment provisioning across GCP projects.
• Version Control: Establish strict Git history and peer visibility practices so no critical data logic exists without documented context.
• PIPELINE ENGINEERING & OPTIMIZATION
• ELT/ETL Pipelines: Build, maintain, and optimize robust data flows from critical source systems into Google BigQuery.
• Fivetran Administration: 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.
• Performance Tuning: Implement table partitioning, clustering, and incremental load strategies across high-volume tables to optimize query performance and reduce compute costs.
• QUALITY, GOVERNANCE & SECURITY
• 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.
• AI ENABLEMENT & COLLABORATION
• Semantic Layer: Partner with Full Stack Developers to build a semantic layer over BigQuery, enabling governed, AI-queryable access to data domains.
• RAG Architecture: Build and optimize data stores for Retrieval Augmented Generation (RAG) to power BRUNT's next generation of intelligent applications.
• Cross-Functional Support: 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.
• WHAT YOU NEED TO SUCCEED:
• Experience: 4-7 years of data engineering experience with demonstrated ownership of production data pipelines, cloud warehouses, and ELT/ETL architectures.
• 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.
• Tooling Stack: Deep experience administering managed ingestion platforms like Fivetran and a strong working knowledge of dbt for transformation layer testing and documentation.
• AI Architecture (Preferred): Familiarity with Retrieval Augmented Generation (RAG) data structures and experience building semantic layers for LLM or AI agent consumption.
• Governance & Security: Working knowledge of cloud data governance, including PII handling, column-level security, and access control implementation.
• Infrastructure & BI: Familiarity with Terraform for infrastructure-as-code and Looker Studio (or similar BI tools) to ensure gold-tier data yields performant reporting.
• The "Builder" Mindset: A proven track record of operating as a senior individual contributor in lean environmen

Benefits

Additional Information

We're leading the way in redefining the workwear category. Our mission is to engineer better boots and apparel for our country's tradesmen and women by working directly with real workers to learn what they actually need to execute their jobs. The BRUNT team is not only devoted to improving on the old workwear standards, but we're also creating a community that tradesmen and women can call their own. From our weekly hangouts at the BRUNT Garage, to hosting events across the country, we're all about getting boots on the ground and building something real with the BRUNT crew.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at bruntworkwear? Share your experience