Lead Data Engineer

Fullbay is a cloud-based shop management software company serving commercial repair shops and using artificial intelligence to improve operations. The Lead Data Engineer will own the data platform end to end, including Snowflake architecture, trusted metric definitions, semantic layers, identity resolution, governance, and AI-agent data access. The role also establishes company-wide data standards and enables business users to self-serve against governed data.

Responsibilities:

• Certified Definitions & Semantic Layer: Own the metric and entity definitions the whole company reports from and serve as the final arbiter when functions disagree on a definition. Keep documentation current enough that a business user finds the right answer without needing to ask — this is the center of the role, not a component of it
• Gold Layer Ownership: Build and extend Fullbay’s gold layer hands-on, writing SQL and transformation code in version control with automated tests
• Identity Resolution: Own identity resolution across our Classic, Next, and Salesforce platforms, including crosswalk logic, survivorship rules, and platform-of-record determination over time. A permanent responsibility, not a one-time migration task
• Snowflake Platform Ownership: Own Snowflake’s role hierarchy and grants, row access and masking policies, warehouse sizing, and cost attribution and spend
• Agent Enablement: Design curated access paths for AI agents as first-class data consumers, including per-agent identities and grants, a registration pattern, and a retention policy for agent-produced data
• Source Ingestion: Onboard new data sources to documented patterns, own schema drift and deletion detection, and partner with engineering on source schema changes
• Vendor Direction: Scope and direct the retained architecture consultant’s ongoing work — writing specs, reviewing deliverables against approved standards, and rejecting nonconforming work
• Self-Serve Enablement: Provide guidance and office hours for business users and AI builders to self-serve against the data platform. This role explicitly does not build reports on request
• Documentation: Treat documentation as a core deliverable, not an afterthought. With no second data employee, documentation is Fullbay’s continuity plan for this function
• Adheres to all confidentiality and compliance regulations
• Performs other duties as assigned

Requirements:

• 7+ years of data engineering experience, including demonstrated ownership of a production data platform, required
• Deep dimensional modeling experience required: able to declare a grain, defend historization choices per attribute, and articulate a restatement policy
• Experience with Snowflake (or a comparable cloud data warehouse) beyond SQL — warehouse strategy, cost management, RBAC, and environment design — required
• Experience building transformations as version-controlled code with automated tests and CI required
• Bachelor's degree in computer science, data engineering, or a related field, or equivalent work experience
• Experience with change data capture and incremental extraction from application databases required
• Experience with entity resolution across systems with independent identifiers required
• Comfortable being the only person who knows how something works, and documents accordingly
• Willing to say no to a vendor, an app team, or an executive, and ability to explain why
• Strong written communication skills; able to arbitrate cross-functional definitional disagreements clearly and diplomatically
• Experience serving AI or programmatic consumers of data, familiarity with the Salesforce object model, prior experience as a company's first data hire, and prior experience directing outside vendors