Data Engineer (SQL, Snowflake, DBT, IAC)

There are 2 roles here, JD is more or less similar –

1. Full Stack data engineer – Strong in SQL , Below JD
2. Analytics engineer – Same JD as below but more emphasis on the IAC part.

Requirements

• Strong SQL & DBT Expertise

• Experience building and maintaining scalable data models in DBT.
• Proficient in modular SQL, Jinja templating, testing strategies, and DBT best practices.

• Data Warehouse Proficiency

• Hands-on experience with Snowflake including:

• Dimensional and data vault modeling (star/snowflake schemas)
• Performance optimization and query tuning
• Role-based access and security management

• Data Pipeline & Integration Tools

• Experience with Kafka (or similar event streaming tools) for ingesting real-time data.
• Familiarity with SnapLogic for ETL/ELT workflow design, orchestration, and monitoring.

• Version Control & Automation

• Proficient in Git and GitHub for code versioning and collaboration.
• Experience with GitHub Actions or other CI/CD tools to automate DBT model testing, deployment, and documentation updates.

• Data Quality & Governance

• Strong understanding of data validation, testing (e.g., dbt tests), and lineage tracking.
• Emphasis on maintaining data trust across pipelines and models.

• Stakeholder Management

• Partner with business and technical stakeholders to define data needs and deliver insights.
• Ability to explain complex data concepts in clear, non-technical terms.

• Documentation & Communication

• Maintain clear documentation for models, metrics, and data transformations (using DBT docs or similar).
• Strong verbal and written communication skills; able to work cross-functionally across teams.

• Problem-Solving & Ownership

• Proactive in identifying and resolving data gaps or issues.
• Self-starter with a continuous improvement mindset and a focus on delivering business value through data.

• IAC

• deploy scalable, secure, and high-performing Snowflake environments in line with data governance and security in palce using Terraform and other automation scripit
• Automate infrastructure provisioning, testing, and deployment for seamless operations.