Data Engineer

MBC Holdings•Archbold, OH

About The Position

MBC Holdings of Ohio is a family-owned construction group based in Archbold, Ohio, with three operating companies: Miller Bros. Const., Inc., Cardinal Aggregates, and Black Swamp Steel, Inc. Together, the businesses employ roughly 750 people and operate across heavy civil construction, quarrying and trucking, and steel erection. They use separate systems, including an ERP on IBM i, HCSS, Samsara, BambooHR, and SQL Server applications. The Data Engineer is a newly created architect-and-builder role responsible for connecting those systems and establishing a governed source of data for leadership reporting. The role will design and own a cloud data architecture based on Microsoft Fabric or an equivalent Azure design, including lakehouse storage, medallion layers, pipelines, notebooks, and governed semantic models for Power BI and future AI tools. The platform is new, and the Data Engineer will recommend platform choices during the first 90 days. Reporting to the IT Director and working alongside the IT team, this position owns the data architecture and its outcomes. It also supports reporting authors across the business, establishes data governance and quality practices, manages platform costs, and prepares data for future AI use cases and ERP selection.

Requirements

  • Advanced SQL skills, including complex T-SQL, query tuning, stored procedures, indexing, and execution plans.
  • SQL experience with DB2, ideally on IBM i, or ability to become productive with it within 90 days.
  • SQL Server database administration experience covering performance, indexing, maintenance, security, and access.
  • Experience with dimensional modeling, including star schemas, normalization, and slowly changing dimensions.
  • Experience designing and building a cloud lakehouse on Microsoft Fabric or Azure, including OneLake or ADLS, Delta or Parquet, and medallion architecture; ability to explain and defend design decisions to IT and finance leaders.
  • Experience building and operating pipelines and notebooks on the platform, including Data Factory pipelines and dataflows, Spark notebooks using PySpark or Spark SQL, and an orchestration tool such as Fabric, Azure Data Factory, Synapse, SSIS, or dbt.
  • Integration design experience with REST APIs, OAuth and API keys, JSON, webhooks, file and database interfaces, idempotent loads, and error handling.
  • Experience building Power BI semantic models on a lakehouse, including DAX, relationships, Direct Lake and import modes, incremental refresh, row-level security, and performance tuning.
  • Proficiency in at least one programming language for data work; Python or C# is preferred.
  • Experience with Git and automated deployment for data code, along with testing, reconciling, and documenting work.
  • Knowledge of data security fundamentals, including least privilege, encryption, secrets management, and careful handling of payroll and personnel data.
  • Ability to explain in plain language what data does and does not say to finance and operations leaders.
  • At least 5 years building and operating data pipelines, integrations, and models, including at least 3 years in a Microsoft data environment.
  • Bachelor's degree in computer science, information systems, data engineering, or a related field, or equivalent experience.

Nice To Haves

  • Construction ERP data experience, especially eCMS on IBM i; experience with Viewpoint, Sage, CMiC, or Procore also counts.
  • Experience with HCSS products such as HeavyJob, HeavyBid, Equipment360, or Dispatcher; BambooHR; and Samsara or OEM equipment telematics feeds.
  • Fabric capacity planning and cost management experience, or experience with the Azure equivalent.
  • Real-time or event-based ingestion experience, such as Fabric Real-Time Intelligence or Event Hubs, for telematics and equipment data.
  • Experience with integration platforms such as Azure Logic Apps, Power Automate, or a commercial iPaaS.
  • Experience with data catalog and governance tools such as Microsoft Purview.
  • Microsoft certifications such as DP-700, DP-600, or PL-300.
  • Experience replacing spreadsheet and desktop database workarounds with governed integrations at a mid-size company.

Responsibilities

  • Design and document the target cloud data architecture within the first 90 days, including storage, Delta tables, medallion layers, environments, security, naming standards, and cost controls.
  • Build and operate ingestion from ERP, operations and project management systems, equipment telematics, HR and payroll, SQL Server applications, and other approved sources, using change data capture or incremental loads where available.
  • Build and operate pipelines and notebooks for orchestration and transformation, including scheduling, monitoring, alerting, and recovery.
  • Set integration standards for patterns, tooling, error handling, retries, logging, and alerting; build integrations using APIs, webhooks, file transfers, and database interfaces; and retire manual handoffs and older workarounds.
  • Write and tune production SQL, including transformations, views, stored procedures, and validation logic.
  • Administer SQL Server application databases, including performance, indexing, maintenance jobs, access, and schema changes.
  • Design Power BI semantic models on the gold layer, including star schemas, DAX, Direct Lake or import, incremental refresh, and row-level security; publish certified datasets.
  • Operate the Power BI environment, including workspaces, gateway, deployment pipelines, capacity, and access.
  • Coach finance and operations report authors and review their reports until they are qualified to publish independently.
  • Implement automated data quality checks and reconciliations to source systems; maintain the data dictionary, lineage, and business definitions with data owners.
  • Establish master data rules for shared records such as jobs, equipment, employees, vendors, and cost codes with the relevant data owners.
  • Apply source control, peer review, automated testing, and deployment practices to data work.
  • Manage Fabric capacity and platform costs, with monthly reporting.
  • Prepare governed, documented, access-controlled data for AI use cases and support future ERP selection through data profiling and migration planning.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service