Data Engineer - Snowflake, DBT, Python, SQL

Factspan Analytics; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Factspan Analytics is seeking a Senior Data Engineer to build and maintain the enterprise data warehouse, supporting reporting and analytics. The role involves ELT, data connections, and documentation across business applications, with emphasis on data quality and governance.

The candidate should have strong Python, SQL, and cloud data warehouse experience, particularly Snowflake, with HYD-based hybrid work arrangements. Immediate joiners preferred.

Qualifications

• 5-10 years Database SQL development (Snowflake/Oracle preferred).
• Ability to create highly complex SQL queries.
• 5+ years ETL/ELT data integration experience.
• Excellent knowledge creating and analyzing ETL and other data integrations.
• Experience in Snowflake or cloud data warehouse platform (Redshift, Databricks, Firebolt).
• Knowledge of ER diagrams, data flow diagrams, and normalization techniques.
• Familiarity with BI tools (Qlik, SAS, Tableau, Looker, etc.).
• Inquisitive and willing to learn business processes and innovative technologies.
• Team player with strong interpersonal skills.

Responsibilities

• Implement, maintain, and support data pipeline solutions.
• Tune SQL and pipelines to limit consumption spend.
• Ensure data reliability, efficiency, integrity, and quality.
• Follows standardization of coding practices and adherence to coding standards and change control.
• Adheres to security policies in relation to HIPAA compliance and company standards.
• All other duties as assigned.

Skills

Python

SQL

ETL/ELT

dbt

AWS

BI tools

AI/ML

Teamwork

Tools

Snowflake

Snowpark

Redshift

Databricks

Firebolt

Job description

Position Title: Senior Data Engineer - Principal Analyst

Job Location: Hyderabad (Hybrid) - Madhapur - Hi-Tech City

Work Hours: Standard office hours with some communication after hours with US

Job Summary:

The Senior Data Engineer contributes to the creation and maintenance of the enterprise data warehouse that will support all reporting and analytic functions at the company. This position analyzes, implements, maintains, and supports ELT, connections, and extracts supporting various business applications (including definition, structure, documentation, long-range requirements, operational guidelines).

Ensures data warehouse resilience, availability, recovery, maintenance, data integrity and capacity planning requirements. Provides a high degree of coordination between user, technical, application and corporate entities to ensure effective data management as a corporate enterprise. Has a willingness to work with customers of varying levels of technical ability in a growing, complex environment.

We need candidates with strong Python knowledge. Along with SQL, dbt, AWS, Python, preferred skills include Snowpark, Snowflake cortex code, Snowflake Stream lit, and AI/ML model building also. HYD/willing to work from HYD Profiles only.

Duties &Responsibilities:

• Implement, maintain, and support data pipeline solutions


• Tune SQL and pipelines to limit consumption spend


• Ensure data reliability, efficiency, integrity, and quality


• Follows standardization of coding practices and adherence to coding standards and change control


• Adheres to security policies in relations to HIPAA (Health Insurance Portability and Accountability) compliance and company standards


• All other duties as assigned

Qualifications and Requirements:

• 5-10 years Database SQL development (Snowflake/Oracle preferred)


• Ability to create highly complex SQL queries


• 5+ years ETL/ELT data integration experience


• Excellent knowledge creating and analyzing ETL and other data integrations


• Experience in Snowflake or cloud data warehouse platform (Redshift, Databricks, Firebolt)


• Knowledge of ER diagrams, data flow diagrams, and normalization techniques
  
• Familiarity with Business Intelligence tools (Qlik, SAS, Tableau, Looker, etc.)


• Inquisitive and willing to learn business processes and innovative technologies


• Team player with strong interpersonal skills

IMPORTANT:

Immediate joiners / candidates with short notice periods only.