AWS Cloud Data Engineer

• Design, build, and maintain scalable data pipelines and processing solutions within AWS cloud environments.
• Partner with AWS Cloud DBAs and cross-functional teams to migrate data from legacy applications to AWS while ensuring performance, reliability, and security.
• Develop ETL/ELT workflows to ingest, transform, and load data into data lakes, data warehouses, and analytical platforms.
• Implement AWS data services, including S3, Glue, Step Functions, Lambda, Kinesis, EMR, Athena, Redshift, RDS, and Aurora.
• Create and maintain data models, schemas, technical documentation, and data access patterns for transactional and analytical workloads.
• Establish data quality checks, monitoring, alerting, governance controls, and compliance practices for data retention, privacy, and security requirements., System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan., System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

• Ability to obtain a Federal Public Trust clearance.
• Bachelor’s degree in Computer Science, Data Engineering, or a related field; four additional years of relevant experience may be substituted for a degree.
• Minimum of 6 years of data engineering experience, including at least 3 years in AWS cloud environments.
• Strong experience with AWS data services, including S3, Glue, DMS, Athena, Redshift, EMR, Kinesis, and Lambda.
• Proficiency in Python, Scala, or Java for data processing and pipeline development.
• Experience with SQL, relational databases such as PostgreSQL or Oracle, and NoSQL databases such as DynamoDB or DocumentDB.
• Understanding of data modeling concepts for transactional and analytical workloads.
• Experience with Infrastructure as Code tools such as Terraform, CloudFormation, or CDK, and CI/CD pipelines for data engineering workflows.
• Strong analytical, problem-solving, collaboration, and communication skills with a focus on data quality and system reliability.

NICE TO HAVE

• AWS Certified Data Engineer - Associate certification.
• AWS Certified Solutions Architect or other relevant AWS certifications.
• Experience with Apache Spark, Apache Airflow, or AWS-native orchestration tools.
• Knowledge of data formats such as JSON, Avro, Parquet, and ORC, including compression techniques for efficient storage and processing.
• Familiarity with Git and collaborative development practices.
• Knowledge of container technologies, including Docker, Kubernetes, ECS, or EKS.
• Experience with data visualization tools such as QuickSight, Tableau, or Power BI.
• Understanding of data privacy regulations and compliance frameworks.
• Experience tuning and optimizing distributed data processing systems.
• Knowledge of networking, security, and IAM policies related to data engineering workflows.