Data Engineer - SQL/Python

We're seeking a skilled Mid-Level Data Engineer to join our team at SMC Global Securities
Experience : 4- 8 years
Notice Period : Immediate, 1 month
Job Location : Delhi (On-site)
Key Skills Required
Design, build, and maintain highly efficient and scalable real-time & batch data pipelines
Implement and enforce data modeling standards
Build data pipelines using a Medallion Architecture, progressing data through Bronze, Silver and Gold
Develop and optimize composable data architectures and data transformation processes
Manage and maintain data storage solutions across our Data Lake (S3), Data Warehouse
Write and optimize complex SQL queries and Python scripts
Implement and orchestrate data workflows.
Good To Have (Not Mandatory)
Exposure to DBT (Data Build Tool)
Experience with reporting tools, preferably Metabase
We Are Looking For Someone Who
Strong proficiency in SQL and Python
Good understanding of data modeling concepts
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 to S3, Redshift, Athena, Glue, EMR, and Lambda.
Experience with open-source data tools like Airflow, DBT, and Airbyt.
Familiarity with Hive & Iceberg tables is essential.
(ref:hirist.tech)