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 Mexico; Monterrey or Mexico City 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
• 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

About MSCI

What we offer you

• Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing.

• Flexible working arrangements, advanced technology, and collaborative workspaces.

• A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results.

• A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients.

• Global Orientation program to kickstart your journey, followed by access to our Learning@MSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development.

• Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles.

• We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola! MSCI, Pride & Allies, Women in Tech, and Women’s Leadership Forum.

At MSCI we are passionate about what we do, and we are inspired by our purpose – to power better investment decisions. You’ll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry.

MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process.

MSCI Inc. is an equal opportunity employer. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistance@msci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries.

To all recruitment agencies

MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes.

Note on recruitment scams

We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com