Lead Data Engineer-CHICAGOLAND AREA LOCALS ONLY

YOU MUST BE LOCAL TO CHICAGOLAND-Open to relocation is not acceptable. Non-locals will not be reviewed/considered.

Sogeti is looking for a local, talented Lead Data Engineer to join our Chicagoland team built on the success of our people and partnerships. Come be a part of our “People centric” culture!

Sogeti is a wholly-owned subsidiary of Capgemini and the Technology and Engineering Services Division of Capgemini. We have more than 25,000 professionals in 15 countries and has a strong local presence in over 100 locations scattered throughout the US, Europe and India.

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 THE employer of choice!

POSITION HIGHLIGHTS

You would be hired as a permanent Sogeti Consultant. An expert in field who will provide guidance and experience a variety of exciting projects, work within different workplaces with diverse teams and various industries.

All Sogeti Prospective Candidates Must:

Possess a Bachelor’s and/or Master’s degree from an accredited institution.

Must have valid work authorization that does not currently and/or will not require future require sponsorship of a visa for employment authorization in the US by Sogeti-Capgemini.

JOB SUMMARY

Technical Skills, Tools, Technologies, Certifications:

• SQL
• Azure Databricks
• PySpark
• SparkSQL
• Azure/Azure Data Lake Storage (ADLS)
• Data engineering certifications required such as: MS Azure Fundamentals-AZ 900, Azure Data Fundamentals-DP 900, Azure Data Engineer Associate, Databricks Certified Data Engineer-Associate/Professional, Certified Data Management Professional (CDMP)-DAMA International, MS Fabric certification, preferred (Fabrics Analytics Engineer Associate, Fabric Data Engineer Associate).

We are looking for a bright minded, self-motivated, team player with a strong background and skilled with a high degree of intellectual curiosity and abilities with:

• 8 years of experience with advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases.
• 3-5 years of the 8 years hands-on experience with physical and relational data modeling.
• Solid understanding of dimensional data modeling and ER-Modeling.
• Extensive knowledge of/experience with data integration, data quality, multi-dimensional design, ETL tools, processes, and methodologies.
• Analyzing and translating business needs into long-term solution data models.
• Considering Exact, Transform and Load (ETL) and reporting challenges in designing data models.
• Great numerical and analytical skills.
• Reviewing modifications of existing systems for cross-compatibility.
• Reviewing data model with both technical and business audiences, as well as data governance.
• Updating and optimizing local and metadata models.
• Creating and maintaining optimal data pipeline architecture.
• Analyzing and organizing raw data.
• Assembling large, complex data sets that meet functional/non-functional business requirements.
• Preparing data for prescriptive and predictive modeling.
• Building algorithms and prototypes.
• Combining raw information from different sources.
• Exploring ways to enhance data quality and reliability.
• Creating data tools for analytics and data scientist team members.
• Collaborating with stakeholders including: data, design, product and executive teams and assisting with data-related technical issues.
• Working with stakeholders including: Executive, Product, Data and Design teams to support data infrastructure needs while assisting with data-related technical issues.
• Working with data and analytics experts to strive for greater functionality in data systems.
• Collaborating with data scientists and architects on several projects.
• Identifying, designing and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Supporting and working with cross-functional teams in a dynamic environment.
• Building processes supporting data transformation, data structures, metadata, dependency and workload management.

Benefits our employees enjoy working at Sogeti USA:

401(k) Savings Plan: matched 150% up to 6%. Our 401k is in the top 1% of 401(k) plans offered in the US!

Employee Stock Option Plan

Annual Individual Bonus Plan

Medical/Prescription/Dental/Vision Insurance

Life Insurance

100% Company-paid Mobile Phone Plan

Personal Time Off (PTO)

Career Planning and Coaching Program

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.

Paid Parental Leave

Adoption Assistance

Counseling, Employee Assistance and other Support Programs for Physical, Financial, Family & Social, Emotional & Spiritual Wellbeing

Equal Employment Opportunity

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state or local law.

Sogeti-Capgemini discloses salary range information in compliance with state and local pay transparency obligations.

The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Sogeti-Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for this role is located in this job posting.

This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested and determinable. The amount and availability of any bonus, commission or any other form of compensation that are allocable to a particular employee remains in our sole discretion unless and until paid and may be modified at the our sole discretion, consistent with the law.

Please be aware that Sogeti-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.

In order for you to be reviewed and receive feedback on your application, all prospective candidates must possess all requirements-qualifications (exact or comparable). If you do not receive feedback, you are welcome to reach out to me at any point for more specifics.

Paige Evans, Senior Corporate IT Recruiter | Illinois

Sogeti-Capgemini

E: paige.evans@sogeti.com