22 days ago
Base Salary
$54k - $122k/yr
Responsibilities
- Administer SAGE Datawarehouse cubes, reporting databases, servers, backups, indexes, drivers, plug-ins, configurations, and maintenance services.
- Maintain internal reporting and install-base databases, lookup tables, error classifications, cubes, stored procedures, and automated reports.
- Create complex queries and monitor, troubleshoot, and improve automated reporting jobs and report-generation performance.
- Collaborate with resources to resolve SAGE Datawarehouse interface issues and implement required modifications.
- Apply AI/ML-driven techniques for query optimization, anomaly detection, predictive maintenance, error classification, predictive analytics, intelligent reporting, dashboards, and data retrieval.
- Monitor hardware and software performance, identify data clogs, preserve data, and resolve system and reporting issues.
Requirements
- At least 5 years of experience in database schema design, development, and management.
- Experience with database administration and performance optimization, including SQL Server, indexing, query tuning, and backups.
- Experience with data warehousing, ETL management, SAGE Datawarehouse, cubes, and data extraction.
- Experience developing complex SQL queries, stored procedures, and automated reporting.
- Experience with system monitoring, job monitoring, performance tracking, troubleshooting, and issue resolution.
- Experience with AI/ML and advanced analytics, including anomaly detection, predictive analytics, AI-driven optimization, and dashboards.
Benefits
- Remote work arrangement.
- Paid time off including 12–25 vacation days depending on employee grade, company-paid 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 available according to local policy and eligibility.
Tech Stack
Microsoft SQL Server
Categories
BackendData 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.