Title: Quickbase Developer
Location: Remote
Duration: 1+ year

Job Description: Quickbase Integration & Data Automation Developer
Quickbase Integration & Data Automation Developer

QuickBase Summary
Quickbase is a low-code, cloud-based application platform that helps organizations build custom business applications, centralize data, automate workflows, and connect information across teams and systems. Companies commonly use Quickbase to replace manual spreadsheet-based processes, manage complex operational workflows, improve visibility through dashboards and reports, and support integration between business systems without requiring full custom software development. At Blue Cross, Quickbase is used to support contracting and provider data workflows by organizing complex contract information, enabling data imports and reconciliation, and helping automate operational processes that rely on accurate provider and contract relationships.


Position Summary
The Quickbase Integration & Data Automation Developer is responsible for developing and maintaining data integration solutions that automate the ingestion, transformation, remediation, and synchronization of contracting and provider data within the Quickbase platform, while assisting team members with solution design and data architecture decisions. A major focus of this role will be supporting a significant change to the provider data received and uploaded into Quickbase, including interpreting new provider data specifications, mapping revised data structures into existing Quickbase applications, and remediating impacted applications, tables, relationships, workflows, reports, and automations. This role will help build scalable Quickbase applications and integrations that load complex contracting and provider data into one-to-many relational Quickbase tables, automate provider data imports, perform data validation and reconciliation, and leverage the resulting datasets to drive operational workflows, compliance processes, and business automation.
The ideal candidate has deep experience with Quickbase data architecture, REST APIs, JSON processing, Pipelines, ETL processes, and workflow automation.

Key Responsibilities
Data Integration & ETL Development
• Assist with the design and development of automated processes to ingest contracting JSON files into Quickbase.
• Build and maintain one-to-many and many-to-many data relationships supporting complex contract structures.
• Support team-defined data mapping frameworks between source files and Quickbase tables.
• Create automated imports for provider data from external systems and file feeds.
• Analyze new provider data files, field definitions, and data specifications to determine required Quickbase table, field, and relationship changes.
• Develop migration and transition processes to bring revised provider data into Quickbase while maintaining data integrity and continuity with existing contracting workflows.
• Develop ETL processes to:
o Extract data from APIs, JSON, CSV, Excel, and flat files
o Transform and normalize incoming datasets
o Load data into appropriate Quickbase tables
• Manage file-based integrations including SFTP, APIs, webhooks, and scheduled imports.
• Create robust exception handling and error reporting mechanisms.

Data Remediation & Reconciliation
• Assist with implementing automated data matching and remediation processes based on team-defined design direction.
• Reconcile contract data against provider datasets.
• Identify and resolve:
o Missing records
o Duplicate records
o Data inconsistencies
o Invalid provider identifiers
o Contract-provider relationship issues
• Create dashboards and audits to monitor data quality.
• Develop workflows that flag records requiring manual review.
• Build exception queues and remediation workflows.

Quickbase Solution Development
• Assist with solution design and build Quickbase applications, tables, relationships, forms, reports, and dashboards based on agreed requirements.
• Implement scalable data models supporting:
o Providers
o Contracts
o Networks
o Facilities
o Affiliations
o Contract terms
o Workflow transactions
• Develop advanced Quickbase formulas and summary fields.
• Configure role-based security and governance controls.
• Optimize application performance for large datasets.
• Remediate existing Quickbase applications impacted by new provider data structures, including table design, field definitions, formulas, relationships, dashboards, reports, forms, workflows, and automations.

Workflow Automation
• Assist with design and develop Quickbase Pipelines for integration and workflow processing.
• Build event-driven and scheduled automations.
• Troubleshoot and optimize pipeline performance.

API & Integration Development
• Develop and maintain integrations using:
o Quickbase REST API
o JSON
o External REST APIs
o Webhooks
o SFTP
• Create reusable integration components and services.
• Develop data mapping and transformation specifications.
• Maintain technical integration documentation.

Business Process Automation
• Collaborate with business and operational stakeholders to understand contracting and provider management processes.
• Translate business requirements into technical configuration and implementation tasks in collaboration with team members responsible for solution design.
• Recommend automation opportunities and workflow improvements.
• Support testing, deployment, and user training.
• Participate in solution architecture and governance reviews.

Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or equivalent experience.
• 5+ years of experience building solutions on the Quickbase platform.
• 3+ years of experience integrating external data sources with business applications.
• Strong experience with:
o Quickbase Pipelines
o Quickbase Relationships
o Formula Queries
o Summary Fields
o Quickbase REST API
o JSON processing
o Data mapping
• Experience loading and transforming large JSON datasets.
• Experience supporting one-to-many relational data models and implementing application changes based on defined data architecture.
• Experience developing automated reconciliation and remediation workflows.
• Experience interpreting changing data specifications and modifying existing applications or integrations to align with new source data requirements.
• Strong SQL and data analysis skills.
• Strong analytical and problem-solving skills.

Preferred Qualifications
• Quickbase Certified Expert.
• Experience in healthcare
• Experience supporting enterprise integration architecture efforts.
• Experience with Master Data Management (MDM) principles. 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $50.00/hr - $53.00/hr.