Data Warehouse Engineer

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)
10% Travel

Skills

Amazon EC2
Amazon Redshift
Amazon S3
Amazon Web Services
Continuous Integration
Python
Data Lake
SQL

Job Details

Role: Data Warehouse Engineer

6 months, contract to hire

Location: Remote (CST working hours 8:00-5:00)

**W2 Only and no 3rd party firms

**required as client is not able to provide sponsorship

Job Summary:

Our client utilizes Redshift and AWS and will be cutting over to SAP in coming year. They are lacking the in house expertise to support these initiatives. The client will need to build up their team in the skill sets needed to create and maintain/support new data pipelines. The client needs someone who can grow into this team and role. Jr level will be mentored and grow into their role. They need someone with a little more history with the environment than the current internal team has.

Candidate should have a solid foundation in Python, SQL, AWS (Specifically Glue, S3, etc.). Should also have conceptual understanding of how to take items from Source-> Data Lake -> Data Warehouse

Must:

  • 3+ years of working experience with AWS Services such as S3, Redshift, Glue, IAM, EC2, AWS CLI
  • 3+ years of working experience with ETL and Data Modeling.
  • Expert-level skills in writing and optimizing SQL

Plus:

  • Intermediate/Advanced knowledge of Linux
  • Experience in working with CI/CD tools such as Git, Bamboo, Jenkins
  • Knowledge of Data Security, Engineering and Operational Excellence using standard methodologies.
  • Advanced level knowledge in Python
  • Intermediate level knowledge in Pyspark
  • Knowledge of Infrastructure as code tools such as Terraform.
  • Experience in working with ETL tools such as IBM DataStage.
  • Experience with BI tools
  • Experience with Metadata drive pipeline
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Oxford Global Resources