Description
Find YOUR fit at Ohio Machinery Co.! Join a winning culture that strives to be the top-performing dynamic industry leader and partner of choice for the products and solutions that help our customers build improve feed power and protect our world. Come grow your career - See what opportunities await today!
Summary:
The Data Engineers 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.
Essential Functions and Responsibilities:
- Microsoft Fabric / Azure
- 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.
- Data Modeling & BI
- 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.
- Data Engineering Core Skills
- 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.
- Collaboration
- 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 databases and 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.
Minimum Skills and 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 service database 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.
- A highly qualified candidate would be familiar with some of the following: Sharepoint Online MS Power Automate PowerBI Reporting Services 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 ability to multi-task.
- 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%.)
Employee 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 $1200 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.
EEO Veterans & Disabled Employer and VEVRAA/503 Federal Contractor
Required Experience:
IC
DescriptionFind YOUR fit at Ohio Machinery Co.! Join a winning culture that strives to be the top-performing dynamic industry leader and partner of choice for the products and solutions that help our customers build improve feed power and protect our world. Come grow your career - See what opportuni...
Description
Find YOUR fit at Ohio Machinery Co.! Join a winning culture that strives to be the top-performing dynamic industry leader and partner of choice for the products and solutions that help our customers build improve feed power and protect our world. Come grow your career - See what opportunities await today!
Summary:
The Data Engineers 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.
Essential Functions and Responsibilities:
- Microsoft Fabric / Azure
- 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.
- Data Modeling & BI
- 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.
- Data Engineering Core Skills
- 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.
- Collaboration
- 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 databases and 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.
Minimum Skills and 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 service database 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.
- A highly qualified candidate would be familiar with some of the following: Sharepoint Online MS Power Automate PowerBI Reporting Services 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 ability to multi-task.
- 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%.)
Employee 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 $1200 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.
EEO Veterans & Disabled Employer and VEVRAA/503 Federal Contractor
Required Experience:
IC
View more
View less