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 part 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

• Create and maintain optimal data pipeline architecture

• Analyze and organize raw data-

• Combine raw information from different sources

• Explore ways to enhance data quality and reliability

• Create data tools for analytics and data scientist team members

• Provide technical guidance to the team, create technical specifications for various design patterns

• Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues

• Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

• Experience supporting and working with cross-functional teams in a dynamic environment.

• Build processes supporting data transformation, data structures, metadata, dependency, and workload management

• Assemble large, complex data sets that meet functional / non-functional business requirements.

• Prepare data for prescriptive and predictive modeling

• Build algorithms and prototypes

• Work with data and analytics experts to strive for greater functionality in our data systems.

• Collaborate with data scientists and architects on several projects

Minimum education qualification

• Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field.

The ideal candidate will have:

• 7+ years of experience in a Data Engineer role, with a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.

• Very good knowledge in

• SQL (8+ out of 10)

• Databricks on Azure (7+ out of 10)

• PySpark (7+ out of 10)

• SparkSQL (7+ out of 10)

• Azure/ADLS (7+ out of 10)

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

• Great numerical and analytical skills

• Data engineering certifications/Azure is a plus

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

Sogeti is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.