What are the responsibilities and job description for the Software Developer (L0890) position at PETE LIEN & SONS, INC?
Design, develop, test, and support technical solutions to meet business needs, including integration solutions, industrial control and reporting systems.
We are seeking a Systems Integration and Reporting Developer to design, develop, and maintain integration solutions between various enterprise applications, databases, and third-party systems, as well as reporting systems that deliver actionable insights. The ideal candidate will have experience with APIs, middleware, ETL processes, messaging frameworks and reporting tools (Power BI, SSRS), ensuring seamless data exchange, automation, and decision-making support.
Duties and Responsibilities
- Integration Development:
- Design, develop, and maintain integrations between ERP, POS, Dispatch, HCM, ICS, and other enterprise systems.
- Develop clean, understandable, and testable solutions and code as part of an Agile team.
- Troubleshoot and resolve integration issues in a timely manner to ensure system reliability.
- Collaborate with cross-functional teams to understand business requirements and implement solutions.
- Work with Operational Technology on the implementation and support of Industrial Control Systems (ICS).
- Reporting Development:
- Design, develop, and maintain Power BI dashboards and SSRS reports based on business requirements.
- Write and optimize complex SQL queries for data retrieval, transformation, and analysis from SQL Server and Oracle databases.
- Best Practices:
- Perform unit tests and peer code reviews to ensure quality and maintainability.
- Ensure data integrity, security, and compliance with industry standards
- Update and maintain system and process design documents.
Required Skills & Qualifications
- Integration & Development:
- Proven experience in ERP system integration (Oracle ERP, Microsoft Dynamics 365, IFS, SAP, NetSuite, or similar).
- Strong proficiency in C#, .NET, Python for integration development.
- Experience with RESTful APIs, SOAP, JSON, XML, OData, GraphQL.
- Experience with middleware technologies.
- Strong knowledge of ETL processes for data transformation and migration.
- Experience with message queues (e.g., Azure Service Bus) and event-driven architecture.
- Familiarity with EDI (Electronic Data Interchange) standards.
- Data, Reporting & Optimization:
- Proven experience in report development using Power BI and SSRS.
- Strong SQL development skills with expertise in MSSQL and Oracle.
- Knowledge of DAX (Power BI), MDX (Multidimensional Expressions).
- Experience with report performance tuning and database optimization.
- Ability to work with large datasets to ensure efficient data processing.
- Industrial Control Systems (ICS) & IIoT:
- Experience with ICS / SCADA.
- Experience with HMI design and scripting,
- Knowledge of OPC/Modbus protocols and IIoT technologies.
- Basic understanding of PLC programming.
- Architecture & Best Practices:
- Strong understanding of event-driven architecture.
- Knowledge of design patterns and principles: SOLID (SRP, OCP, LSP, ISP, DIP).
- Security-minded design and development.
- Familiarity with CI/CD pipelines and DevOps practices for integration deployment and monitoring.
Additional Benefits:
- Opportunity to work on cutting-edge integration projects.
- Professional development and career growth opportunities.
- Access to professional development programs, courses, certifications, and conferences.
A complete company description can be found here: Job Description