**Team Info:** Microsoft FDnE 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:** **Collaboration and Stakeholder Engagement** - Work with Finance Managers and other business partners to develop the project roadmap and the product backlog. -Work closely with business stakeholders to gather data requirements and translate them into technical solutions. - Provide technical expertise and guidance on best practices in discussions about data governance, data privacy and data security. - Lead data engineers and data analysts in implementing complex data initiatives, ensuring data pipelines meet both business and technical objectives. - Ensure clear and timely communication with stakeholders to align on project updates, risk management , and deliver results within deadlines. **Data Architecture and Design** - Design and build robust, scalable and efficient data architectures and frameworks for data projects. -Implement scalable, efficient, and secure data pipelines to process large volumes of structured and unstructured data. - Design data models, ensuring that data structures are optimized for analytics and reporting needs. - Define and enforce data architecture best practices and standards across the organization. - Collaborate with data engineers, analysts, and stakeholders to ensure data is structured in a way that meets business and analytical requirements. **Data Integration and Management** - Integrate data from various sources, such as data lakes, databases and cloud platforms ensuring consistency and accuracy. - Develop pipelines to extract and transform data for deriving actionable insights and analytics purposes. - Monitoring, troubleshooting and resolving issues related to data integrity - Implement data warehousing solutions and manage the optimization of data storage, retrieval, and processing for performance and scalability. **Performance Optimization and Scalability** - Optimizing data pipelines and queries for performance and scalability. - Troubleshoot and resolve performance issues in data pipelines and processing workflows. - Implement data caching, partitioning, and indexing strategies to improve query performance. - Apply strategies including partitioning , sharding and parallelization to ensure data systems can grow and adapt to increased volume and demand. **Data Analytics and Reporting:** -Design, develop and maintain data models and semantic models to optimize reporting and analysis performance -Develop and automate reports and dashboards to provide insights into key business metrics -Build custom reports and data visualizations to support specific business needs and decision making **Required skill set:** + Writing Queries; Developing quality audits + Exposure to PowerBI and Excel (VBA, Lookups, pivots, etc.) + Experience working on project management tools like Azure DevOps (ADO), JIRA, etc. + Experience in Azure Data Factory (ADF) , Azure Sql Server , Azure Synapse Analytics , Azure Semantic Models, Tabular Model , PySpark (Azure Notebooks) , Power BI , DAX , T-SQL. + Excellent analytical and problem-solving skills + Ability to work in Agile environment, deal with ambiguity and critical thinking to achieve the expected results within SLAs + Excellent communication skills and ability to work with customer stakeholders and cross-functional teams by effectively understanding the business requirements + Experience with Project management and financial management with complex business challenges. **Life at Capgemini** Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: + Collaborating with teams of creative, fun, and driven colleagues + Flexible work options enabling time and location-based flexibility + Company-provided home office equipment + Virtual collaboration and productivity tools to enable hybrid teams + Comprehensive benefits program (Health, Welfare, Retirement and Paid time off) + Other perks and wellness benefits like discount programs, and gym/studio access. + Paid Parental Leave and coaching, baby welcome gift, and family care/illness days + Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring + Tuition assistance and weekly hot skill development opportunities + Experiential, high-impact learning series events + Access to mental health resources and mindfulness programs + Access to join Capgemini Employee Resource Groups around communities of interest **About Capgemini** Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion. Get The Future You Want | www.capgemini.com (http://www.capgemini.com/#\_blank) **Disclaimer** Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law. This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship. Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact. Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process. Applicants for employment in Canada must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in Canada by Capgemini. **Job:** _Transformation Consultant_ **Organization:** _INVENT PEOPLE C360_ **Title:** _Capgemini Invent - Reporting Solutions Lead_ **Location:** _CAN-BC-Vancouver_ **Requisition ID:** _080625_ **Other Locations:** _Canada_