Data Engineer

Overview

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 division of Capgemini S.A., listed on the Paris Stock Exchange.

Commitment to Employees

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!

Job Description

We are seeking a skilled Data Engineer to join our team. The successful candidate will play a crucial role in assessing, understanding, and translating SAS code into Python, ensuring functionality, performance, and accuracy are maintained throughout the migration process. This role requires expertise in SAS, SQL, and Python, along with proficiency in data manipulation, statistical analysis, and optimization techniques.

Job Responsibilities/Scope

• Assess and comprehend the functionality of existing SAS scripts, including data manipulation processes, statistical analyses, and relevant operations.
• Identify requirements for conversion, determining desired functionality, performance goals, and additional features needed in Python.
• Evaluate data handling in SAS scripts, including input/output, cleaning, transformation, merging, and analysis; determine corresponding methods and libraries in Python.
• Analyze statistical procedures in SAS scripts; identify equivalent methods and libraries in Python such as NumPy, SciPy, Pandas, Statsmodels, or scikit-learn.
• Translate SAS code syntax and structure into Python, converting procedures, statements, functions, and macros; consider differences in syntax, data types, and control structures.
• Determine alternative approaches or workarounds in Python for SAS features without direct equivalents.
• Thoroughly test converted Python scripts to ensure accurate results consistent with original SAS scripts; validate against known benchmarks or test cases.
• Optimize Python code for performance and efficiency, considering memory usage, execution speed, and scalability; apply optimization techniques and parallel processing where necessary.
• Document conversion process, rationale behind decisions, challenges encountered, and steps taken to address them; provide comprehensive documentation for converted Python scripts.
• Integrate converted Python scripts into existing workflows or systems as needed; ensure compatibility and deploy in appropriate production environment.

Required Skills/Qualifications

• Strong SAS, SQL, and Python proficiency.
• Experience working with relational databases.
• Exposure to Snowflake and Databricks is mandatory.
• Strong understanding of SAS programming syntax and functionality, as well as expertise in Python programming including libraries like NumPy, Pandas, SciPy, etc.
• Proficiency in data manipulation, cleansing, transformation, and analysis; ability to handle various data formats and perform statistical analyses using Python.
• Understanding of statistical methods for translating SAS procedures into Python equivalents; ability to select appropriate methods and interpret results accurately.
• Familiarity with data engineering concepts such as ETL, data pipelines, data warehousing, and data modeling; ability to design efficient workflows and optimize pipelines.
• Analytical skills to identify bottlenecks, propose effective solutions, and troubleshoot migration issues.
• Ability to conduct thorough testing and validation of the converted Python scripts to ensure accuracy, reliability, and performance consistency compared to the original SAS scripts.

Education

Bachelor's or Master's degree or equivalent experience in Computer Science, Software Engineering, or a related field.

Life at Sogeti

We support 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) (matched 150% up to 6%) and Employee Share Ownership Plan
• 100% Company-paid mobile phone plan
• 3 weeks Personal Time Off (PTO) and 7 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
• Continuing Education: $12,000 Annual Tuition Reimbursement plus access to over 20,000 online courses and certifications through Capgemini University, as well as Coursera and Degreed
• Programs for Counseling, Support, Health and Fitness perks, Auto discounts and much, much more!
• Employee Resource Groups
• Disaster Relief

Disclaimer

Capgemini 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.

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.