> Markdown version of [/jobs/ext/4322881-lead-data-platform-engineer](https://www.wearedevelopers.com/jobs/ext/4322881-lead-data-platform-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Platform Engineer - **Company:** Hamilton Beach Brands, Inc. - **Location:** Glen Allen, VA, United States - **Experience:** Expert - **Salary:** $116,008 - $140,867 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Code Review, Information Systems, Data Architecture, Data Dictionary, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Warehousing, Dimensional Modeling, Data Flow Control, Python (Programming Language), Microsoft SQL Server, SQL Azure, Operational Databases, Performance Tuning, Azure Active Directory, Microsoft Copilot, Reverse Engineering, Runbook, SQL Stored Procedures, SQL Server Integration Services, Transact-SQL, Azure Data Factory, Claude Code, Generative AI, Microsoft Fabric, Pyspark, Information Technology, Data Lineage, Data Analytics, Data Management, Claude, Network Server, Data Pipelines, Databricks - **Published:** October 28, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=31e14c269c79e39e ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Data Science, or a related technical field, or equivalent experience. Master's degree preferred. * 7+ years in data engineering, including at least 2 years in a lead, mentoring, or people management role. Consumer products, manufacturing, or supply chain experience preferred. * Expert T-SQL skills, including views, stored procedures, and performance tuning, plus strong Python/PySpark skills and experience building and supporting production data pipelines. * Hands-on experience with Azure SQL or SQL Server, Azure Data Factory, and Microsoft Fabric, including Lakehouse, Warehouse, Pipelines, Dataflow Gen2, OneLake, and Mirroring. Azure Databricks experience strongly preferred. * Strong experience with dimensional modeling and medallion Lakehouse architecture, including star schemas, conformed dimensions, slowly changing dimensions, and Delta tables. * Extensive hands-on use of generative AI in engineering, experience building or operating MCP servers, and experience with Microsoft Copilot. Claude and Claude Code experience strongly preferred., Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time. ## Description We are seeking a Lead Data Platform Engineer to serve as the technical leader for our Data Analytics, Reporting & AI Implementation team. You will own the Microsoft Fabric architecture build-out as we modernize our legacy SQL Server environment using Azure SQL, Azure Data Factory, Azure Databricks, and Microsoft Fabric. This is a role for an experienced data / platform engineer who builds hands-on while mentoring and developing team members. The role leads the technical side of the Data Warehouse Modernization program alongside consulting partners, owns the reliability of existing production pipelines, and works AI-first, using Claude, Microsoft Copilot, and MCP-based tooling to multiply team output. This full-time, hybrid position is based at our corporate headquarters in Glen Allen, Virginia, and reports to the Manager, Data Analytics, Reporting and AI Enablement. Salary Range: $116,000 - $140,000 Annually What You'll Do * Lead data warehouse modernization. direct contractor teams through converting legacy SSIS packages to T-SQL and migrating workloads to Azure SQL and Azure Data Factory. Validate results with business teams before retiring existing processes. * Build reliable data pipelines. Develop solutions with T-SQL, Python/PySpark, Azure Data Factory, and Microsoft Fabric. Use Azure Databricks for the most complex workloads. * Shape HBB's data architecture. Build and govern Bronze, Silver, and Gold layers in Fabric and OneLake, including Azure SQL mirroring and repeatable ingestion patterns. Create a Gold Enterprise Data Warehouse with shared customer, item, and vendor dimensions to support trusted reporting and Master Data Management. * Optimize platform performance and cost. Choose the right processing tools for each workload, plan Fabric capacity, and protect reporting performance by separating heavy ETL processing. * Lead and develop people. Manage and mentor two Data Analysts through technical guidance, code reviews, and development plans. Strengthen the broader analytics team through shared standards, design reviews, and reusable solutions. * Put AI into everyday engineering. Use Claude and Claude Code for development, SSIS reverse-engineering, troubleshooting, and documentation. Own HBB's internal Claude access layer and build secure MCP servers and agentic workflows that connect AI tools to enterprise platforms. * Keep business-critical reporting running. Own production pipelines supporting FP&A, forecasting, supply chain, and sales across domestic and international operations, with dependable scheduled loads, monitoring, and alerting. * Partner across IT and the business. Work with Infrastructure, ERP, and Security teams to integrate ERP, WMS, planning, and third-party data. Set priorities and acceptance criteria for consulting partners, review deliverables, and resolve technical blockers. * Build governance into the platform. Maintain architecture documentation, data lineage, runbooks, and data dictionaries. Establish access controls, Microsoft Entra ID security, certification, and consistent environment promotion standards.