Job Description
Tracking Code
217788-072
Job Description
Position Overview:
We are seeking a talented and motivated Software Developer to join our dynamic team. This role is ideal for individuals who are passionate about leveraging technology to solve real-world business problems. The successful candidate will play a crucial role in developing and maintaining software solutions that meet our business needs.
Key Responsibilities:
* SQL Development:
o SQL Server:
* Develop and maintain complex T-SQL queries, stored procedures, views and functions to provision, transform and aggregate data for business consumption
* Optimize database performance and ensure data integrity.
o Oracle:
* Develop basic PL/SQL queries to effective extract data from the Oracle EBS system to support ETL initiatives
* Report Development:
o Design, develop, and deploy reports using SQL Server Reporting Services (SSRS), PowerBI and the inevitable MS Excel.
o Collaborate with key business stakeholders to gather requirements and deliver insightful data visualizations.
* Application and Interface Development:
o Develop, maintain, and troubleshoot application interfaces between on-premises and cloud applications.
o Develop basic/maintain web APIs using the .NET technology stack to facilitate communication between systems.
* ETL and Data Integration:
o Solid understanding of ETL methodologies to ensure efficient data integration and transformation.
o Experience with SQL Server Integration Services (SSIS) is a plus.
* Business Interaction:
o Engage with key business stakeholders to collect requirements and understand unique business processes.
o Ensure delivered solutions align with business needs and enhance operational efficiency.
* ERP Systems Experience (Preferred):
o Utilize experience with different ERP systems to bring a holistic understanding of business processes (SAP, Oracle EBS, Microsoft Dynamics 365).
o Support ERP-related projects and initiatives.
* C# Application Development (Preferred):
o Assist in the development of basic win-form or console applications using C#.
o Participate in code reviews and contribute to the continuous improvement of our development processes.
Qualifications:
Strong experience with SQL Server, T-SQL, SSRS, PowerBI and MS Excel
Basic application development experience (.NET c# preferred)
Excellent communication skills with the ability to interact effectively with stakeholders.
Experience in understanding and documenting business requirements.
Ability to work independently and collaboratively within a team.
Must be able to travel occasionally to manufacturing and distribution sites.
Background in manufacturing or warehousing is a plus.
Job Location
Elyria, Ohio, United States
Position Type
Full-Time/Regular
An Equal Opportunity/Affirmative Action Employer –M/F/Disabled/Vet
