Consultant/ Sr. Consultant - Snowflake Support (usdm)

Snowflake Consultant

Have you ever wanted to be a part of something bigger than yourself?

At Blue Altair, we believe each of our employees is a star, full of diverse elements that emit a brilliant light. Just as stars illuminate the night sky, our team members light up the business and technology world with their talent, creativity, and dedication.

Blue Altair is an industry-recognized consulting firm and a trusted partner in digital transformation. Founded in 2015, our services span Assessment and Strategy, Technology Implementation, and Managed Services in API Management and Integration, Data Management, Digital Application Development, and Data Science and AI. We are proud to exceed industry standards for project success, thanks to our expert focus on program and project management, business analysis, and quality assurance.

Working at Blue Altair means being part of a vibrant, dynamic team driving digital change. No matter the role you fill, you'll contribute to the digital future and make a difference. So, if you're a star ready to shine brighter, we can't wait to meet you.

Join us at Blue Altair, where we're not just transforming businesses, but shaping the digital universe one star at a time. Apply now to join our constellation of stars!

Position Overview: The Snowflake Consultant will be responsible for designing, implementing, and managing data architecture and pipelines on the Snowflake platform. The ideal candidate will have extensive experience in Snowflake development, data modelling, ETL/ELT processes, and SQL optimization, along with a deep understanding of Snowflake features and integrations with various data sources. This is a contract position that will be a minimum of 6-month, with the potential for extension based on project needs and performance.

Roles & Responsibilities:

• Design and implement scalable data solutions using Snowflake, including data warehouses and data lakes.
• Build and maintain ETL/ELT pipelines for data ingestion, transformation, and integration.
• Experience with Snowflake-specific features like Snowpark, Snowpipe, Streams, Tasks, Time Travel, and Cloning.
• Integrate Snowflake with analytics tools such as Streamlit and Sigma for reporting and visualization.
• Develop and manage complex SQL queries, stored procedures, and reusable scripts.
• Optimize Snowflake performance, including query tuning, clustering, and cost management.
• Recommend and implement best practices for Snowflake architecture and performance tuning.
• Collaborate with business stakeholders to gather data requirements and deliver solutions.
• Ensure data security, access controls, and compliance with governance standards.
• Monitor Snowflake infrastructure for performance, scalability, and reliability.
• Integrate Snowflake with cloud services such as AWS, Azure, or GCP.

Good to Have:

• Familiarity with Python scripting for automation.
• SnowPro Certification.
• Exposure to data visualization tools like Tableau or Power BI.
• Knowledge of CI/CD practices and DevOps for Snowflake.