Data Engineer
SMC Global Securities Ltd.
Job Description
JD for Data Engineer : Hiring : Mid-Level Data Engineer Location : Delhi Experience Required : 5-9 Job Type : Full-Time Key Skills Required : - Design, build, and maintain - Implement and enforce data modeling standards - Build data pipelines using a Medallion Architecture - Develop and optimize composable data architectures - Develop and optimize data transformation processes - Write and optimize complex SQL queries and Python scripts - Implement and orchestrate data workflows -Utilize AWS cloud services such as Lambda ,Glue ,S3 ,Athena and Redshift ,to build robust data solutions. Requirements -Strong proficiency in SQL and Python is a must, with a focus on data manipulation and analysis. -Good understanding of data modeling concepts and experience with various o deling techniques in a financial context. -Strong understanding of Medallion and composable data architectures-Solid understanding of data architecture concepts including Data Lake, Data Warehouse,and Data Lakehouse -Hands-on experience with AWS cloud services, including but not limited toS3, Redshift,Athena, Glue, EMR, and Lambda -Experience with open-source data tools like Airflow, DBT, and Airbyte -Familiarity with Hive & Iceberg tables is essential. -Proven experience building and maintaining data pipelines -Experience with reporting or business intelligence tools (e.g., Metabase). Were Looking for Someone Who : - Is eager to explore and learn new data technologies - Can collaborate effectively in a team environment - Brings attention to detail and a problem-solving mindset - Communicates well with both technical and non-technical stakeholders