Data Applications Engineer - Piqua, United States - Hartzell Propeller

Hartzell Propeller Piqua, United States

2 weeks ago

Description

Hartzell Aviation

With a history dating back to the Wright Brothers, Hartzell Aviation is a growing family of brands committed to innovation and the continuous improvement of general aviation and is owned by Arcline Investment Management, a growth oriented private equity firm who invests in niche, technology driven businesses in high value industries.

Hartzell Aviation focuses on investing in world-class processes and leading-edge technologies to support today's aircraft owners and operations.

Each of the companies in the Hartzell Aviation family of brands is unified by the same core value:
Built on Honor. Built on Honor reflects a collective commitment to uphold the highest standards in quality, performance and support. Built on Honor is integral to everything we do.

Hartzell Propeller

Hartzell Propeller LLC (HPI) was founded in 1917 and is headquartered in Piqua, Ohio. HPI is a world class engineering and manufacturing company offering the broadest range of propeller systems in the aviation industry. We design, develop, test, manufacture, and support constant-speed aluminum and composite propeller systems for all categories of aircraft, ranging from general aviation to military applications. The company traces its history to 1914, where a relationship between Orville Wright and Robert Hartzell led to the manufacture of the first Hartzell propeller.

Key Responsibilities

Hartzell seeks an experienced Data Applications Engineer with a strong focus on SQL to join our team.

The ideal candidate will have a passion for designing, developing, and maintaining data-driven applications and systems that support our business intelligence, analytics, and data processing needs.

This role requires a deep understanding of SQL databases, data modeling, and the ability to work closely with cross-functional teams to deliver scalable data solutions.

The Data Applications Engineer will be responsible to support the existing ERP initiatives and reporting.

This position is responsible to support all sites in the Hartzell family so the candidate could work from the Ohio, Alabama, Minnesota or Oklahoma site.

Key Deliverables

1) Collaborate with stakeholders to understand data requirements and translate business needs into technical specifications.

a. Design, develop and maintain efficient reusable, and reliable SQL code to support data applications and analytical reports.

b. Create reports, dashboards, and visualizations in Power BI, leveraging SQL, Python and R to provide dynamic and interactive insights.

2) Develop and optimize SQL databases, data warehouses and data lakes for optimal performance and scalability.

a. Implement data pipelines, ETL Processes, and data integration tasks to ensure seamless data flow across systems.

b. Ensure data quality and integrity by implementing data validation and cleaning processes.

3) Stay current with the latest technologies and best practices in data engineering; propose improvement to our data systems.

4) Actively support and enhance existing ERP initiatives, focusing on the integration of ERP data with other business intelligence tools and databases.

a.

Develop and maintain custom reports and dashboards within the ERP system, ensuring they meet organizational needs for real time data access and decision support.

Collaborate with ERP users and IT staff to understand business processes and requirements, aiming to optimize ERP system performance and functionality through tailored data applications and reporting solutions.

c. Participate in ERP upgrade projects, including testing and validating data integrity and application performance post-upgrade.

d.

Ensure that ERP data management practices align with company-wide governance and security policies, maintain the integrity and confidentiality of sensitive information.

First Year Success Factors

1) Gain an in-depth understanding of the organization's business systems and data requirements.

2) Understand the fundamentals of the data structures, modeling and processing techniques

Requirements

Required Education and Experience

Bachelor's degree in Information Technology, Computer Science or a related field or relevant experience.

Ideal candidate will have a minimum of 3 years of experience in a data engineering role with a strong focus on SQL.

Required Technical Competencies

1) Excellent verbal and written communication skills

2) Proficiency in SQL and experience with relational databases.

3) Experience with data modeling, ETL processes and data warehousing principles.

4) Familiarity with data visualization tools (e.g. Power BI) and reporting techniques.

5) Strong project management skills with the ability to manage multiple tasks simultaneously.

Desired Technical Skills

1) Familiarity with data visualization tools and reporting techniques beyond Power BI

2) Experience with cloud data services (AWS, Google Cloud or Azure)

3) Knowledge of programming languages such as Python, or JAVA for data processing, automation & analysis

