Note: The job is a remote job and is open to candidates in USA. Kforce Inc is seeking a Remote Data Engineer to join their client in NYC. The role involves developing and optimizing ETL processes, defining data engineering architecture, and ensuring the health of data pipelines across various platforms.
Responsibilities
- Develop, maintain, and optimize SQL-based ETL processes, stored procedures, and data transformations across DB2, SQL Server, Datastage, Collibra and AWS
- Define the enterprise data engineering architecture and technology standards across DB2, SQL Server, IBM DataStage, IBM Workload Scheduler, Oracle GoldenGate, Collibra and AWS
- Develop and maintain data integration workflows from source systems to analytics platforms, including validation and reconciliation logic
- Build and maintain data pipelines using IBM DataStage and UNIX scripting for enterprise data integration workflows
- Govern platform health including capacity planning, performance benchmarks, upgrade management, and disaster recovery compliance with BCP/DR standards
- Lead workload rationalization - identifying pipelines, stored procedures, and jobs for consolidation, retirement, or re-architecture
- Evaluate and drive adoption of modern data engineering capabilities (Apache Airflow, dbt, AWS Glue, Spark) aligned to Project Catalyst objectives
- Monitor pipeline health proactively, detect anomalies, and resolve data quality and availability issues within defined SLAs
- Support Dev/QA/Prod environment management including release coordination and production readiness validation
- Assist with AWS stabilization activities for analytics data layers post migration from on-premises infrastructure
- Track and manage all work through ServiceNow, ensuring accurate classification, status updates, and SLA compliance
- Collaborate with Tableau, SAS and BusinessObjects developers to ensure data availability and pipeline reliability for reporting
Skills
- Minimum Degree Required: Bachelor's degree in Engineering, Statistics, Mathematics, Computer Science, Data Science, Economics, or a related quantitative field
- AWS certification - Data Engineer Professional, Solutions Architect Professional, or equivalent
- 8+ years of data engineering experience with deep expertise in enterprise ETL/ELT architecture, pipeline design, and large-scale data platform operations
- Expert-level SQL proficiency in IBM DB2 and SQL Server including complex schema design, query optimization, and stored procedure management
- Expert-level IBM DataStage experience including architecture, parallel job design, performance tuning, and enterprise deployment
- Deep expertise in IBM Workload Scheduler - complex job stream design, dependency management, SLA configuration, and production operations
- Advanced Oracle GoldenGate experience including replication architecture, CDC design, and production support
- Proven AWS data engineering experience in production - S3, Glue, RDS, Redshift, Lambda, and IAM-governed data access
- Demonstrated ability to develop and execute multi-year technology roadmaps and lead platform modernization programs
- Experience leading managed services or outsourced delivery models with SLA, CSAT, and throughput accountability
- Healthcare data engineering experience across claims, clinical (HL7/FHIR), EMR, pharmacy, population health, or regulatory reporting domains
- Experience with modern data stack adoption in enterprise settings - Apache Airflow, dbt, Spark, Delta Lake, or equivalent
- Knowledge of HIPAA, HITRUST, CMS, and healthcare data regulatory compliance requirements
- Experience leading on-premises to cloud migrations for large-scale enterprise data platforms
- Familiarity with Tableau, BusinessObjects, or SAS as downstream analytics consumers of engineered data
- Background in agile delivery, DevOps practices, and CI/CD pipelines for data engineering
Benefits
- Comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees
- Salaried personnel receive paid time off
- Hourly employees are not eligible for paid time off unless required by law
- Hourly employees on a Service Contract Act project are eligible for paid sick leave
Company Overview
Company H1B Sponsorship