9 days ago
Base Salary
$54k - $122k/yr
Responsibilities
- Manage data extractions from SAGE data warehouse cubes, including troubleshooting, maintenance, and modifications.
- Maintain databases, servers, drivers, plug-ins, indexes, backups, server configurations, and related infrastructure.
- Monitor hardware and software performance and maintain data preservation and security processes.
- Maintain internal and install-base reporting databases, lookup tables, cubes, stored procedures, and automated reports.
- Create and update complex queries and stored procedures for reporting, analysis, and data retrieval.
- Monitor and troubleshoot daily automated reporting jobs and resolve SAGE data warehouse interface issues.
- Perform preventative maintenance by identifying data clogs and report-generation issues.
- Apply AI/ML techniques for database optimization, anomaly detection, predictive maintenance, error classification, predictive analytics, and intelligent reporting.
- Build and maintain dashboards with predictive insights and anomaly alerts.
Requirements
- At least 5 years of experience in database schema design, development, and management.
- Experience with SQL Server, indexing, query tuning, and database backups.
- Experience with data warehousing, SAGE data warehouse cubes, data extraction, and ETL processes.
- Experience developing complex SQL queries, stored procedures, and automated reporting.
- Experience monitoring jobs and system performance and troubleshooting issues.
- Experience with AI/ML, anomaly detection, predictive analytics, AI-driven optimization, and dashboards.
Benefits
- Remote work arrangement.
- Annual paid time off, including 12–25 vacation days depending on employee grade, company holidays, personal days, and sick leave.
- Medical, dental, and vision coverage, or provincial healthcare coordination in Canada.
- Retirement savings plans such as 401(k) in the U.S. or RRSP in Canada.
- Life and disability insurance and employee assistance programs.
- Additional benefits may be provided according to local policy and eligibility for regular, full-time employees.
Tech Stack
Microsoft SQL Server
Categories
Data Engineering
About Capgemini
Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.