Data Engineer

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title:Data Engineer

Location(s):Redmond, WA

Job Description:

• Export Control Requirement:
  Due to applicable export control laws and regulations, candidates must be a U.S. citizen or national, U.S. permanent resident (i.e., current Green Card holder), or lawfully admitted into the U.S. as a refugee or granted asylum.

• Strong knowledge of SQL for complex querying, optimization, and database design.
• Experience with time-series databases, preferably Timestream.
  
  Timestream:
• Hands-on experience in designing, implementing, and managing time-series data in Timestream.
• Proficiency in defining retention policies, querying, and optimizing time-series data workflows.

• Proficiency in Python for data engineering tasks, including integration with client services.
• Experience with Python libraries such as Pandas, SQL Alchemy, or PySpark for handling data processing and analysis.

• Deep knowledge of client services related to data engineering such as S3, Lambda, Redshift.
• Experience with managing data pipelines, security, and automation.

• Experience in schema design, performance optimization, and maintenance for both relational and No
  
  SQL databases.
• Understanding of best practices for cloud-based database management, including backup, disaster recovery, and monitoring.

• Strong troubleshooting skills for performance issues in both data pipelines and databases.
• Experience with scaling databases and pipelines to accommodate increasing data volume and complexity.