Senior AWS Data Engineer

Cognitive Medical Systems is seeking a Senior AWS Data Engineer to fill a role on its Human Capital Management (HCM) Product Line’s (PL) Data Warehouse Delivery Team on the VA T4NG Consolidated Corporate Support Services (CCSS) program serving our Department of Veterans Affairs Corporate Portfolio clients across the entire U.S. CCSS.

Position Summary

Strong AWS hands-on experience in data warehousing using services like Glue, Lambda, Redshift, S3, Python, Scala, and Spark. Familiar with ETL and data warehouse concepts and techniques.

Duties:

• Work on AWS Data pipeline to configure data loads from S3 to Redshift.
• Will use JSON schema to define tables and column mapping from S3 to Redshift.
• 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.
• Troubleshooting and maintenance of the data warehouse.
• Performs design and implementation of IT systems that require the integration of diverse and complex components. Activities include defining operational requirements including integration with other systems or components, researching and modeling the system architecture and configuration, investigating alternatives and decision analysis.
• Provides specific, detailed information for selection, implementation techniques, and tools for the most efficient solution to meet business needs, including present and future capacity requirements, identity management, access management, and automation.
• Exercises judgment in selecting methods and techniques for obtaining results.
  
  
  

• 5+ years of hands-on experience working with Redshift.
• 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.
  
  
  

• Strong communication skills
• Experience in design, development and deployment of dashboards, visualization and reporting using Power BI or Tableau reporting platforms.
• AWS certified.