Supervisor, Snowflake Engineer

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.

Snowflake Engineer

We are currently seeking an experienced Snowflake Engineer for our Data Analytics team. This role involves designing, building, and maintaining our Snowflake cloud data warehouse. Candidates should have strong Snowflake, SQL, and cloud data solutions experience.

Responsibilities:

• Design, develop, and maintain efficient and scalable data pipelines in Snowflake, encompassing data ingestion, transformation, and loading (ETL/ELT).
• Implement and manage Snowflake security, including role-based access control, network policies, and data encryption.
• Develop and maintain data models optimized for analytical reporting and business intelligence.
• Collaborate with data analysts, scientists, and stakeholders to understand data requirements and translate them into technical solutions.
• Monitor and troubleshoot Snowflake performance, identifying and resolving bottlenecks.
• Automate data engineering processes using scripting languages (e.g., Python, SQL) and orchestration tools (e.g., Airflow, dbt).
• Designing, developing, and deploying APIs within Snowflake using stored procedures and user-defined functions (UDFs)
• Lead and mentor a team of data engineers and analysts, providing technical guidance, coaching, and professional development opportunities.
• Stay current with the latest Snowflake features and best practices.
• Contribute to the development of data engineering standards and best practices.
• Document data pipelines, data models, and other technical specifications.

Qualifications:

• Bachelor’s degree or higher in computer science, Information Technology, or a related field.  
• A minimum of 5 years of experience in data engineering and management, including over 3 years of working with Snowflake.  
• Strong understanding of data warehousing concepts, including dimensional modeling, star schemas, and snowflake schemas.
• Proficiency in SQL and experience with data transformation and manipulation.
• Experience with ETL/ELT tools and processes.
• Experience with Apache Iceberg.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Qualifications:  

• Snowflake certifications (e.g., SnowPro Core Certification).
• Experience with scripting languages (e.g., Python) and automation tools (e.g., Airflow, dbt).
• Experience with cloud platforms (e.g., AWS, Azure, GCP).
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Experience with Agile development methodologies.
• Experience with Snowflake Cortex, including Cortex Analyst, Arctic TILT, and Snowflake AI & ML Studio.

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/india.html.  

RSM does not tolerate discrimination and/or harassment based on race; colour; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the Indian Armed Forces; Indian Armed Forces Veterans, and Indian Armed Forces Personnel status; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.  

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please send us an email at careers@rsmus.com.