Snowflake Architect
Hybrid in New York, NY, US • Posted 29 days ago • Updated 9 hours ago
Capgemini America, Inc.
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- Amazon Web Services
- Analytical Skill
- Analytics
- Attention To Detail
- BFSI
- Big Data
- Cloud Computing
- Collaboration
- Conflict Resolution
- Cost Management
- Data Architecture
- Data Engineering
- Data Governance
- Data Integration
- Data Integrity
- Data Masking
- Data Migration
- Data Warehouse
- Data-flow Diagrams
- Database
- Extract
- Transform
- Load
- IT Management
- Insurance
- Management
- Microsoft Azure
- Migration
- Optimization
- Orchestration
- Performance Tuning
- Problem Solving
- Query Optimization
- Regulatory Compliance
- Replication
- Reporting
- Snow Flake Schema
- Stored Procedures
- Streaming
- Workflow
Summary
About the Role
We are seeking a highly skilled Snowflake Architect with deep expertise in data engineering and cloud-based data platforms. The ideal candidate will have a proven track record in designing, implementing, and optimizing Snowflake solutions within BFSI and Insurance domains. This is a hands-on role requiring strong technical leadership and the ability to drive end-to-end data architecture strategies.
Key Responsibilities:
Design and implement scalable Snowflake-based data architectures for enterprise-level solutions.
Lead data migration projects from legacy databases to Snowflake on AWS or Azure.
Develop and optimize data ingestion pipelines, data lakes, data warehouses, and reporting frameworks.
Implement data transformation rules, reconciliation processes, and ensure data integrity across systems.
Utilize Snowflake utilities such as SnowSQL, Snowpark, SnowPipe, Tasks, Streams, Stored Procedures, and advanced features like Time Travel, Resource Monitor, Zero-Copy Cloning, Data Masking, and Data Sharing.
Apply query performance tuning and cost optimization techniques to maximize efficiency.
Manage Snowflake account setup and administration on cloud platforms.
Collaborate with cross-functional teams to define data flow diagrams, integration strategies, and orchestration workflows.
Required Skills & Experience:
10+ years of IT experience, with strong exposure to BFSI and Insurance sectors.
Extensive experience in data engineering, including ingestion, data lakes, data warehouses, reporting, and analytics.
Strong knowledge of Big Data pipelines, data replication, integration, and orchestration tools.
Hands-on experience in migrating databases to Snowflake using AWS or Azure.
Deep expertise in Snowflake utilities and advanced features.
Proficiency in query optimization and cost management within Snowflake.
Solid understanding of cloud platform administration and Snowflake account setup.
Preferred Qualifications:
Experience with data governance, security, and compliance in cloud environments.
Familiarity with ETL tools and modern data integration frameworks.
Strong analytical and problem-solving skills with attention to detail.
Why Join Us?
Opportunity to work on cutting-edge cloud data solutions in BFSI and Insurance.
Collaborative environment with career growth and learning opportunities.
Competitive compensation and benefits package.
About Capgemini:
Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of 22.1 billion.
Make it real | ;/p>
Life at Capgemini:
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
Paid time off and paid holidays
Paid parental leave
Family building benefits like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Disaster Relief
- Dice Id: KANBAY
- Position Id: 8854291
- Posted 29 days ago
Company Info
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.
The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 325,000 team members more than 50 countries.
With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported in 2021 global revenues of 18 billion.
Get The Future You Want | www.capgemini.com
When you join Capgemini, you become a part of a diverse collective of freethinkers, entrepreneurs and experts, all working together to unleash human energy through technology, for an inclusive and sustainable future.
What we offer:
Experiences with challenge and impact
You will get a chance to work on complex global projects to make a broader impact by leveraging innovative portfolio offers from us. Unparalleled industry and sectorial expertise to foster your growth to give you the experiences you need to go further in your journey.
Freedom to explore and innovate
You will get opportunities to be bold, try new things and really make your mark. Our strategic partnership with technology leaders, award-winning Capgemini Research Institute and alliances with startups provides you with an ecosystem to innovate fueled by an entrepreneurial spirit.
A network of people to inspire you
From 7 people in 1967 to over 325,000 employees in more than 50 countries today, people are at the heart of everything we do. You ll belong to an inclusive network of people to learn from each other, share knowledge and be part of a global team.
Our culture of camaraderie and team spirit will enhance your experiences and your career with us.
An environment where you thrive
We are passionate about finding new ways technology can help us reimagine what s possible. Our people-driven culture, ethics and values will guide you to harness that energy source inside you to get the future you want. We are rated as the most ethical company to work in, 10 years in a row.
Learning for life
You will have access to an always-on learning ecosystem designed to spark your curiosity and fuel your imagination. We have partnered with some of the world's leading learning and development content providers to help you build skills of the future, today.
The flexibility to work your way
We give you the digital tools and flexibility to gain meaningful experiences and connections to build the ways of working that are right for you. Our collaborative and agile work environment supports you to drive your professional development in the most suitable conditions.
An opportunity to make the difference
Together, we fight exclusion, promote diversity, preserve natural resources, act on climate change and ensure equal opportunities. And we help our clients do it too. Our goal is to be carbon net-zero by 2030. Let s take on the challenge, together.
About Us
Headquartered in Paris, France and operates in more than 50 countries with 325,000 team-members.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs