Job description

At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same. Location This is a remote position. About the job you’re considering Capgemini is looking for a highly skilled and experienced Software Engineer - Database Developer to join our outstanding Engineering team. As a Software Engineer - Database Developer, you will play an important role in maintaining and updating our databases, ensuring accurate data analysis and reporting. You will also collaborate with other team members to efficiently implement new queries, resolve any issues with automated jobs, and improve performance. More importantly, Leverage AI-driven techniques to automate error classification, enable predictive analytics for recurring issues, and deliver intelligent reporting, dashboards, and optimized data retrieval solutions. Your Role Data Base Administration: • Management of the data extractions from the SAGE Datawarehouse cubes (this requires, troubleshooting, maintenance and modifications as necessary) • Ensures that the servers hardware and software are updated (RARS mainly) • Making sure that the new drivers, plug-ins are updated. Make sure to run the maintenance services , keep the indexes up to day, adapt to the IT network changes, protection against virus, etc. • Monitoring of the performance of the hardware and software • Preserving data. Organize the data and secure backups • Changes to the server configuration as needed Reporting (Error summary and system and shot reports): • Maintain both data bases: the internal reporting and the IB one • Update the look up tables for new errors and new classification of errors per weight and functional category • Update the cubes to allow queries that are required to analyze the data • Create new queries that allow to get the necessary reports from the existing cubes (internal testing and install base) • Monitor and troubleshooting of the daily automated jobs to run the reports. • Work with other resources when there are issues or modification are needed with the SAGE DW interface • Pre-emptive maintenance, look for data clogs and issue on the reports generation • Update the stored procedures for the excel reports with new errors, remove previous ones, add system info, etc • Apply AI/ML-driven tools and techniques for: • Database performance optimization (query tuning, indexing strategies, workload prediction) • Intelligent anomaly detection in system performance and data flows • Predictive maintenance of database infrastructure AI Integration in Reporting: • Leverage AI techniques for: • Automated error classification and pattern detection • Predictive analytics for identifying recurring system/reporting issues • Intelligent report generation and recommendation systems • Build and maintain smart dashboards with predictive insights and anomaly alerts. • Use AI-assisted tools to optimize report queries and improve data retrieval efficiency. Your Skills and Experience • Minimum of 5 years of experience in database schema design, development, and management • Database Administration & Performance Optimization (SQL Server, indexing, query tuning, backups) • Data Warehousing & ETL Management (SAGE DW, cubes, data extraction, ETL processes) • Reporting & SQL Development (complex queries, stored procedures, automated reporting) • System Monitoring & Troubleshooting (job monitoring, performance tracking, issue resolution) • AI/ML & Advanced Analytics (anomaly detection, predictive analytics, AI-driven optimization & dashboards) The base compensation range for this role in the posted location is: $53,580 - $122,400/Year Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law. The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction. These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity. It is not typical for candidates to be hired at or near the top of the posted compensation range. In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws. Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include: • Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada) • Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada) • Life and disability insurance • Employee assistance programs • Other benefits as provided by local policy and eligibility Important Notice: Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation. Disclaimers Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. 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 accommodation does not pose an undue hardship. Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact. 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. Click the following link for more information on your rights as an Applicant in the United States. capgemini.com Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

Requirements

Must-haves

This is a remote position.
About the job you’re considering
Management of the data extractions from the SAGE Datawarehouse cubes (this requires, troubleshooting, maintenance and modifications as necessary)
Ensures that the servers hardware and software are updated (RARS mainly)
Making sure that the new drivers, plug-ins are updated. Make sure to run the maintenance services , keep the indexes up to day, adapt to the IT network changes, protection against virus, etc.
Monitoring of the performance of the hardware and software
Preserving data. Organize the data and secure backups
Changes to the server configuration as needed
Reporting (Error summary and system and shot reports):
Maintain both data bases: the internal reporting and the IB one
Update the look up tables for new errors and new classification of errors per weight and functional category
Update the cubes to allow queries that are required to analyze the data
Create new queries that allow to get the necessary reports from the existing cubes (internal testing and install base)
Monitor and troubleshooting of the daily automated jobs to run the reports.
Work with other resources when there are issues or modification are needed with the SAGE DW interface
Pre-emptive maintenance, look for data clogs and issue on the reports generation
Update the stored procedures for the excel reports with new errors, remove previous ones, add system info, etc
Database performance optimization (query tuning, indexing strategies, workload prediction)
Intelligent anomaly detection in system performance and data flows
Predictive maintenance of database infrastructure
Automated error classification and pattern detection
Predictive analytics for identifying recurring system/reporting issues
Intelligent report generation and recommendation systems
Build and maintain smart dashboards with predictive insights and anomaly alerts.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aimlsqlaccessibility

Platform: successfactors
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off