Snowflake Admin/Developer

Overview

We are looking for a skilled data professional to manage and optimize data systems and analytics solutions. In this role, you will work with data models, databases, and governance practices to support business needs and ensure data quality. You will also administer our Snowflake environment and collaborate with various teams to align data architecture with business goals.

Key Responsibilities

• Document systems and analytics solutions in clear, business-relevant language.
• Analyze and develop data stores and interfaces to support current and future data models.
• Collaborate on business glossary implementation, governance, and stewardship with enterprise data management.
• Work with information architecture to create logical and physical data models aligned with conceptual models.
• Facilitate data requirements gathering through interviews, document analysis, and workshops.
• Assist in developing and enforcing data modeling standards, definitions, and data management reviews.
• Coordinate with report developers to align dataset design with report design.
• Administer and manage the Snowflake database, including auditing and compliance tasks.

Requirements

• Advanced SQL skills with experience writing complex queries and stored procedures.
• Knowledge of star schema, snowflake schema, and logical data modeling.
• Experience in data development and design within large-scale enterprise environments.
• Strong understanding of relational and dimensional data modeling concepts and data governance.
• Expertise in query performance analysis, query tuning, and managing indexes and partitions.
• Technical skills in data modeling, database development, and data mining.
• Bachelor’s degree in Computer Science or related field.
• 6 to 10 years of relevant professional experience.
• Willingness to travel as needed for strategic projects.
• Flexibility to work from various locations as required.

Nice to Have

• Experience with Python or PySpark.
• Familiarity with ETL tools such as Talend or Informatica Power Center.
• Experience with Snowflake and cloud platforms like AWS or Azure.