Snowflake Data Engineer / Lead Sogeti P&G unit (remote)
Sogeti USA

Job Info

---

Sogeti is a leading provider of professional technology services, specializing in Application Management, Infrastructure Management and High-Tech Engineering. Sogeti offers cutting-edge solutions around Testing, Business Intelligence, Mobility, Cloud and Security, combining world class methodologies and the global delivery model, Rightshore®. Sogeti brings together more than 20,000 professionals in 15 countries and is present in over 100 locations in Europe, the US and India. Sogeti is a wholly-owned subsidiary of Cap Gemini S.A., listed on the Paris Stock Exchange.

At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice!

What You'll Do

• Snowflake Engineer / Lead for our Sogeti P&G Unit (remote) must be US Citizen, Green Card, or OPT.

Minimum education qualification

• Bachelor's Degree or Experience

The ideal candidate will have:

• • Snowflake SQL: Writing SQL queries against Snowflake, Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data• Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing• Hands-on experience with Snowflake stored procedures• Experience with Azure Data ecosystem and AzDo• In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.• Experience gathering and analyzing system requirements• Good to have familiarity with data visualization tools (Tableau/Power BI)• Ability to effectively function in a cross-team's environment• Work in an Agile Development Environments, Attend Ceremonies, Meet Sprint Deadlines Requirements:Bachelor's degree typically in Computer Science, Management Information Systems, Mathematics, Business Analytics or another STEM degree. 5+ years proven ability of professional data development experience2+ years developing experience with Snowflake2+ years developing experience with Python1+ years experience with PySpark/Spark1+ experience with AzureFull understanding of ETL conceptsExposure to GitStrong understanding of Agile Principles (Scrum)Good to have familiarity with Consumer data.

The benefits our employees enjoy:

• 401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!)
• Medical/Prescription/Dental/Vision Coverage!
• Low-premium and deductible. Plan with free preventive care.
• $12,000 in Tuition Reimbursement
• 100% Company-paid mobile phone plan
• Personal Time Off (PTO)- Ensuring a balance of work and home life

This job has expired.