A tech services company in Virginia is looking to add a new AWS Data Engineer to their team in a Remote capacity.
Responsibilities: The AWS Data Engineer will:
- Extract data from multiple data sources into AWS Redshift
- Transform data using Python, Lambda, and Glue
- Load data into staging and data warehouse, and fact and dimension tables
- Write stored procedures for loading data and orchestration
- Perform unit testing, integration testing, and performance testing
- Troubleshoot and maintain the data warehouse
- Perform design and implementation of IT systems that require the integration of diverse and complex components
- Provide specific, detailed information for selection, implementation techniques, and tools for the most efficient solution to meet business needs
- Perform other duties, as needed
Qualifications: - 5+ years of hands-one experience working with Redshift.
- Bachelor's Degree
- Extensive experience developing solutions using Spark/PySpark, Scala, Python, and AWS services such as Lambda, Redshift, Glue, Oracle RDS and S3
- Strong experience developing data warehouse solutions in the AWS cloud
- Hands-on experience in data modeling and design, data flow diagrams, data warehousing and BI applications and analytical reporting tools and technique
- Strong experience developing ETL/ELT solutions in support of data warehouse systems
- Proven experience using Oracle PL/SQL
- Experience performance tuning of data warehouse and reporting
- Experience with AGILE methodology
Desired Skills: - AWS certified
- Experience in design, development and deployment of dashboards, visualization and reporting using Power BI or Tableau reporting platforms