Us_east | Data Architect \/ Da..

Job Description Description:

Submit candidates under their legal name and use only Capgemini template"

Role: B4T4Q1 - Snowflake data architect Work location: Atlanta, GA - onsite. Background check MANDATORY Request ID: B4T4Q1 Pursuit

"The main visas we should accept are the following: H1B L-2 EAD H-4 EAD AOS EAD Green Card Holder US Citizen***"

JOB DESCRIPTION Key Responsibilities: • Architect and implement scalable data solutions using Snowflake. • Design and optimize data models (star, snowflake, normalized) to support analytics and reporting. • Lead the migration of legacy data warehouses to Snowflake. • Define and enforce best practices for data ingestion, transformation, and storage. • Collaborate with data engineers, analysts, and business stakeholders to align data architecture with business goals. • Implement security, data governance, and compliance standards. • Monitor and optimize Snowflake performance and cost efficiency. • Stay current with Snowflake features and industry trends to drive innovation.

Must-Have Skills: • 5+ years of experience in data architecture or engineering roles. • 3+ years of hands-on experience with Snowflake. • Strong expertise in SQL and data modeling (dimensional and normalized). • Experience with ETL/ELT tools (e.g., dbt, Matillion, Informatica). • Strong understanding of building ETL / ELT workloads using snowproc and snowflake SQL • Proficiency in cloud platforms (AWS). • Knowledge of data security, role-based access control, and data masking in Snowflake. • Experience with performance tuning and cost optimization in Snowflake.

Nice-to-Have Skills: • Experience in the life • Snowflake certification (SnowPro Core or Advanced Architect). • Experience with CI/CD pipelines for data workflows. • Familiarity with Python or Scala for data processing. • Experience with orchestration tools (e.g., Airflow, Prefect). • Knowledge of data cataloging tools (e.g., Alation, Collibra). • Exposure to real-time data streaming (e.g., Snowpipe). • Experience in Agile/Scrum environments.

"Mandatory:

Please use candidate's legal name always Please add the candidate’s ID at the end of resume Videocalls for interviews are a MUST Please add in the comments section for each Candidate the following:"

Please send Candidates with this information Possible 3 Month CTH Legal name: Location (USA, City and State): Relocate? Rate: Travelling availability (if required) Availability: Phone #: Mobile#: LinkedIn: Skype ID: Email address: Visa type: Visa expiring date: Hiring Status: If ex Capgemini employee (Y/N): If yes, please share client's name, manager and email. If the resource has a visa, what company owns it? Are you working directly with the contractor’s visa holder? Had the contractor worked in Capgemini before SKYPE INTERVIEW IS MANDATORY

Resumes will be rejected for the following reasons:

• Different format

• Missing details in comments section

• Missing text box in the header

• Photo ID included containing personal information other than legal name and photo

Estefania Ocheita External Resource Manager (ERM) | SubCo Staffing Center Capgemini North America | Guatemala

Named Job Posting? (if Yes - needs to be approved by SCSC)

try { var fgTooltip = new FG.Tooltip({ element: $('#cf_descz1901221542246011397492e'), text: "To\x20be\x20populated\x20with\x20\x22Yes\x22\x20when\x20Job\x20Seeker\x20to\x20be\x20onboarded\x20is\x20already\x20known\x20at\x20the\x20time\x20of\x20Job\x20Posting\x20creation.\x20Must\x20be\x20approved\x20by\x20SCSC." }).initialize(); } catch(err) {}

Additional Details Global Grade : BNamed Job Posting? (if Yes - needs to be approved by SCSC) : NoRemote work possibility : NoGlobal Role Family : 60242 (P) Data ManagementGlobal Technical Skills Family : 6248 (T) Data / Security / Infastructure SolutionsLocal Role Name : Snowflake Data ArchitectLocal Skills : Hannah MutchLanguages Required: : English