Programmer, Sr.

Griswold Industries dba Cla-Val • Costa Mesa, CA

4d • $57,344 - $129,026 • Onsite

About The Position

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.

Requirements

• 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.
• 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.
• 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.
• 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.
• Ability to operate a computer keyboard and maintain concentration for extended periods.
• 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.

Nice To Haves

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

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.

Benefits

• Pre-employment substance abuse and physical screening
• Verification of documents pertaining to your right to work in the United States using E-VERIFY
• Completion of required employment documents

What This Job Offers

• Job Type: Full-time
• Career Level: Senior