4) Experience with ERP system migrations or upgrades; ability to develop custom ERP reports and dashboards with an understanding of the financial, supply chain and operational modules; Knowledge of ERP integration techniques, including the use of APIs or middleware for connecting ERP systems with external databases and applications.

5) Strong experience in creating dynamic reports, dashboards and visualizations using Power BI.

Behavioral Characteristics

1)
Analytical Mindset - a disciplined problem solver with the ability to analyze complex data challenges and break them down into manageable components.

2)
Customer Focus - Establishes and maintains effective relationships with customers and gains their trust and respect; acts with customers in mind and is dedicated to meeting the expectations of both internal and external customers.
3) Drives for Results - is action-oriented member of the team who can be counted on to meet goals successfully; steadfastly pushes self for results. Manages workload effectively, sets priorities and meets deadlines while balancing multiple tasks and projects.
4)
Continuous Learning - Demonstrates a commitment to learning and staying updated on industry trends and best practices.

5)
Teamwork and Collaboration - Works effectively as part of a team, collaborates with colleagues from different departments. Shares knowledge and expertise.

6)
Professional with a High Level of Integrity - Maintains professionalism, ethical conduct and integrity in all interactions and decisions.

Wage and Benefit Information

At Hartzell Propeller Inc., we pride ourselves in offering competitive wages as well as a benefit package that includes, paid vacation, 10 paid holidays, medical, dental, and vision plans that begin on the first day of employment along with wellness incentives, paid family leave, 401(k) with a 3% match as well as a 3% quarterly contribution, company paid disability and life benefits, and more.

EEO/AA/E-Verify Employer

Application Engineer

2 weeks ago

SCN - Search Consulting Network Troy, United States

My name is Jessica Birndorf, a Recruiter with SCN ). · We are partnering with a top Automation company who is hiring for an Applications Engineer (Mechanical). · Company Highlights · The company has been in business for over 90 years · Today the company has a network of 16 produc ...
Application Engineer

3 weeks ago

SCN - Search Consulting Network Troy, United States

My name is Jessica Birndorf, a Recruiter with SCN ). · We are partnering with a top Automation company who is hiring for an Applications Engineer (Mechanical). · Company Highlights · The company has been in business for over 90 years · Today the company has a network of 16 pr ...
Application Engineer

2 weeks ago

Freudenberg Group Troy, United States

Working at Freudenberg: We will wow your world · Responsibilities:Learn a broad range of fundamental sealing applications including static and dynamic seals, and O-rings in addition to new potential opportunities in the eMobility and electrification specialized application areas ...
Application Engineer

2 weeks ago

Freudenberg Group Troy, United States

Working at Freudenberg: We will wow your world · Responsibilities: · Learn a broad range of fundamental sealing applications including static and dynamic seals, and O-rings in addition to new potential opportunities in the eMobility and electrification specialized application a ...
Applications Engineer

3 weeks ago

Scnteam Troy, United States

My name is Jessica Birndorf, a Recruiter with SCN ). · We are partnering with a top Automation company who is hiring for an Applications Engineer (Mechanical). · Company Highlights · The company has been in business for over 90 years · Today the company has a network of 16 pr ...
Applications Welding Engineer

4 weeks ago

ITW Troy, United States

Company Description · Hobart Brothers LLC, an Illinois Tool Works Company within the Welding Group, is a recognized leader in the manufacturing and distribution of welding consumables worldwide. We create customer success in metal fabrication around the world. Safety, quality, a ...
Applications Welding Engineer

3 weeks ago

ITW Troy, United States

Company Description · Hobart Brothers LLC, an Illinois Tool Works Company within the Welding Group, is a recognized leader in the manufacturing and distribution of welding consumables worldwide. We create customer success in metal fabrication around the world. Safety, quality, a ...
Applications Engineer

3 weeks ago

NOV, Inc. Dayton, United States

Job Description · KEY RESPONSIBILITIES: · The specific duties of an Application's Engineer are as follow:Review quote requests from representatives and customers. Based on the information provided, the Application Engineer must design and price proper equipment and issue a writ ...
Applications Engineer

4 days ago

