Apply on Employer Site

Alpha Consulting Corp. · 16 hours ago

AWS Data Engineer/Modeler

United States

Full-time

Remote

Mid Level

$70/hr - $75/hr

Alpha Consulting Corp. is seeking an AWS Data Engineer/Modeler to design and maintain data models and schemas on AWS. The role involves building and optimizing ETL/ELT pipelines, ensuring data governance and security, and optimizing performance for data analytics and business intelligence.

ConsultingPharmaceuticalStaffing Agency

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Design and maintain data models and schemas on AWS (S3, Glue Catalog, Lake Formation, Redshift Spectrum, Athena)

Work with data engineers to align ingestion and transformation pipelines with modeled data structures

Implement best practices for partitioning, metadata management, and schema evolution

Collaborate with business to translate business requirements into data models

Data modeling practices for bronze, silver, and gold layers to support analytics and business intelligence

Build and optimize ETL/ELT pipelines using AWS Glue, Lambda, PySpark, or Step Functions

Automate data ingestion from structured, semi-structured, and unstructured sources (ERP, CRM, IoT, streaming)

Implement data cataloging, partitioning, and tagging using AWS Glue Catalog and Lake Formation

Ensure compliance with data governance, security policies, and access management (IAM, KMS, encryption)

Optimize queries using Athena, and Spark tuning

Manage cost optimization strategies for storage, compute, and query workloads

Contribute to CI/CD pipelines for data lake jobs (Terraform)

Qualification

AWS GlueData modelingETL/ELT pipelinesAWS S3AWS RedshiftPySparkData governanceCost optimizationCI/CD pipelinesCollaboration

Required