Intranet Applications Specialist, Sr. - Web jobs in Springfield, OH

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.

b. 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.

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