Data Engineer- Snowflake & DBT

Factspan Analytics; Bengaluru; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Factspan Analytics is hiring an experienced Data Engineer in Bengaluru to design, build, and optimize data pipelines and models that drive business insights. The role requires hands-on SQL, Python, Snowflake, and DBT Cloud expertise, with healthcare domain experience considered a strong advantage.

You will collaborate with data analysts, scientists, and business stakeholders to deliver reliable data models, maintain governance, and improve the performance of existing workflows in a cloud data

Qualifications

• 7+ years of data engineering experience.
• Bachelor's degree in a related field.
• Strong SQL and data modeling fundamentals.
• Hands-on Snowflake and DBT Cloud experience.
• Experience with ETL/ELT and data warehousing.

Responsibilities

• Design, develop, and maintain scalable data pipelines on cloud platforms.
• Implement and optimize data warehouses using Snowflake and DBT Cloud.
• Write complex SQL for data extraction, transformation, and analysis.
• Collaborate with analysts, scientists, and stakeholders to model data requirements.
• Build and maintain data documentation and governance best practices.
• Monitor and improve performance and reliability of data workflows.
• Contribute to data architecture discussions for scalability.

Skills

SQL

Data Modeling

Python

ETL/ELT

Cloud Platforms

Education

Bachelor's degree in CS/IS

Tools

Snowflake

DBT Cloud

Airflow

CI/CD

Job description

Position: Data Engineer

Bengaluru, Karnataka

Factspan Overview

Factspan is a pure-play data and analytics services organization. We partner with Fortune 500 enterprises to build an analytics center of excellence, generating insights and solutions from raw data to solve business challenges, make strategic recommendations, and implement new processes that help them succeed. With offices in Seattle, Washington, and Bengaluru, India, we use a global delivery model to service our customers. Our customers include industry leaders from the retail, financial services, hospitality, and technology sectors.

Job Overview

We are looking for an experienced Data Engineer with over 7 years of experience to design, build, and optimize data pipelines and data models that drive business insights. The ideal candidate has strong expertise in SQL, Python, data warehousing, and hands-on experience with Snowflake and DBT Cloud. Experience in the healthcare domain is a strong advantage.

Key Responsibilities

• Design, develop, and maintain scalable and reliable data pipelines using modern cloud data platforms.
• Implement and optimize data warehouse solutions using Snowflake and DBT Cloud.
• Write complex SQL queries for data extraction, transformation, and analysis.
• Collaborate with data analysts, scientists, and business stakeholders to understand data requirements and deliver reliable data models.
• Build and maintain high-quality data documentation and ensure data governance best practices.
• Monitor and improve the performance, reliability, and efficiency of existing data workflows.
• Contribute to data architecture and modeling discussions to enhance data platform scalability and performance.

Required Qualifications

• 7+ years of experience in data engineering roles.
• Bachelor's degree in computer science, Information Systems, or related field.
• Strong proficiency in SQL and data modeling principles.
• Deep understanding of ETL/ELT processes and data warehousing concepts.
• Hands-on experience with Snowflake (data warehouse) and DBT Cloud (data transformation).
• Snowflake: Proficiency in Snowflake data warehouse including architecture, security, and performance optimization
• Proven expertise in DBT (Core and Cloud):
• Building modular, maintainable, and reusable DBT models and macros.
• Managing DBT projects and integrating them with CI/CD pipelines.
• Writing and scheduling DBT tests for data quality assurance.
• Implementing environment setups (dev/stage/prod) and version control for DBT projects.
• Using DBT Cloud, job orchestration, logging, and documentation features effectively.
• Strong experience with data pipeline orchestration tools (e.g., Airflow, Prefect, Dagster).
• Experience working with cloud platforms such as AWS, Azure, or GCP.