Search Jobs

Cloud Data Engineer (AWS Redshift/EAP on AWS)

Madison, WI 53706

Posted: 09/08/2023 Employment Type: Contract Job Category: Database Management & Business Intelligence Job Number: 579451 Is job remote?: Yes Country: United States

Job Description

Cloud Engineer - EAP on AWS
Location: Remote; must reside or relocate upon starting to the state of Wisconsin
Pay: up to $145 per hour DOE
Benefits: Health, Dental, Vision and more


Job Overview:Job Overview:
Planet Technology's client is seeking a talented and experienced AWS Redshift Data Engineer / Consultant to join their team in designing, developing, and optimizing data pipelines and ETL processes for their AWS Redshift-based data lake house. In this role, you will collaborate closely with cross-functional teams, leveraging your expertise in SQL, Redshift stored procedures, AWS DMS, Airflow, Python scripting and other pertinent AWS services to ensure the seamless ingestion, integration, transformation and orchestration of data. Your experience with complex ETL pipelines, Changed Data Capture (CDC), Slowly Changing Dimension (SCD) strategies will be instrumental in creating a scalable, high-performance data environment. By adhering to best practices and industry standards, you will collaborate with their engineering and data teams to design forward-thinking solutions.

Top Skills:
  • 1+ Years of Experience with extensive hands-on experience designing, developing, and maintaining data pipelines and ETL processes on AWS Redshift, including data lakes and data warehouses
  • Hands-on experience with AWS services such as AWS DMS, Amazon S3, AWS Glue, Redshift, Airflow, and other pertinent data technologies
  • Strong understanding of ETL best practices, data integration, data modeling, and data transformation

Nice to Have:
  • AWS certifications related to data engineering or databases
  • Proficiency in SQL programming and Redshift stored procedures for efficient data manipulation and transformation
  • Experience with complex ETL scenarios, such as CDC and SCD logics, and integrating data from multiple source systems
  • Demonstrated expertise in AWS DMS for seamless ingestion from on-prem databases to AWS cloud
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Madison, WI

Explore exciting job opportunities in and around Madison, Wisconsin! Nestled in the heart of the Dairy State, Madison offers a vibrant blend of bustling city life and picturesque natural beauty. Known for its rich history, diverse population, and renowned University of Wisconsin-Madison, this area boasts a thriving arts scene with gems like the Chazen Museum of Art and Overture Center for the Arts. Indulge in local delicacies like cheese curds and brats, catch a game cheering for the Badgers or the Mallards, and unwind in the stunning Olbrich Botanical Gardens or along the scenic shores of Lake Mendota. Join us in this dynamic community for unmatched career growth and a truly unique Midwestern experience! Start your job search today.