Note: The job is a remote job and is open to candidates in USA. Resource 1, Inc. is seeking Data Engineers for remote contract work supporting a healthcare-industry client. The role focuses on building and maintaining AWS data pipelines, reviewing AI-generated Python and SQL code, validating data outputs, and producing accurate outbound deliverables in collaboration with client and internal data engineering teams.
Responsibilities
- Ingest, parse, and transform inbound files in multiple formats (CSV, fixed-width, 834, etc.)
- Develop, edit, and maintain AWS Lambda-based functions using Python and Pandas
- Review SQL queries against Amazon Redshift to validate data for outbound reports
- Use internal agentic AI outbound-generator tool to review code and produce final files
- Validate and verify generated files against mapping specifications and Jira tickets
- Implement targeted changes during client implementations and support existing pipelines
- Follow CI/CD, pull request review, and deployment processes across dev, pre-prod, and production environments
- Collaborate with product stakeholders, and Sr. Data Engineers via Jira to clarify requirements and obtain validations
- Execute testing in staging environments, remediate issues, and iterate until operations approves deliverables
Skills
- • Strong Python proficiency with hands-on experience using Pandas for data transformations
- • Proficient in SQL and experience querying Amazon Redshift or similar columnar databases
- • Experience building and maintaining AWS Lambda functions and knowledge of AWS S3
- • Familiarity with multiple incoming file formats (CSV, fixed-width, 834) and file parsing techniques
- • Understanding of ETL patterns, data validation, and producing bespoke outbound reports
- • Comfortable working in CI/CD workflows and following deployment pipelines
- • Strong communication skills and ability to collaborate with operations and stakeholders
- • Experience with PySpark for larger or more complex data processing tasks
- • Previous healthcare PBM, TPA, or claims processing experience
- • Experience working with agentic AI or code-generation tools to accelerate data engineering tasks
Benefits
- Fully remote (US) work arrangement
Company Overview