EngineerJobs.io
← Back to all jobs

Job Description

MBC Holdings is hiring a Data Engineer to design and operate a governed cloud data architecture in Archbold, OH (onsite).

Responsibilities

  • Design the target data architecture within the first 90 days and own it end to end
  • Implement a cloud lakehouse on Microsoft Fabric or Azure, using OneLake or ADLS storage
  • Use Delta tables and a medallion approach (bronze, silver, gold) across development, test, and production workspaces/environments
  • Define and enforce the security model, naming standards, and platform cost controls
  • Build ingestion from ERP (IBM i, DB2), operations, and project management systems, equipment telematics, HR and payroll, SQL Server applications, and other approved sources
  • Leverage change data capture and/or incremental loads when supported by source systems
  • Create pipelines and notebooks that move data through layers
  • Orchestrate with Data Factory pipelines and dataflows, transform with Spark notebooks (PySpark or Spark SQL)
  • Include scheduling, monitoring, alerting, and recovery
  • Define system integration standards (patterns, tooling, error handling, retries, logging, alerting) and implement system-to-system integrations via APIs, webhooks, file transfers, and database interfaces
  • Develop and tune production SQL: transformations, views, stored procedures, and validation logic
  • Administer SQL Server application databases (performance, indexing, maintenance jobs, access and schema changes)
  • Design Power BI semantic models on the gold layer (star schemas, DAX, Direct Lake or import, incremental refresh, row level security by company and role)
  • Publish certified datasets that enable reporting authors across the business
  • Operate the Power BI environment (workspaces, gateway, deployment pipelines, capacity, and access)
  • Coach report authors in finance and operations; review reports until they are qualified to publish independently
  • Implement automated data quality checks and reconciliations to source systems
  • Maintain a current data dictionary, lineage, and business definitions with data owners
  • Set master data rules for records shared across the three companies (jobs, equipment, employees, vendors, cost codes)
  • Treat data work as code: source control, peer review, automated testing, and deployment
  • Manage Fabric capacity and report platform cost monthly
  • Prepare the data foundation for AI use cases (clean, governed, documented data with access controls) and support future ERP selection with data profiling and migration planning

Requirements

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

Technologies

  • Microsoft Fabric, Azure, OneLake, ADLS
  • Delta tables, Delta, Parquet
  • Data Factory, Spark notebooks, PySpark, Spark SQL, Fabric, Azure Data Factory, Synapse, SSIS, dbt
  • REST APIs, OAuth, API keys, JSON, webhooks
  • SQL Server, T-SQL, DB2, IBM i
  • Power BI, DAX, Direct Lake, incremental refresh, row level security
  • Git, Python, C#
  • HCSS, Samsara, BambooHR

Nice to Have

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

Similar Jobs