Data Engineer - AWS

Role: Data Engineer Key Role and Responsibilities: • Understand and translate business needs into data models supporting long-term solutions. • Perform reverse engineering of physical data models from databases and SQL scripts. • Analyze data-related system integration challenges and propose appropriate solutions. • Assist with and support setting the data architecture direction (including data movement approach, architecture/technology strategy, and any other datarelated considerations to ensure business value). • Understanding the value of AI tools for improving the productivity and effectiveness of data engineering by automating repetitive tasks, improving data quality, accelerating development, and enhancing data platform operations. • Some working experience in any of the following tools - Snowflake Cortex AI, Snowflake Copilot, Matillion, Collibra Requirements: • 5+ Years of experience as a Data Engineer • Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs, aggregation) • Strong knowledge of joins and common table expressions (CTEs) • Experience in Snowflake, ETL, SQL, CI/CD • Strong expertise in ETL process and with various data model concepts • Knowledge of star schema and snowflake schema • Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a major emphasis on S3 and Glue • Good knowledge of Python • Strong understanding of AI tools and their application in data engineering, including data integration, transformation, automation, and analytics. Education: Bachelor’s degree in computer science, Software Engineering, MIS or equivalent combination of education and experience