Data Engineer: Lakehouse & Analytics Architect

Ohio Cat; Broadview Heights (OH); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

401(k) Match

Health Insurance (HSA)

Dental & Vision

Credit Union

Life Insurance

Disability Insurance

Educational Scholarships

Bonus potential

Job summary

Ohio Machinery Co. in Cleveland, OH is seeking a Data Engineer to design, develop, test, and maintain scalable data pipelines and governed datasets to support BI and analytics.

This individual will apply proven communication, analytical, and problem-solving skills to help identify, plan, and implement integrations between disparate systems to maximize the benefit of business system investments. Frequent interaction is required with internal analysts, project leaders, as well as other internal

Qualifications

• College degree or equivalent experience in information technology.
• Related industry certifications are expected.
• Strong knowledge of API Integration & Development.
• Experience with Microsoft Fabric (Data Factory, Lakehouse, Warehouse).
• Familiarity with Azure Data Services (ADLS, Synapse, ADF, Databricks, etc.).
• Strong SQL development expertise.
• Experience with Microsoft SharePoint or similar collaboration tools.
• A highly qualified candidate would be familiar with some of the following: SharePoint Online, MS Power Automate, Power BI, Reporting Services, and Excel (Pivot Tables).
• Experience documenting and maintaining configuration and process information.
• Knowledge of applicable data privacy practices and laws.
• Strong interpersonal, written, and oral communication skills.
• Excellent time management and multitasking ability.
• Highly self-motivated and directed, with strong attention to detail.
• After hours and weekends, on-call availability.
• Reliable transportation and freedom to travel upon request. (Less than 10%).

Responsibilities

• Build and maintain Fabric Lakehouses, Data Warehouses, and OneLake storage layers.
• Develop Fabric Data Pipelines (Data Factory) for ingestion, transformation, orchestration, and automation.
• Create and optimize Spark notebooks for ETL/ELT workloads.
• Implement medallion architecture (bronze/silver/gold) within Fabric.
• Manage and monitor workloads using Fabric capacities, workspaces, and governance features.
• Build semantic models; collaborate with Power BI teams.
• Optimize large-scale datasets for consumption and self-service analytics.
• Collaborate with stakeholders to gather requirements and ensure security/compliance.
• Document policies and provide training for system admin.
• Provide escalation to Help Desk and plan upgrades.

Skills

API Integration

SQL development

Communication

Time management

Attention to detail

Education

College degree or equivalent

Industry certifications

Tools

Microsoft Fabric

Azure Data Services

SharePoint

Power BI

Power Automate

Excel

Job description

Ohio Machinery Co. in Cleveland, OH is seeking a Data Engineer to design, develop, test, and maintain scalable data pipelines and governed datasets to support BI and analytics.

This individual will apply proven communication, analytical, and problem-solving skills to help identify, plan, and implement integrations between disparate systems to maximize the benefit of business system investments. Frequent interaction is required with internal analysts, project leaders, as well as other internal