Consultant/ Sr. Consultant - Snowflake Support (USDM)

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 Requirements • Experience with data integration tools (e.g., dbt, Fivetran, Matillion) preferably dbt • 4-6 years of experience • Good written and oral English skills • Applicant must be local to Greenwich, CT Benefits In addition to a competitive compensation package, we offer abundant opportunities for you to achieve, excel, and surpass even your own expectations. Aligned with Blue Altair's challenger ethos, we present the Star Elements program, inspired by the composition of stars themselves—comprising diverse elements that give unique qualities and illuminate for thousands of years. Likewise, our initiative aims to facilitate brilliance in our employees. The Star Elements program encompasses a range of benefits, supporting our team across four pivotal facets of their lives and careers. Through Star Elements, our employees can fully realize their potential, both on personal and professional fronts. Blue Altair does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.