Sr. Snowflake Developer (USDM)

Blue Altair • Greenwich, CT

2d • Onsite

About The Position

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!
We are seeking a passionate Snowflake Developer with expertise in data modelling, cloud architecture, SQL, and stored procedures.

Requirements

• Hands-on experience with Snowflake, designing scalable data solutions, data modelling, performance tuning, cost optimization etc.
• Strong proficiency in SQL development and stored procedures within the Snowflake environment.
• Expertise in ELT/ETL pipelines for data load and transformation to and from Snowflake and best practices for efficient data architecture.
• Experience with Snowpark, Snowpipe, Streams, Tasks, Time Travel, and Cloning.
• Experience in building and automating CI/CD pipelines for seamless deployments in Snowflake.
• Knowledge of Snowflake security best practices, including role-based access control (RBAC) and resource monitoring.
• Ability to configure Snowflake storage and compute resources for optimized data processing.
• Ability to work with business SMEs during different phases starting requirements to solutions.
• Strong problem-solving skills and a passion for cloud-based data solutions and scalable architectures.

Nice To Haves

• Knowledge of integrating Snowflake with analytics tools for reporting.
• Working knowledge of financial markets, particularly mutual funds and investment funds.
• Working knowledge of Python scripting and automation.

Responsibilities

• Hands-on experience with Snowflake, designing scalable data solutions, data modelling, performance tuning, cost optimization etc.
• Strong proficiency in SQL development and stored procedures within the Snowflake environment.
• Expertise in ELT/ETL pipelines for data load and transformation to and from Snowflake and best practices for efficient data architecture.
• Experience with Snowpark, Snowpipe, Streams, Tasks, Time Travel, and Cloning.
• Experience in building and automating CI/CD pipelines for seamless deployments in Snowflake.
• Knowledge of Snowflake security best practices, including role-based access control (RBAC) and resource monitoring.
• Ability to configure Snowflake storage and compute resources for optimized data processing.
• Ability to work with business SMEs during different phases starting requirements to solutions.
• Strong problem-solving skills and a passion for cloud-based data solutions and scalable architectures.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed