Data Engineer

Onsite in Smithfield, RI Our client seeks a Data Engineer to design, build, and support enterprise-scale data platforms and pipelines. The role focuses on ELT/ETL across Snowflake, Oracle, and PostgreSQL, with strong Python, SQL, and orchestration using Apache Airflow or Control-M. You will drive CI/CD, containerization with Docker, and AWS services to deliver scalable, reliable data solutions. Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance. Rate: $65.00 to $70.00/hr. w2 Responsibilities • Design, build, and maintain scalable ELT/ETL pipelines across Snowflake, Oracle, and PostgreSQL. • Develop robust data models and transformations to support analytics and application workloads. • Orchestrate complex data workflows using Apache Airflow and/or Control-M for reliability and efficiency. • Implement CI/CD pipelines with GitHub and Jenkins for automated build, test, and deployment. • Containerize and deploy data services using Docker with secure, multi-stage builds and registries. • Leverage AWS services such as Lambda, SQS/SNS, EC2, S3, CloudWatch, and IAM for cloud-native solutions. • Write performant Python and SQL for data processing, quality, and automation. • Monitor, troubleshoot, and optimize data pipelines and platform components. Experience Requirements • 6–9 years designing, building, and supporting enterprise-scale data engineering or platform solutions. • Strong hands-on experience with ELT/ETL pipelines across Snowflake, Oracle, and PostgreSQL. • Deep understanding of data structures, relational databases, and cloud-native storage technologies. • Proficiency in Python and SQL, with scripting experience in Shell and Groovy. • Proven orchestration experience with Apache Airflow and/or Control-M. • Hands-on Docker experience including image creation, multi-stage builds, registries, and secure deployments. • Strong CI/CD experience with GitHub and Jenkins, including automated builds, testing, and deployments. • Solid understanding of AWS services including Lambda, SQS/SNS, EC2, S3, CloudWatch, and IAM. • Exposure to Angular, Node.js, and TypeScript (preferred). • Experience with AWS DynamoDB (preferred). • Familiarity with Go (Golang) for backend or data platforms (preferred). • Broader experience with PostgreSQL and AWS-based architectures (preferred). Education Requirements • Bachelor’s degree, preferably in Engineering or Business.