AWS Data Engineer

Jay Analytix

AWS Data Engineer

Chicago, IL
Full Time
Paid
  • Responsibilities

    We are seeking a skilled AWS Data Engineer to join our team and help shape the future of data management and analytics for our organization. In this role, you will work with a variety of AWS services to design, build, and optimize data pipelines, enabling data-driven decision-making at scale.

    Requirements:

    • 4+ years of experience in data engineering or related fields.
    • Strong expertise in SQL and experience with Redshift stored procedures.
    • Proficiency with AWS services, including S3, Lambda, DynamoDB, Step Functions, RDS, SNS, and SQS.
    • Experience with data engineering tools such as EMR, Glue, and Redshift.
    • Strong knowledge of databases, including PostgreSQL and Aurora.
    • Experience with data modeling techniques, including Star/Snowflake Schema Design.
    • Proficiency in Python and PySpark for data manipulation and processing.
    • Knowledge of serverless architectures and experience with AWS Lambda and Step Functions.
    • Strong SQL skills for querying and managing data.
    • Familiarity with data warehousing concepts, including Datamarts and Multi-Dimensional OLAP.
    • Familiarity with data processing frameworks such as Apache Spark or Hadoop.
    • Knowledge of programming languages such as Python or Java for data manipulation and automation.
    • Strong understanding of data governance and best practices for data quality.
    • Experience working in Agile development environments.
    • Excellent problem-solving skills and attention to detail.
    • Strong verbal and written communication skills, with the ability to present information clearly to stakeholders.

    Nice to Have:

    • Knowledge of SAS, familiarity with DevOps tools (e.g., Jenkins, Bitbucket, GitLab, Terraform) , experience with testing automation.