Data Engineer
Job Description
MBC Holdings builds practical, governed data foundations that help teams make faster decisions and reuse trusted datasets for reporting and future AI use cases. This onsite role in Archbold, OH focuses on designing and operating a Microsoft Fabric and Azure lakehouse that connects multiple company systems, supports data quality, and powers Power BI semantic models.
What you’ll own
In your first 90 days, you will define the target architecture and then keep it running and improving. The scope includes a cloud lakehouse on Microsoft Fabric or Azure, using OneLake or ADLS storage and Delta tables with medallion layers (bronze, silver, gold). You will also establish workspaces and environments (development, test, production), the security model, naming standards, and cost controls.
Responsibilities
- Design and build ingestion from systems including ERP (IBM i, DB2), operations and project management tools, equipment telematics, HR and payroll, SQL Server applications, and other approved sources, using change data capture or incremental loads where supported.
- Develop pipelines and notebooks to move and transform data through bronze, silver, and gold using Data Factory pipelines/dataflows for orchestration and Spark notebooks (PySpark or Spark SQL) for transformation, with scheduling, monitoring, alerting, and recovery.
- Define an integration standard (patterns, tooling, error handling, retries, logging, and alerting) and implement system-to-system integrations using APIs, webhooks, file transfers, and database interfaces.
- Write and tune production SQL including transformations, views, stored procedures, and validation logic.
- Administer SQL Server application databases (performance, indexing, maintenance jobs, access, and schema changes).
- Create Power BI semantic models on the gold layer using star schemas and DAX, with support for Direct Lake or import, incremental refresh, and row level security by company and role. Publish certified datasets that report authors across the business build on.
- Operate the Power BI environment (workspaces, gateway, deployment pipelines, capacity, and access).
- Coach report authors in finance and operations and review their reports until they are qualified to publish.
- Implement automated data quality checks and reconciliations to source systems.
- Keep the data dictionary, lineage, and business definitions current with the data owners.
- Set master data rules for records shared across three companies (jobs, equipment, employees, vendors, cost codes) with the relevant owners.
- Apply software engineering practices to data work: source control, peer review, automated testing, and deployment.
- Manage Fabric capacity and report platform cost monthly.
- Prepare governed, documented data foundations for AI use cases and support future ERP selection with data profiling and migration planning.
Requirements
- Advanced SQL: complex T-SQL, query tuning, stored procedures, indexing, and execution plans.
- DB2 experience, ideally on IBM i, or the ability to become productive within 90 days.
- SQL Server administration: performance, indexing, maintenance, security, and access.
- Dimensional modeling: star schemas, normalization, and slowly changing dimensions.
- Ability to design and build a cloud lakehouse on Microsoft Fabric or Azure: OneLake or ADLS, Delta or Parquet, medallion architecture, and defend design decisions to an IT Director and a CFO.
- Experience building and operating pipelines and notebooks on that platform using Data Factory pipelines/dataflows, Spark notebooks (PySpark or Spark SQL), and orchestration tools such as Fabric, Azure Data Factory, Synapse, SSIS, or dbt.
- Integration design skills: REST APIs, OAuth and API keys, JSON, webhooks, file and database interfaces, idempotent loads, and robust error handling.
- Power BI semantic model development on lakehouse data: DAX, relationships, Direct Lake and import modes, incremental refresh, row level security, and performance tuning.
- At least one programming language for data work (Python or C# preferred).
- Experience with Git and automated deployment for data code, plus consistent habits for testing, reconciling, and documenting.
- Data security fundamentals: least privilege, encryption, secrets management, and care with payroll and personnel data.
- Clear communication: explain what the data does and does not say to finance and operations leaders in plain language.
- 5+ years building and operating data pipelines, integrations, and models, with at least 3 in a Microsoft data environment.
- Bachelor’s degree in computer science, information systems, data engineering or a related field, or equivalent experience.
Technologies you’ll work with
Microsoft Fabric, Azure, OneLake, ADLS, Delta tables, Parquet, Data Factory, Spark notebooks, PySpark, Spark SQL, 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 also count).
- HCSS products (HeavyJob, HeavyBid, Equipment360, Dispatcher), BambooHR, and telematics or equipment data from Samsara or OEM feeds.
- Fabric capacity planning and cost management, or the Azure equivalent.
- Real-time or event-based ingestion for telematics and equipment data (Fabric Real-Time Intelligence, Event Hubs, or similar).
- 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.