Business Warehouse (BW) Engineer

Roles / Responsibilities :

Under minimal supervision, the BW Engineer will be responsible for the following key tasks and deliverables :

• Migration Path Analysis and Recommendation
• Analyze SMUD's existing SAP BW on HANA codebase and architecture to recommend the most optimal and efficient migration strategies to SAP S / 4 HANA or SAP Datasphere platforms.
• Assess technical feasibility, risks, benefits, and impact on current operations, providing clear guidance to ensure smooth migration.
• HANA Calculated Views Development
• Design and deliver HANA calculated views tailored to meet detailed user requirements to support reporting and analytics needs.
• Ensure views are optimized for performance and scalability within SMUD's SAP environment.
• Development and Support of BW and HANA Objects
• Develop, maintain, and optimize SAP BW and HANA data objects and models required for key reporting areas including SAC Planning, Actuals, Labor, and Unit Cost models.
• Provide ongoing support and troubleshooting for these objects to ensure data accuracy and availability.
• Requirements Gathering and Impact Assessment
• Collaborate with stakeholders, business users, and subject matter experts to gather comprehensive requirements and conduct impact analyses related to migration and enhancement projects.
• Identify and mitigate potential negative consequences or disruptions stemming from migration activities or system changes.
• Documentation Creation and Knowledge Transfer
• Produce comprehensive, clear, and standardized documentation for all developed solutions following internal SMUD standards.
• Documentation will encompass process flows, technical specifications, installation / configuration guides, and operational manuals.
• Facilitate knowledge transfer to enable optimized long-term support and maintenance by SMUD technical staff.
• Metadata Artifacts Production
• Create and maintain metadata artifacts such as data models, data dictionaries, metadata glossaries, and other documentation to support end-user understanding and adoption.
• Ensure metadata accuracy and alignment with enterprise data governance standards.
• Automated Monitoring Implementation
• Design and implement automated monitoring tools or processes to track the execution and performance of new code deployments and data flows.
• Establish alerting mechanisms to promptly identify and resolve issues.
• BW Data Flow Migration
• Migrate existing BW data flows from legacy versions (3.X) to the current standard (7.5), ensuring data integrity and minimal downtime during transitions.
• Environmental Assessment for Migration
• Conduct thorough reviews of the current BW 7.5 environment and object to identify candidates for migration to SAP Datasphere or S / 4 Real-Time Analytics.
• Evaluate Xthe technical and business impacts of migrating specific objects and provide recommendations accordingly

Mandatory Skills :

The proposed resource must have :

A. Minimum 5 years of relevant work experience delivering :

B. Minimum 3 years of relevant work experience in :

Desirable Skills :