Position Description The Senior BW Consultant is a professional who will lead the SAP BW strategy, architecture, implementation, and transformation projects for our clients. The Senior BW Consultant will ensure that business requirements are implemented efficiently and according to plan and that the client goals are satisfactorily attained. The Senior BW Consultant will be accountable for solution design, development, and deployment. This will entail developing effective working relationships with the client team to understand their business warehouse, reporting, and analytical requirements. Project effort and resource estimation skills are required, as is the ability to collaborate with the client to agree on the scope of deliverables and milestones. The Senior BW Consultant will lead the solution design, development and deployment of SAP reporting and analytics across multiple functional areas. The Senior BW Consultant will present weekly status updates to the CGI and/or Client Program/Project Manager. Responsibilities Establish connections to BW source Systems Activate standard Business Content Develop the BW data architecture including design and specifications Enhance the InfoProviders (ADSO, Composite Provider and Classic InfoProviders) as required based on the BW data architecture Enhance the Queries as required based on the BW data architecture Define Authorization profiles and access Evaluate statistical performance and make recommendations for BASIS support to optimize settings where possible Identify the data in source environments Map the data to the BW environment Identify data quality gaps Develop the plan to close data quality gaps Develop the required extraction programs, if necessary Develop the associated interface programs, if necessary Test all developed programs Ensure integration testing of data from various sources Develop the Production Cut-Over plan that includes data conversions, security deployment, final validations, and testing, and Post Go-Live Support. Execute on the Production Cut-Over plan. Qualifications SAP Certified (SAP BW on HANA, SAP BW/4HANA, BDC) 15+ years of BW implementation experience 15+ years of deep FICO integration along with Finance business processes Experience in LSA++ architecture design, data modeling, integration, and analytics Strong experience with modeling SAP BW's ADSO, Composite Provider, Open ODS Views, BEx, and Open Hub Must have very strong demonstrated knowledge and hands‑on experience with SAP HANA modeling (Analytical View, Attribute View, and Calculation View) Ability to write SQL Scripts, Store Procedures and integrate them within the Views Understand HANA Developer Studio Knowledge of ADT and CDS Views Ability to run SAP HANA Plan Visualizer (PlanViz) to analyze performance bottlenecks in the HANA views Understand the techniques to optimize performance of HANA Views Understand the filters and parameters used for HANA Views and how to effectively deploy them Solid written skills to translate functional requirements into technical specifications Knowledge of BOBJ, Qlik, or Tableau reporting tools would be a nice to have Excellent oral and written skills Thoroughness and clarity in definition of specifications Rigorous testing skillsFrench speaking is an asset Collaborative team player CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes various factors including but not limited to skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $115,000 - $165,000. This role is an existing vacancy. As an equal‑opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter. #J-18808-Ljbffr