Analytics Engineer

Job Title: Analytics Engineer
Experience: 4–8 Years
Employment Type: Contract (6–12 Months + Extendable)
Location: Mumbai
Work Mode: Hybrid

Role Summary

We are looking for an experienced Analytics Engineer with strong expertise in DBT, Snowflake, and SQL to build scalable data models and reliable analytics solutions. The ideal candidate should have hands-on experience in data warehousing, data transformation, data quality, and CI/CD, along with strong stakeholder management and communication skills. Experience with Python, Kafka, and SnapLogic will be an added advantage.

Key Responsibilities

• Build and maintain scalable data models using DBT, leveraging modular SQL, Jinja templating, testing strategies, and DBT best practices.
• Design and optimize data warehouse solutions using Snowflake, including dimensional and Data Vault modeling, performance tuning, query optimization, and role-based security.
• Develop and support data pipelines using Kafka or similar event-streaming platforms and work with SnapLogic for ETL/ELT workflow design and orchestration.
• Implement data quality, validation, testing, and lineage practices to ensure reliable and trusted data across pipelines and models.
• Manage code versioning and collaboration using Git and GitHub, with experience in GitHub Actions or other CI/CD tools for automated DBT testing, deployment, and documentation.
• Collaborate with business and technical stakeholders to understand data requirements, resolve data issues, and deliver business-focused data solutions.
• Maintain clear documentation for data models, metrics, and transformations using DBT Docs or similar tools.
• Proactively identify data gaps and technical issues while driving continuous improvement and delivering business value through data.

Required Skills & Experience

• 4–8 years of experience in Analytics Engineering, Data Engineering, or a related field.
• Strong hands-on expertise in:
  • DBT
  • Snowflake
  • SQL
• Experience with scalable data modeling, including Dimensional Modeling and Data Vault.
• Strong understanding of SQL optimization, query tuning, and data transformation.
• Experience with DBT testing, documentation, lineage, and best practices.
• Proficiency in Git and GitHub.
• Experience with CI/CD tools such as GitHub Actions.
• Strong understanding of data quality, validation, and governance.
• Excellent communication and stakeholder management skills.

Secondary Skills / Preferred Skills

• Python
• Kafka or similar event-streaming platforms
• SnapLogic
• DBT Docs
• GitHub Actions
• Data Vault Modeling
• Data Lineage and Governance

Key Skills

• DBT, Snowflake, SQL, Data Modeling, Data Warehousing, Data Vault, Dimensional Modeling, Python, Kafka, SnapLogic, Git / GitHub, CI/CD, Data Quality, Data Governance, Data Lineage