Data Engineer

Summary

The Data Engineer's role is to plan, design, develop, test, implement, and maintain efficient information systems with a primary focus on building scalable data pipelines, Lakehouse environments, semantic models, and governed datasets to support business intelligence and advanced 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 and external stakeholders such as third-party software vendors.

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 and maintain semantic models for reporting teams.
• Work closely with reporting developers (Power BI) to ensure performant data models.
• Optimize large-scale datasets for consumption and self-service analytics.
• Design, build, and maintain scalable and reliable data pipelines.
• Work with structured/unstructured data, Delta Lake, parquet, and data lake formats.
• Implement best practices for data quality, lineage, monitoring, and observability.
• Improve data performance through indexing, partitioning, caching, and optimization.
• Work with business stakeholders to gather requirements.
• Contribute to data governance and metadata management practices.
• Ensure the integrity and security of enterprise data on host computers and databases, and during data transfers, in accordance with business needs and industry best practices regarding privacy, security, and compliance.
• Conduct research on emerging products, services, protocols, and standards in support of systems software procurement and development efforts.
• Develop, document, and maintain policies, procedures, and associated training plans for system administration and appropriate use.
• Provide guidance and serve as an escalation to Help Desk.
• Recommend, schedule, and perform software and related system improvement, upgrades, patches, reconfigurations, and/or purchases.

Qualifications

• College degree or equivalent experience in information technology.
• Related industry certifications are expected.
• Strong knowledge of API Integration & Development.
• Enterprise application integration and other middleware technologies, such as web services, databases, and application/content integration.
• 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.
• 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%).

Preferred Qualifications

• SharePoint Online
• MS Power Automate
• Power BI
• Reporting Services
• Excel (Pivot Tables)
• Experience documenting and maintaining configuration and process information.

Benefits

• 401(k): Match and employer discretionary contribution.
• Health Insurance: Two options are available, including an HSA with a dollar-for-dollar match of up to $1,200 per year.
• Dental & Vision Insurance: Comprehensive coverage options.
• Financial Access: Credit Union membership is available.
• Insurance: Life Insurance, Short-Term Disability, and Long-Term Disability coverage.
• Educational Opportunities: Scholarships for employees' spouses and children through the Ohio Machinery Education and Opportunity Foundation.
• Compensation: Base pay, annual bonus potential, and company success share bonuses.

Physical Requirements

• Sitting for extended periods of time.
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and to handle other computer components.
• Lifting and transporting of moderately heavy objects, such as computers and peripherals.