Factspan - Data Engineer - Snowflake DB/Data Build Tool

Hiring : Data Engineer (Snowflake + DBT Cloud) Factspan Analytics

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 5 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 :

- 5+ 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