The Senior BW Consultant will lead SAP BW strategy, architecture, implementation, and transformation initiatives for clients, ensuring business requirements are delivered efficiently and aligned with client objectives. This role is accountable for end-to-end solution design, development, and deployment, while building strong client relationships to understand and address data warehousing, reporting, and analytics needs.
The consultant will drive effort estimation, resource planning, and scope alignment, collaborating with stakeholders to define clear deliverables and milestones. Additionally, they will lead the design and deployment of SAP reporting and analytics solutions across multiple functional areas, while providing regular status updates to CGI and client program/project leadership.
The Senior BW Consultant is responsible for identifying and obtaining the data required to satisfy the requirements of a BW project and has expert level knowledge about the different flavors of BW (BW, BW on HANA, BW/4HANA; BDC). The scope of data involved may include SAP S/4 HANA, SAP ECC centric data, external legacy data or third party data.
Your future duties and 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.
The Senior BW Consultant will work closely with other SAP team members responsible for other SAP functional areas and have a thorough understanding of the way the data is used to make business decisions.
Required qualifications to be successful in this role
. 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 in 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 skills
. French 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 factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $95,000–$145,000. This role is an existing vacancy.
#LI-RD12
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. 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.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team—one of the largest IT and business consulting services firms in the world.
