Capgemini

Data Modeling - SQL Engineer

Capgemini  •  $80k - $106k/yr  •  Chicago, IL (Hybrid)  •  10 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Job Location - Chicago IL (Day One Onsite - Hybrid)

  • We are seeking a highly skilled Data Modeling SQL Engineer with strong expertise in data architecture SQL development and cloudbased data platforms.
  • The ideal candidate will bring deep experience in designing scalable data models working with enterprise data systems and building efficient data pipelines to support analytics and business intelligence needs

s

Data Modeling and Development

  • Design develop and maintain robust data models to support business and analytical requirements
  • Understand and work with complex enterprise data structures and relationships
  • Develop scalable and efficient solutions for data transformation integration and reporting

SQL Development and Data Querying

  • Write optimize and troubleshoot complex SQL queries for data extraction transformation and analysis
  • Query and manage data from Snowflake tables and other enterprise data sources
  • Perform advanced SQL operations for reporting validation and business insights

Data Extraction and Integration

  • Fetch and process data from Snowflake OneLake and other internal external applications
  • Extract outputs from applications databases and SQL based systems for downstream processing and analytics
  • Read and process structured and semi structured data files from multiple sources

Cloud and Platform Deployment

  • Deploy data models and related solutions to modeling platforms and cloud based environments
  • Work with AWS services to build and support data engineering and analytics workloads
  • Utilize OpenShift Container Platform OCP for deployment orchestration and management of applications and services

Data Modeling and Development

  • Design develop and maintain robust data models to support business and analytical requirements
  • Understand and work with complex enterprise data structures and relationships
  • Develop scalable and efficient solutions for data transformation integration and reporting

SQL Development and Data Querying

  • Write optimize and troubleshoot complex SQL queries for data extraction transformation and analysis
  • Query and manage data from Snowflake tables and other enterprise data sources
  • Perform advanced SQL operations for reporting validation and business insights

Data Extraction and Integration

  • Fetch and process data from Snowflake OneLake and other internal external applications
  • Extract outputs from applications databases and SQL based systems for downstream processing and analytics
  • Read and process structured and semi structured data files from multiple sources

Cloud and Platform Deployment

  • Deploy data models and related solutions to modeling platforms and cloud based environments
  • Work with AWS services to build and support data engineering and analytics workloads
  • Utilize OpenShift Container Platform OCP for deployment orchestration and management of applications and services

Data Modeling and Development

  • Design develop and maintain robust data models to support business and analytical requirements
  • Understand and work with complex enterprise data structures and relationships
  • Develop scalable and efficient solutions for data transformation integration and reporting

SQL Development and Data Querying

  • Write optimize and troubleshoot complex SQL queries for data extraction transformation and analysis
  • Query and manage data from Snowflake tables and other enterprise data sources
  • Perform advanced SQL operations for reporting validation and business insights

Data Extraction and Integration

  • Fetch and process data from Snowflake OneLake and other internal external applications
  • Extract outputs from applications databases and SQL based systems for downstream processing and analytics
  • Read and process structured and semi structured data files from multiple sources

Cloud and Platform Deployment

  • Deploy data models and related solutions to modeling platforms and cloud based environments
  • Work with AWS services to build and support data engineering and analytics workloads
  • Utilize OpenShift Container Platform OCP for deployment orchestration and management of applications and services

s (2)

Python Development

  • Develop data processing automation and integration scripts using Python
  • Build reusable Python based components for data ingestion transformation and validation
  • Support data workflows and analytics use cases through efficient Python programming

Data File Handling and Processing

  • Read validate and process data files from various enterprise systems
  • Ensure data quality consistency and completeness across multiple data sources
  • Support file based ingestion and transformation workflows

Collaboration and Solution Delivery

  • Work closely with business stakeholders architects analysts and technical teams to understand requirements and deliver solutions
  • Participate in solution design discussions and provide recommendations for data architecture and implementation
  • Support production deployments troubleshooting and performance optimization

Required Skills and Experience

  • 10 years of overall IT experience in software development data engineering or related technical roles
  • Strong experience in data modeling and understanding of data structures and enterprise data flows
  • Strong hands on experience in complex SQL development and query optimization
  • Experience in deploying solutions to modeling platforms
  • Proven experience in fetching and querying data from Snowflake and One Lake
  • Strong experience with AWS cloud services
  • Hands on experience with OCP OpenShift Container Platform
  • Strong programming experience in Python
  • Experience in reading and processing data files from multiple sources
  • Experience in extracting outputs from applications and SQL systems
  • Strong analytical and problem solving skills
  • Ability to work independently and in a collaborative team environment
  • Strong communication skills with the ability to interact effectively with business and technical stakeholders

Life At Capgemini

Capgemini supports 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) and Employee Share Ownership Plan
  • Paid time off and 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
  • 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.

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

Salary Transparency

The primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effe

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 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 the tagged location is $80420 to $106050 /yearly.
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 the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

ctively to drive business outcomes.

For this role, the gross annual base salary range is $80420 to $106050 for a full-time position. This range covers base pay only; we will discuss any bonuses, incentives, and benefits during the hiring process. Your exact offer will depend on objective, job-related factors – like your experience, skills, and qualifications – in line with our fair pay principles. If a collective labour agreement applies to this role, we will share the relevant pay scale details with you. Note: We never ask about your current or past salary during our recruitment process.

Capgemini

About Capgemini

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

Make it real | www.capgemini.com

Industry
IT & Software
Company Size
10,000+ employees
Headquarters
Paris, FR
Year Founded
Unknown
Social Media