FileMaker Solutions Developer/Architect

Company Overview:

At Imagine we go beyond print to help our clients deliver game-changing visual communications from concept to delivery that set the standard for our industry. The first step in this process is hiring great employees! Our innovation teams are the most committed, highly experienced artisans in the business. We are committed to delivering high-quality marketing solutions, in every environment and campaign, helping our clients capture the heart, minds, and loyalty of their customers. For more than 30 years, The Imagine Group has established itself as one of the most influential and innovative visual communications companies in the industry. Join us and let's Imagine a better way together.

Job Summary:

The FileMaker Solutions Developer/Architect leads the design, development, integration, administration, and support of enterprise business applications built on the Claris FileMaker platform. This role focuses on delivering scalable solutions for custom ERP, production management, workflow automation, and reporting, while integrating FileMaker with enterprise platforms such as Monarch, SQL Server, EDI tools, and third-party APIs.

The position requires deep FileMaker expertise, along with infrastructure, database, integration, and systems architecture experience, to improve operational efficiency, strengthen system reliability, and support business transformation. 

This position requires an onsite presence in our Grayslake facility.

Job Description:

Application Architecture & Development

• Design, develop, and maintain FileMaker-based enterprise applications, including custom ERP, production, manufacturing, and workflow systems. 
• Create scalable database architectures, schemas, relationships, calculations, scripts, layouts, portals, security models, and user interfaces. 
• Optimize databases and tune system performance. 
• Lead SDLC activities including requirements gathering, business analysis, data modeling, development, testing, deployment, documentation, and ongoing support. 
• Develop and maintain test environments and ensure application reliability, maintainability, and performance. 

Process Automation & Integration

• Design integrations between FileMaker and enterprise platforms including ePS Monarch, SQL Server, EDI platforms, REST APIs, ODBC/JDBC, and third-party tools. 
• Develop automation using FileMaker Data API, REST services, JSON, SQL, scripting, and approved plugins. 
• Create automated workflows that reduce manual effort, improve data accuracy, and streamline business operations. 

Business Systems & Reporting

• Partner with business stakeholders to identify automation, reporting, and process improvement opportunities. 
• Create dashboards, analytics, KPI reporting, and operational insights for manufacturing, fulfillment, inventory, finance, and business operations. 
• Improve data governance, system reliability, and operational visibility across enterprise platforms. 

Technical Leadership

• Serve as the organization's FileMaker subject matter expert and establish development standards, best practices, and documentation expectations. 
• Provide architecture reviews, technical guidance, mentoring, system diagrams, and support for complex application issues. 

Supervisory Responsibilities:

• None

Minimum Qualifications of Position:

• High School diploma or GED. 
• 5+ years developing and supporting FileMaker solutions. 
• Experience integrating FileMaker with ERP, SQL, EDI, API, and automation platforms. 
• Experience deploying, administering, and supporting FileMaker Server environments. 

Preferred Qualifications of Position:

• FileMaker Certified Developer or FileMaker Server certification.  
• 10+ years developing and supporting FileMaker solutions. 
• 5+ years designing enterprise business systems. 
• Experience in manufacturing, fulfillment, distribution, or similar operational environments. 

Knowledge and Skills:

• FileMaker Pro, FileMaker Server, FileMaker Data API, Script Workspace 
• SQL Server, ODBC/JDBC, REST APIs, JSON, scripting, and third-party integrations 
• Database design, performance tuning, security models, reporting, dashboards, and workflow automation 

Working Conditions and Physical Requirements:

• Occasional walking  
• Manual dexterity for repetitive work 
• Frequent Sitting for prolonged periods of time 
• Travel: N/A 
• Chemicals: N/A 
• Ability to lift, push and pull: N/A 

EEO Statement:

The Imagine Group provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Pay Statement:

The national pay range for this role is listed above. The pay range may be slightly lower or higher based on the geographic location. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. Imagine offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, caregiver leave, adoption assistance, and employer/partner discounts.