C360 - Business Ops/Analyst

Capgemini • Toronto, ON

2d • $120,000 - $145,000 • Onsite

About The Position

At Capgemini Invent, we believe difference drives change. As inventive transformation consultants, we blend our strategic, creative and scientific capabilities, collaborating closely with clients to deliver cutting-edge solutions. Join us to drive transformation tailored to our client's challenges of today and tomorrow. Informed and validated by science and data. Superpowered by creativity and design. All underpinned by technology created with purpose. 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.

Requirements

• 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

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed