Programmer, Sr.

Griswold Industries dba Cla-Val; Costa Mesa (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

Griswold Industries dba Cla-Val is seeking a software developer to design, develop, test, and support enterprise applications centered on Infor SyteLine ERP and MS SQL Server.

The role involves translating business needs into technical solutions, troubleshooting, and ensuring reliability, security, and performance across manufacturing, finance, payroll, inventory, and supply chain functions.

Qualifications

• Bachelor's degree in computer science or related field.
• 3+ years of application development experience.
• 3+ years of Microsoft SQL Server development experience.
• Experience supporting ERP systems in manufacturing environments.
• Experience developing system integrations and reporting solutions.

Responsibilities

• Design, develop, test, implement, document, and maintain custom business applications and components.
• Read and interpret requests; clarify needs, data rules, and outcomes.
• Support, configure, customize, and troubleshoot Infor SyteLine ERP.
• Maintain existing programs and create integrations, reports, and automated processes.
• Develop and maintain SQL Server databases, procedures, views, and jobs.
• Design and support integrations among SyteLine, third-party apps, databases, APIs, cloud platforms.
• Create operational reports, dashboards, data extracts, and datasets for decision making.
• Diagnose and resolve application, database, and data-quality issues.
• Optimize code and queries for reliability and performance.
• Assist with ERP upgrades, testing, deployments, and customizations.
• Advise and train users on functions and procedures.
• Create technical specifications and system documentation.
• Participate in testing, source control, change management, and deployments.
• Maintain data integrity and compliance with company policies.
• Collaborate across IT, Finance, Operations, and other departments on initiatives.

Skills

SQL Server

Transact-SQL

ERP systems

API integration

Source control (Git)

C#, .NET, JavaScript

Data analytics / reporting

Education

Bachelor's degree in Computer Science, Information Systems, Software Engineering, or related field

Tools

Git

SQL Server Management Studio (SSMS)

Infor SyteLine ERP

Application Event System (AES)

Job description

JOB SUMMARY

Under general supervision, designs, develops, modifies, tests, documents, and supports business applications, databases, integrations, and reporting solutions. The position supports manufacturing, finance, accounting, payroll, inventory control, production management, customer service, and supply chain operations, with primary responsibility for the Infor SyteLine ERP environment and Microsoft SQL Server.

The programmer works directly with departmental users to clarify requirements, translate business needs into effective technical solutions, troubleshoot application issues, and improve the reliability, performance, security, and usability of enterprise systems.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Design, develop, test, implement, document, and maintain custom business applications and program components.
• Read and interpret verbal and written program requests; clarify user needs, business rules, data requirements, and expected outcomes.
• Support, configure, customize, and troubleshoot the Infor SyteLine ERP environment.
• Maintain existing programs and create new applications, integrations, reports, and automated processes as business requirements change.
• Develop and maintain SQL Server databases, tables, stored procedures, views, functions, triggers, and SQL Agent jobs.
• Design and support integrations among SyteLine, third-party applications, databases, APIs, and cloud platforms.
• Create operational reports, dashboards, data extracts, and analytical datasets to support business decision-making.
• Diagnose and resolve application, database, interface, data-quality, and performance issues.
• Optimize application code, database queries, and data-processing routines for reliability and performance.
• Assist with ERP upgrades, testing, deployments, customizations, and system enhancements.
• Advise and train users on application functions, system capabilities, and appropriate procedures.
• Create and maintain technical specifications, system documentation, data mappings, test plans, and support procedures.
• Participate in software testing, source control, change management, and production deployment processes.
• Maintain data integrity and follow company standards for security, access control, backup, recovery, and regulatory compliance.
• Collaborate with Information Technology, Finance, Operations, Engineering, Customer Service, and other departments on application initiatives.
• Maintain regular punctuality, attendance, and absence reporting in accordance with company policies.
• Fully comply with company rules, policies, procedures, and safety guidelines to support safe and effective operations.
• Perform other related duties as assigned.

QUALIFICATION GUIDELINES

Any combination of education, training, and experience that provides the required knowledge, skills, and abilities may be considered.

Education and Experience

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field. An equivalent combination of education and relevant professional experience may be considered.
• Three or more years of application development experience.
• Three or more years of Microsoft SQL Server development experience.
• Experience supporting ERP systems, preferably within a manufacturing environment involving finance, accounting, payroll, inventory control, purchasing, planning, production, and customer order processing.
• Experience developing system integrations and business reporting solutions.

REQUIRED TECHNICAL SKILLS

Infor SyteLine ERP

• Hands-on experience supporting, configuring, customizing, and troubleshooting Infor SyteLine ERP.
• Knowledge of SyteLine tables, forms, Intelligent Data Objects (IDOs), business processes, data views, and queries.
• Experience with SyteLine form customization, IDO development, workflow, process automation, and the Application Event System (AES).
• Working knowledge of Infor OS and related integration capabilities.
• Ability to troubleshoot application errors, data inconsistencies, integrations, and performance issues within SyteLine.
• Understanding of manufacturing processes, including customer order processing, purchasing, inventory control, planning, production, and shop-floor operations.

Microsoft SQL Server

• Strong Transact-SQL programming skills and experience using SQL Server Management Studio (SSMS).
• Experience developing and maintaining tables, stored procedures, views, functions, triggers, and SQL Agent jobs.
• Knowledge of relational database design, normalization, indexing, query optimization, and performance tuning.
• Experience with data import, export, transformation, validation, and troubleshooting.
• Understanding of database security, access management, backup, and recovery practices.

Software Development and Integration

• Proficiency in at least one enterprise development language or platform, such as C#, .NET, VB.NET, JavaScript, or PowerShell.
• Experience with APIs, REST services, web services, data exchange, and application integration.
• Experience using source control systems such as Git.
• Ability to apply software development, testing, debugging, and documentation practices.

DESIRED TECHNICAL SKILLS

Microsoft Fabric

• Experience with Microsoft Fabric and modern analytics architecture.
• Knowledge of Fabric Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, notebooks, SQL analytics endpoints, shortcuts, semantic models, and Power BI integration.
• Experience developing ETL or ELT processes and loading ERP or operational data into Fabric.
• Understanding of data modeling, data quality, governance, security, and performance considerations in Fabric environments.

Additional Desired Skills

• Power BI report development, semantic modeling, deployment, and administration.
• Experience with Microsoft Azure data services, Power Automate, or Power Apps.
• Experience with EDI and other manufacturing or customer integrations.
• Knowledge of secure software development and cybersecurity practices.

KNOWLEDGE, SKILLS, AND ABILITIES

• Strong analytical, logical, troubleshooting, and problem-solving skills.
• Ability to translate departmental requirements into reliable, maintainable technical solutions.
• Ability to manage multiple projects and priorities while maintaining attention to detail and quality.
• Ability to communicate effectively with technical and nontechnical users and staff.
• Ability to work independently and collaboratively across departments.
• Customer-focused approach to user support, training, and continuous process improvement.
• Ability to protect confidential information and follow established security and change-control requirements.

PHYSICAL REQUIREMENTS

• Ability to operate a computer keyboard and maintain concentration for extended periods.
• Most work is performed indoors in a temperature-controlled office environment.
• Ability to sit and/or stand at a desk for most of the workday, with walking or standing as duties require.
• Requires grasping, writing, sitting, standing, walking, repetitive motion, pulling, pushing, listening, hearing ability, and visual acuity.
• Ability to operate computers, printers, filing cabinets, photocopiers, and other applicable office equipment.
• Ability to occasionally lift and/or carry up to 15 pounds.
• Ability to perform the essential functions of the job, with reasonable accommodations provided upon request.

SPECIAL REQUIREMENTS

None, unless otherwise established by the company based on business or operational needs.

ACKNOWLEDGMENT

This job description summarizes the primary duties and qualifications of the position. It is not intended to be an exhaustive list of all duties, responsibilities, or qualifications. Duties and requirements may be revised as business needs change.