Backend Data Engineer

Job Description HTC is seeking a Backend Data Engineer to build and support the backend services, data pipelines, and database structures that power the data portal. The role owns RESTful API development, ETL pipelines, synchronization and export processes, and the multi-store database foundation for both public-facing and administrative capabilities. The ideal candidate brings strong experience in PHP 8.4 / CodeIgniter 4 service-layer design, My SQL on AWs RDS and MySQL Schema design, Redis caching, and ETL / data transformation. You will work closely with the Solution Architect, Frontend Developer, DevSecOps Engineer, and QA to deliver a secure, well-structured, scalable, and extensible data foundation. Key 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. What Makes HTC A Great Place To Build Your Future HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies. At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks. Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected. #Hirnig #Remote