AWS Data Engineer

Job Summary

We are seeking a skilled AWS Data Engineer with extensive experience designing, implementing, and optimizing cloud-based data solutions.

This role involves migrating legacy systems to AWS, managing data pipelines, and ensuring performance, security, and compliance.

The ideal candidate will have a strong background in AWS services, stored procedures, and database technologies including Postgres and Redshift.

Key Responsibilities

• Design and manage scalable data storage solutions using AWS services like S3, Aurora PostgreSQL, Redshift, DynamoDB, and RDS.
• Optimize data storage and retrieval for performance and cost-efficiency.
• Develop database applications using modern technologies including Node.js, Python, Chart.js, Lambda, and CloudWatch.
• Integrate data from various sources (APIs, databases, streaming platforms) into data lakes or data warehouses.
• Ensure data consistency, accuracy, and integrity across systems.
• Monitor data pipelines for performance, reliability, and scalability.
• Implement data security best practices including IAM, encryption, and access control.
• Develop and maintain stored procedures, particularly in support of migration projects.
• Support migration from Oracle to PostgreSQL or Redshift, ensuring a smooth transition.
• Collaborate with product managers, developers, and subject matter experts to define requirements and build functional software.
• Ensure adherence to data governance, compliance, and regulatory standards.
• Participate in all phases of the software development lifecycle, including testing and documentation.

Required Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 5+ years of AWS experience, including experience in team leadership.
• Proficiency in AWS services such as S3, Glue, Redshift, EMR, Lambda, Athena, and Kinesis.
• Strong experience in stored procedures development.
• Experience with AWS Database Migration Service (DMS) and ETL solutions like Glue and Lambda.
• Proficient in Python, Java, or Scala and strong SQL skills.
• Experience with big data tools like Apache Spark, Hadoop, or Kafka.
• Solid understanding of cloud security, DevOps, and CI/CD practices.
• Familiarity with data visualization tools such as AWS QuickSight, Looker, Tableau, or Power BI.
• Experience transforming database code from Oracle to PostgreSQL.
• Strong analytical, problem-solving, communication, and collaboration skills.

Preferred Qualifications

• Experience with CRM, Finance, or Accounting systems.
• Hands-on knowledge of Angular/React Material for frontend integration.
• Experience with SAFE, Agile, Scrum, and DevOps environments.
• AWS Certification is a plus.

Education: Bachelors Degree

Certification: AWS