Data Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Sogeti · 1 day ago

Data Engineer

Sogeti is part of the Capgemini Group, focused on delivering technology solutions that drive business value. The Data Engineer role involves gathering requirements, designing data solutions, and monitoring data pipelines to ensure efficient data processing.

ConsultingInformation TechnologyProfessional ServicesSoftware
badNo H1Bnote
Hiring Manager
Harneet S.
linkedin

Responsibilities

Ability to gather and understand requirements by studying features/ user stories created for requirements and work on implementing them
Design and development for the change requests from client
Ability to analyze existing data flow and suggest for any enhancements/ improvements based on technical expertise
Preparing test scenarios/ test cases for the user stories and sharing the unit testing results as part of the development completion
Monitor data extract, transform, and load (ETL) jobs, pipelines and work to fix the job failures
Troubleshooting to identify data issues and solving any data discrepancies and providing business intelligence insights
Provide support to the users on any data related questions/issues reported during UAT and PROD cycles

Qualification

Microsoft SQL ServerDatabaseETL designT SQLAzure SynapseDAX queriesPython (pyspark)Excel data analysisTroubleshootingUser support

Required

Expertise/ at least 7+ years of experience in Microsoft SQL Server
Expertise/ at least 7+ years of experience in Database and ETL design concepts
Expertise/ at least 7+ years of experience in T SQL
Expertise/ at least 7+ years of experience in SQL server Analysis server
Expertise/ at least 7+ years of experience in Azure Synapse – including creating scripts for ETL using Python(pyspark)
Expertise/ at least 7+ years of experience in Experience with excel – includes creating data pivots to different sources for analyzing
Bachelor's Degree

Preferred

Fluent in DAX queries (good to have)
Good to have prior experience with Microsoft projects, process, and tools (like VSTS, VSO)

Benefits

Flexible work options
401(k) with 150% match up to 6%
Employee Share Ownership Plan
Medical, Prescription, Dental & Vision Insurance
Life Insurance
100% Company-Paid Mobile Phone Plan
3 Weeks PTO + 7 Paid Holidays
Paid Parental Leave
Adoption, Surrogacy & Cryopreservation Assistance
Subsidized Back-up Child/Elder Care & Tutoring
Career Planning & Coaching
$5,250 Tuition Reimbursement & 20,000+ Online Courses
Employee Resource Groups
Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being
Disaster Relief Programs

Company

Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Steve Young
Chief Operating Officer - USA
linkedin
leader-logo
Chris Wilkins, ITIL, SAFe Agilist, A-CSM
Client Partner
linkedin
Company data provided by crunchbase