Data Engineer (Snowflake, DBT)

Job Description

Data Engineer (Snowflake, DBT)Location:Hyderabad |Department:Information Technology |Employment Type:Full TimeExperience:3 to 5 years |Work Model:5 days work from office (relocation not open)About UsWe are a technology consulting organization that helps companies become intelligent, information-driven businesses where fact-based decision-making is embedded into daily operations. We combine strategic consulting with growth-enabling technologies to evaluate risk, manage data, and leverage AI and automation more effectively.About the RoleWe are looking for an experienced, results-driven Data Engineer to join our growing Data Engineering team.The ideal candidate will be proficient in building scalable, high-performance data transformation pipelines using Snowflake and dbt or Matillion, and able to work effectively in a consulting setup.You will be instrumental in ingesting, transforming, and delivering high-quality data to enable data-driven decision-making across the clients organization.Key Responsibilities
• Design and implement scalable ELT pipelines using dbt on Snowflake, following industry best practices
• Build ingestion pipelines from various sources including relational databases, APIs, cloud storage, and flat files into Snowflake
• Implement data modelling and transformation logic to support layered architecture (staging, intermediate, mart layers or medallion architecture)
• Leverage orchestration tools (Airflow, dbt Cloud, or Azure Data Factory) to schedule and monitor data workflows
• Apply dbt best practices: modular SQL development, testing, documentation, and version control
• Perform performance optimizations in dbt/Snowflake through clustering, query profiling, materialization, partitioning, and efficient SQL design
• Apply CI/CD and Git-based workflows for version-controlled deployments
• Contribute to the internal knowledge base of dbt macros, conventions, and testing frameworks
• Collaborate with data analysts, data scientists, and data architects to deliver clean, validated datasets
• Participate in Agile ceremonies (sprint planning, stand-ups, retrospectives)
• Support consulting engagements through clear documentation, demos, and delivery of client-ready solutions
Required Qualifications
• 3 to 5 years in data engineering roles, with 2 years hands-on experience in Snowflake and DBT or Matillion (Matillion-DPC highly preferred, not mandatory)
• Experience building and deploying DBT models in a production environment
• Expert-level SQL and strong understanding of ELT principles, ELT patterns, and data modelling (Kimball / Dimensional preferred)
• Familiarity with data quality and validation techniques (dbt tests, dbt docs)
• Experience with Git, CI/CD, and deployment workflows in a team setting
• Familiarity with orchestrating workflows using dbt Cloud, Airflow, or Azure Data Factory
Core CompetenciesData Engineering & ELT Development
• Building robust, modular data pipelines using dbt
• Writing efficient SQL for transformation and performance tuning in Snowflake
• Managing environments, sources, and deployment pipelines in dbt
Cloud Data Platform Expertise
• Strong Snowflake proficiency: warehouse sizing, query profiling, data loading, performance optimization
• Experience with cloud storage (Azure Data Lake, AWS S3, or GCS) for ingestion and external stages
Technical Toolset
• Python: for data transformation, notebook development, automation
• SQL: strong grasp for querying and performance tuning
Best Practices & Standards
• Knowledge of modern data architecture, including layered architecture (staging intermediate marts, Matillion architecture)
• Familiarity with data quality, unit testing (dbt tests), and documentation (dbt docs)
Security & Governance
• Understanding of access control within Snowflake (RBAC), role hierarchies, secure data handling
• Familiarity with data privacy policies (GDPR basics), encryption at rest/in transit
Deployment & Monitoring
• Version control using Git, CI/CD practices in a data context
• Monitoring and logging of pipeline executions, alerting on failures
Soft Skills
• Ability to present solutions and handle client demos and discussions
• Work closely with onshore and offshore teams of analysts, data scientists, architects
• Clear documentation of pipelines and transformations
• Basic Agile/Scrum familiarity; comfort with ambiguity and a fast-changing client environment
Mandatory / Most Preferred Skill Set
• Must have experience in Snowflake
• Must have experience in DBT or Matillion (Matillion-DPC highly preferred)
• Must have experience in SSIS
Other mandatory skills listed: Azure Cloud, Data Factory, Databricks, Data Warehousing, SQL, ETL/ELT, Cloud Storage. Additional: Kimball, Dimensional modelling.EducationBachelors or masters degree in Computer Science, Data Engineering, or a related field. Certifications such as Snowflake SnowPro or dbt Certified Developer are a plus.

Keyskills :
gitetlazuredatawarehousingdbtsqlfactoryssissnowflakeeltmatillion