FileMaker Solutions Developer/Architect

The Imagine Group, LLC; Grayslake (IL); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k) with match

Paid time off

Life insurance

Tuition assistance

Caregiver leave

Employee discounts

Job summary

The Imagine Group is seeking a FileMaker Solutions Developer/Architect to lead design, development, integration, and support of enterprise FileMaker-based applications. You will deliver scalable ERP, production management, and workflow systems while integrating with Monarch, SQL Server, and APIs.

We require deep FileMaker expertise, plus infrastructure, database, and systems architecture experience to improve efficiency and reliability.

Qualifications

• High School diploma or GED required.
• 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.
• FileMaker Certified Developer or FileMaker Server certification preferred.
• 10+ years developing and supporting FileMaker solutions preferred.

Responsibilities

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

Skills

FileMaker Pro

FileMaker Server

FileMaker Data API

Script Workspace

SQL Server

ODBC/JDBC

REST APIs

JSON

Scripting

Third-party Integrations

Database Design

Performance Tuning

Security Models

Reporting

Dashboards

Workflow Automation

Education

High School diploma or GED

FileMaker Certification

10+ years developing and supporting FileMaker solutions

Tools

SQL Server

ODBC/JDBC

REST APIs

JSON

FileMaker Data API

FileMaker Pro

FileMaker Server

Job description

Description

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

Requirements

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.