Job Description
We are looking for an experienced Data Engineer / Technical Lead with mandatory expertise in Snowflake and dbt (data build tool) , along with strong skills in Data Warehousing, Data Modeling, and Data Engineering. The ideal candidate will have hands-on experience in AWS data services (Aurora, RDS, DMS, DynamoDB), Oracle, PL / SQL, and SQL, coupled with leadership experience in customer-facing roles for requirement gathering and solution design.
Roles & Responsibilities
Key Responsibilities :
Technical Leadership & Data Engineering :
- Lead end-to-end data warehousing projects using Snowflake and dbt (mandatory skills)
- Design and implement scalable data models, ETL / ELT pipelines, and data architecture in Snowflake
- Develop and optimize dbt models, transformations, and data workflows for efficient analytics
- Work with AWS data services - Aurora, RDS, DMS, DynamoDB - for data integration and migration
- Optimize SQL, PL / SQL queries and database performance (Oracle, PostgreSQL, etc.)
- Implement CDC (Change Data Capture) and real-time data processing solutions
- Ensure data governance, quality, and best practices in data engineering
Requirement Analysis & Customer Handling :
Collaborate with stakeholders to gather, analyze, and document business requirementsHandle Change Requests (CRs) and provide technical solutions aligned with business needsAct as a bridge between business teams and technical teams for data-driven decision-makingTeam Leadership & Mentorship :
Guide and mentor junior data engineers in Snowflake, dbt, and modern data stack best practicesEnsure adherence to data security, compliance, and scalability principlesMandatory Skills & Experience :
6-13 years of hands-on experience in Data Engineering, Data Warehousing, and Data ModelingExpert-level proficiency in Snowflake and dbt (data build tool) - MandatoryStrong expertise in :AWS Data Services (Aurora, RDS, DMS, DynamoDB)Oracle, PL / SQL, SQL, and database optimizationETL / ELT pipelines & Data IntegrationData Architecture & Dimensional Modeling (Star Schema, Kimball, etc.)Experience in customer handling, requirement gathering, and solution designPreferred Qualifications :
Certification in Snowflake, dbt, or AWS Data TechnologiesExperience with Python, PySpark, or other scripting languagesKnowledge of CI / CD pipelines for data workflows