Backend Data Engineer – PHP, APIs & ETL

Kastech Software Solutions Group is seeking a Backend Data Engineer to build and support backend services, data pipelines, and database structures for their data portal. The role involves developing RESTful APIs, ETL pipelines, and ensuring data quality and reliability across various environments.

Responsibilities:

• Backend API & Service Development
• 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
• Data Engineering & ETL
• 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
• Database & Data Model Design
• 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
• Data Quality, Reliability & Operational Support
• 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
• Backend API & Service Development
• 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
• Hands-on experience building backend services and REST APIs using PHP 8+ and CodeIgniter 4
• ETL pipelines for data cleansing, standardization, deduplication, aggregation, and synchronization
• Relational database schemas using MySQL, preferably on AWS RDS
• Redis caching and high-volume backend data services
• Data validation, error handling, rollback, logging, and recovery processes
• Secure, scalable backend platforms that support public-facing applications