Your Role MS Sales business operations team, oversees Microsoft's revenue reporting process, collaborating with source data partners, business users to address data or functional issues. They are responsible for overseeing the entire end-to-end process of revenue publishing, pinpointing and resolving data and code issues in collaboration with the technical team. The business operations team not only manages reporting but also engages in functional and code testing of new features, play a crucial role in educating external users, addressing their queries, and ensuring a clear understanding of the processes. The team conducts thorough data analysis to guarantee the precision and efficiency of reporting procedures. Job description: • Write, test and schedule audits for data validations reports using SQL Stored Procedures, Views and Functions • Collecting and analyzing large and complex data sets • Validating data to ensure accuracy and completeness • Conducting ad-hoc analysis, solving data discrepancies, and generating actionable business insights. • Ability to work on Level 2 Service Requests from business users • Willing to extend support on production issues during non-business hours • Understand data lineage, data quality and relationships • Monitor data extract, transform and load jobs and respond to any job failures • Development support for platforms and applications assigned • Document knowledge base articles for Tier-1 and Tier-2 • Dedicate 20%-30% of time for Development efforts - Automation of operational activities, data quality checks, application feature development, develop tabular models, bug fixes and reporting • Perform data engineering related activities e.g. developing and enhancing tools/solutions/processes based on data analysis and/or new customer requirements • Work with client and team members for performance improvement and suggestions • Awareness on azure skills Qualifications & Experience Required skill set: • Intermediate to expert level experience in Microsoft SQL Server - Writing Complex Queries; Debug existing Stored procedure; DB Performance improvement; Developing quality audits • Intermediate level experience in PowerBI and Excel (VBA, Lookups, pivots, etc.) • Working knowledge on Azure stack - Synapse, Spark/Python, SQL Azure, Azure Data Factory (ADF) - Ability to quickly ramp up on Azure • Experience working on project management tools like Azure DevOps (ADO), JIRA, etc. • Good analytical and problem solving skills • Excellent communication skills and ability to work with customer stakeholders and cross-functional teams by effectively understanding the business requirements Preferred skills: • Ability to work in agile environment, deal with ambiguity and critical thinking to achieve the expected results within SLAs • Having a systematic and logical approach to problem-solving • Prior experience in Microsoft landscape or Corporate finance space is preferred • Willing to learn new technologies The base compensation range for this role in the posted location is: $120k to $145k 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