PowerBuilt Material Handling Solutions, LLC Bellefontaine, United States

Job Description · Job Description · Position: Applications Engineer · Direct Report To: Director – Electrical Engineering · Primary Location: Dublin or Bellefontaine · Manufacturing Location: Bellefontaine, Ohio · PowerBuilt is a turn-key material handling systems integrator. O ...
Applications Engineer

3 weeks ago

PowerBuilt Material Handling Solutions, LLC Bellefontaine, United States

Job DescriptionJob Description · Position: Applications Engineer · Direct Report To: Director – Electrical Engineering · Primary Location: Dublin or Bellefontaine · Manufacturing Location: Bellefontaine, Ohio · PowerBuilt is a turn-key material handling systems integrator. O ...
Applications Engineer

2 weeks ago

NOV Dayton, United States

JOB DESCRIPTION · KEY RESPONSIBILITIES: · The specific duties of an Application's Engineer are as follow:Review quote requests from representatives and customers. Based on the information provided, the Application Engineer must design and price proper equipment and issue a writte ...
Applications Engineer

1 week ago

PowerBuilt Material Handling Solutions Bellefontaine, United States

Job Description · Job DescriptionPosition: Applications Engineer · Direct Report To: Director – Electrical Engineering · Primary Location: Dublin or Bellefontaine · Manufacturing Location: Bellefontaine, Ohio · PowerBuilt is a turn-key material handling systems integrator. Our e ...
Applications Engineer

1 week ago

NOV Inc Dayton, United States Full time

KEY RESPONSIBILITIES: · The specific duties of an Application's Engineer are as follow: · Review quote requests from representatives and customers. Based on the information provided, the Application Engineer must design and price proper equipment and issue a written quotation to ...
Planning Engineer

2 days ago

Skyline Enterprises Piqua, United States

WHAT WE ARE LOOKING FOR · Project management for investment projects in the field of artillery works, mechanical production, and ammunition production (machines, equipment, special machines) · Coordination of necessary resources and coordination of necessary measures · Preparatio ...
Field Technician

2 days ago

NV5 Miami Lakes, United States

Overview: · NV5 is a provider of engineering and consulting services to public and private sector clients, delivering solutions through six business verticals: Testing, Inspection & Consulting; Infrastructure; Utility Services; Environmental Health Sciences; Buildings & Program M ...
Environmental Specialist Ii

1 week ago

The State of Florida Miami Lakes, United States

Requisition No: 829893 · Agency: Agriculture and Consumer Services · Working Title: ENVIRONMENTAL SPECIALIST II · Pay Plan: Career Service · Position Number: · **Salary**: $40, $44,386.16 · Posting Closing Date: 05/30/2024 · **Total Compensation Estimator **Tool** · **ENVIRONME ...
Applications Engineering Manager

2 weeks ago

Lincoln Electric Fort Loramie, United States

Lincoln Electric is the world leader in the engineering, design, and manufacturing of advanced arc welding solutions, automated joining, assembly and cutting systems, plasma and oxy-fuel cutting equipment, and has a leading global position in brazing and soldering alloys. Lincoln ...
Mechanical Application Engineer

1 week ago

Joyce/Dayton Corp. Dayton, United States

Join Our Passionate and Vibrant Team Today US CITIZENS ONLY · Do you love working on unique applications and providing world-class customer service? Joyce/Dayton is searching for a Mechanical Applications Engineer to provide innovative linear motion solutions to customers · Are ...
Sales Application Engineer

3 weeks ago

Johnson Electric Vandalia, United States

Come Innovate Motion with Us · Johnson Electric (JE) is excited to announce that we are now recruiting for an Application Engineer for our Vandalia, OH location. In this role you will support JE customers in implementing and utilizing our products effectively. The AE will work ...
Applications Concept Engineer

3 weeks ago

Lincoln Electric Fort Loramie, United States

Lincoln Electric Automation, Fort Loramie, OH, a subsidiary of Lincoln Electric, specializes in laser welding, robotic welding and fixturing, press automation, and tube bending/fabricating systems which further strengthens Lincoln Electric's already strong position as a market le ...