Job Title:  Senior Consultant | Snowflake | Bengaluru | Engineering

Key Responsibilities:

Data Architecture & Design:

• Design and implement scalable and efficient data pipelines using Snowflake.
• Develop data models, warehouses, and marts to support business intelligence and analytics initiatives.
• Optimize and manage the performance of the data architecture, ensuring low-latency data retrieval and storage.

ETL/ELT Development:

• Build and maintain robust ETL/ELT processes in Snowflake.
• Work with large datasets and build data transformation layers for effective analysis.
• Write clean, efficient, and reusable SQL queries in snowflake to transform data.

Data Governance & Quality:

• Ensure data integrity and accuracy across all pipelines.
• Implement data quality checks, validation, and monitoring using snowflake.
• Work with stakeholders to define data governance best practices.

Experience:

• 2-15 years of experience in data engineering, with a focus on building data solutions at scale.
• 3+ years of hands-on experience working with Snowflake.
• Good to have DBT (Data Build Tool)/Matillion or any other ETL tool experience for data transformation.

Technical Skills:

• Strong SQL skills and experience with database optimization.
• Proficient in using Snowflake for data warehousing and modeling.
• Experience with one of the cloud platforms (AWS, GCP, Azure) and integrating cloud-based data services.
• Experience in building and deploying ETL/ELT pipelines.
• Understanding of data warehousing principles and dimensional modeling.
• Knowledge of version control systems (Git).

Other:

• Strong communication and collaboration skills.
• Ability to work in a fast-paced, agile environment.
• Excellent problem-solving and analytical skills.

Good to have:

• Experience with Python or other scripting languages.
• Familiarity with orchestration tools like Airflow or Prefect.
• Experience in data visualization tools like Tableau, Power BI, or Looker.