Data Engineer
Backend Developer
Analytics
Azure Data Lake
Azure Data Platform
Azure Platform
Big Data
Business Intelligence
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Fabric
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehouse Lead
Database
Databases
Digital Marketing
ETL
Informatica
Integration
Microsoft Fabric
Reporting and Analytics
SQL
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