Cloud Data Engineer: Snowflake

Your Team Responsibilities

Data Technology group in MSCI is responsible to build and maintain state-of-the-art data management platform that delivers Reference. Market & other critical datapoints to various products of the firm.

The platform, hosted on firms’ data centers and Azure & GCP public cloud, processes 100 TB+ data and is expected to run 24*7. With increased focus on automation around systems development and operations, Data Science based quality control and cloud migration, several tech stack modernization initiatives are currently in progress.

To accomplish these initiatives, we are seeking a highly motivated and innovative individual to join the Data Engineering team for the purpose of supporting our next generation of developer tools and infrastructure.

The team is the hub around which Engineering, and Operations team revolves for automation and is committed to provide self-serve tools to our internal customers. The position is based in Mumbai, India office.

Your Key Responsibilities

• Build and maintain ETL pipelines for Snowflake.
• Manage Snowflake objects and data models.
• Integrate data from various sources.
• Optimize performance and query efficiency.
• Automate and schedule data workflows.
• Ensure data quality and reliability.
• Collaborate with cross-functional teams.
• Document processes and data flows.

Your skills and experience that will help you excel

• Self-motivated, collaborative individual with passion for excellence
• B.E Computer Science or equivalent with 5+ years of total experience and at least 2 years of experience in working with Databases
• Good working knowledge of source control applications like git with prior experience of building deployment workflows using this tool
• Good working knowledge of Snowflake YAML, Python
• Experience managing Snowflake databases, schemas, tables, and other objects
• Proficient in Snowflake SQL, including CTEs, window functions, and stored procedures
• Familiar with Snowflake performance tuning and cost optimization tools
• Skilled in building ETL/ELT pipelines using dbt, Airflow, or Python
• Able to work with various data sources including RDBMS, APIs, and cloud storage
• Understanding of incremental loads, error handling, and scheduling best practices
• Strong SQL skills and intermediate Python proficiency for data processing
• Familiar with Git for version control and collaboration
• Basic knowledge of Azure, or GCP cloud platforms
• Capable of integrating Snowflake with APIs and cloud-native services