Backend Data Engineer – PHP, APIs & ETL (Remote)

GG Tech Global is seeking a Backend Data Engineer to build and support backend services and data pipelines for their data portal. The role involves developing RESTful APIs, managing ETL processes, and designing database structures to ensure a robust data foundation.

Responsibilities:

• Design and develop RESTful API services covering data retrieval, metadata management, content management, audit logging, export generation, and data synchronization
• Implement cross-cutting concerns including authentication filters, rate limiting, request logging, and standardized JSON response formatting
• Build reusable service components and CodeIgniter 4 framework patterns that support maintainable, scalable behavior
• Integrate backend services with Redis caching, MySql on AWS RDS
• Implement batch processing for data standardization, deduplication, cleansing, and aggregate generation across indicators, measures, and geographies (State, County, CSA)
• Support synchronization between source, processed, and application-facing data structures through the one-way Dev → Test → Prod flow
• Deliver documented ETL tools and processing logic that can operate independently after handoff
• Design extensible MySQL schemas supporting onboarding of future datasets (Birth, Hospital Discharge) without application changes
• Build and optimize relational structures for performance, scalability, and maintainability under public query loads
• Implement multi-store analytical patterns with pre-aggregated data for responsive interactive queries
• Produce data dictionaries and technical documentation to support long-term operations
• Implement data quality validation checks: schema validation, completeness, suppression preservation, referential integrity, integrity checks, and deduplication
• Build automated rollback and recovery mechanisms for synchronization failures with structured error logging
• Ensure reliable, secure, and auditable backend and data operations across all environments

Requirements:

• Strong experience in PHP 8.4 / CodeIgniter 4 service-layer design
• MySQL on AWS RDS and MySQL Schema design
• Redis caching
• ETL / data transformation
• Design and develop RESTful API services covering data retrieval, metadata management, content management, audit logging, export generation, and data synchronization
• Implement cross-cutting concerns including authentication filters, rate limiting, request logging, and standardized JSON response formatting
• Build reusable service components and CodeIgniter 4 framework patterns that support maintainable, scalable behavior
• Integrate backend services with Redis caching, MySQL on AWS RDS
• Implement batch processing for data standardization, deduplication, cleansing, and aggregate generation across indicators, measures, and geographies (State, County, CSA)
• Support synchronization between source, processed, and application-facing data structures through the one-way Dev → Test → Prod flow
• Deliver documented ETL tools and processing logic that can operate independently after handoff
• Design extensible MySQL schemas supporting onboarding of future datasets (Birth, Hospital Discharge) without application changes
• Build and optimize relational structures for performance, scalability, and maintainability under public query loads
• Implement multi-store analytical patterns with pre-aggregated data for responsive interactive queries
• Produce data dictionaries and technical documentation to support long-term operations
• Implement data quality validation checks: schema validation, completeness, suppression preservation, referential integrity, integrity checks, and deduplication
• Build automated rollback and recovery mechanisms for synchronization failures with structured error logging
• Ensure reliable, secure, and auditable backend and data operations across all environments