Backend Data Engineer APIs & ETL
Backend Data Engineer (PHP, APIs & ETL)
Overview / Summary
HTC is seeking a Backend Data Engineer to build and support backend services, data pipelines, and database structures for the Public Health Data Portal. This role focuses on RESTful API development, ETL pipelines, synchronization processes, and multi-store database design to support both public-facing and administrative capabilities.You will collaborate with cross-functional teams to deliver a secure, scalable, and maintainable data foundation.
Key Responsibilities
Backend API & Service Development- Design and develop RESTful API services for data retrieval, metadata management, content management, authentication, audit logging, export generation, and data synchronization
- Implement authentication filters, rate limiting, request logging, and standardized JSON responses
- Build reusable service components using CodeIgniter 4 patterns
- Integrate backend services with Redis caching, AWS Secrets Manager, and SQL Server 2022 on AWS RDS
- Design and build ETL pipelines to ingest data from SQL Server staging into analytical and operational data stores
- Implement batch processing for data standardization, deduplication, cleansing, and aggregation across datasets
- Support synchronization across Dev, Test, and Prod environments
- Deliver documented ETL tools and processing logic for client handoff
- Design extensible SQL Server 2022 schemas to support future datasets
- Optimize relational structures for performance, scalability, and maintainability
- Implement multi-store analytical data patterns with pre-aggregated data
- Produce data dictionaries and technical documentation
- Implement data quality validation checks including schema validation, completeness, referential integrity, and deduplication
- Build rollback and recovery mechanisms with structured error logging
- Integrate with AWS CloudWatch, CloudTrail, and Change Log Service for audit tracking
- Ensure secure and reliable backend and data operations
- Collaborate with frontend, architecture, QA, DevOps, and project teams
- Contribute to API design, performance optimization, and delivery planning
- Produce technical handover documentation
- Write unit tests using PHPUnit and support CI/CD testing integration
- 6+ years of backend development experience with RESTful APIs and service-layer architectures
- Strong experience with PHP 8.x (ideally 8.4) and frameworks such as CodeIgniter 4, Laravel, or Symfony
- Strong SQL Server (2019/2022) experience including schema design, T-SQL, stored procedures, and performance tuning
- Hands-on experience building ETL pipelines, batch processing, and data transformation workflows
- Experience implementing data quality controls, validation logic, deduplication, and referential integrity
- Experience with synchronization, audit logging, and error handling in backend/data workflows
- Strong understanding of structured data, metadata, and extensible data models
- Experience writing unit tests with PHPUnit and integrating with CI/CD pipelines
- Strong documentation and handoff capabilities
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.
#LI-Remote #Dataengineer #LI-NC1