Talent.com
Business Warehouse (BW) Engineer

Business Warehouse (BW) Engineer

California Creative Solutions Inc.CA, United States
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

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 :

  • Data architecture, data engineering, or data orchestration solutions on SAP BW on HANA.
  • Development of deliverables utilizing ABAP programming.
  • BPC (Business Planning and Consolidation) reports and datasets supporting analysis and downstream reporting requirements.
  • HANA calculated views are designed for use with Power BI.
  • HANA calculated views specifically within the CCS (Customer Care and Billing), Work Management, Supply Chain, and Finance modules of SAP BW.
  • Improvements in system performance and maintainability through reduction of technical debt by optimizing and standardizing the codebase.
  • Migration initiatives involving the transition from BW on HANA to SAP Datasphere.

    • B. Minimum 3 years of relevant work experience in :

  • Utilizing the ODP (Operational Data Provisioning) framework to enable efficient and reliable data loading processes.
  • Configuring and managing SAP Landscape Transformation (SLT) replication for real-time data capture and replication.
  • Designing and developing embedded analytics reports in the SAP Fiori S / 4HANA environment, emphasizing real-time data reporting that supports timely and accurate business decisions.
  • Creating and optimizing S / 4HANA CDS (Core Data Services) views tailored for analytics and real-time data consumption.

    • Desirable Skills :

  • Provides experience in resumes that demonstrates qualification in these areas.
  • Highly skilled in implementing robust security and authorization controls for CDS views and embedded analytics, ensuring that reports are accessible only to authorized users in compliance with organizational policies.
  • Proficient in creating S / 4HANA CDS views optimized for analytics and real-time data consumption.
  • Familiar with SAP Datasphere for comprehensive data modeling and management across landscapes.
  • Ability to provide recommendations for architecture, processes, standards, and / or policies that would benefit the long-term viability of SMUD's data landscape utilizing SAP S / 4 HANA, real time analytics, SAP Analytics Cloud, Datasphere and Databricks.
  • Experience delivering results as part of an Agile SCRUM team.
  • Experience with Power BI visualizations built off HANA calculated views
    • serp_jobs.job_alerts.create_a_job

    Warehouse • CA, United States