2 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 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 2025 global revenues of €22.5 billion. Make it real | www.capgemini.com