SAP Business Warehouse Analyst

On behalf of our public sector client, Affinity is looking for a SAP Business Warehouse Analyst to design and deliver robust reporting and analytical solutions to drive the City’s ongoing evolution in the Analytics and Reporting area.

Responsibilities:

• Liaise with the business representatives to gather requirements, specifications, and relative priorities for BI-IP and BW reports.

• Develop BEx queries to meet City’s requirements. This includes developing and maintaining any necessary domains, data elements, characteristics or similar objects in the BW Workbench.

• Liaise with the BW extraction transformation and load (ETL) team to determine the ETL scheduling, monitoring and administration processes so that the City’s reporting requirements are met.

• Liaise with the Enterprise Reporting Systems (ERS) team to translate the requirements for Business Objects queries.

• Support financial planning reporting requirement to support the City’s budget cycles.

• Determine and document the required structures of data cubes and master data to meet City’s reporting requirements.

• Trouble shooting, error analysis, and diagnostics of BW ETL, BW and BI-IP issues.

• Configuration of BW Process Chains

• Facilitate integration testing of BW and BI-IP related functional and technical designs and business processes.

• Facilitate user acceptance testing of any BW and BI-IP related project or enhancement.

• Facilitate workshops to train the trainers or end users.

• Transfer knowledge to designated City resources so that over time the City becomes self-sufficient in the area of BW and BI-IP related business analysis.

• Assign tasks to BW team members & ensure delivery of tasks.

• Coordinate with various technical resources such as the SAP Basis team and the SAP development team to ensure that the technical components function optimally, thus provide a solid and reliable system environment for the project.

• Prototype and perform tasks for enhancements, ensuring alignment with organizational goals, including data governance standards.

• Liaise with functional team leads as appropriate.

Qualifications:

• Minimum of 8 years’ recent experience implementing and supporting enterprise SAP BW in medium to large organizations,

• Five years recent experience in senior-level BW analysis and support.

• Ability to oversee and plan all activities around the management of SAP-BW systems/programs with a focus on service delivery and a proactive outlook

• Knowledge of data warehousing and business intelligence (BI) is required.

• Proficiency in PowerBI, and Advanced skills in Microsoft Excel

• Experience with SQL, relational databases and python

• Strong communication skills to build professional relationships with business partners across the organization

• Ability to manipulate data with tools, draw conclusions, and relate back to business problems and solutions

• Track record of balancing multiple priorities simultaneously with the ability to adapt to the changing needs of the business while meeting deadlines

Interpersonal and Communication Skills

• High level of professionalism and ethics

• Strong interpersonal skills and communication skills

• Work closely and build strong trust-based relationships with new and existing clients while collaborating with the Spot Solutions team members over the entire life cycle of the project.

• Be highly organized, analytical, naturally collaborative, and the primary advocate for the functional area.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12108