Intellibee Inc
Business Warehouse (BW) Engineer
Intellibee Inc, Sacramento, California, United States, 95828
Overview
Join to apply for the
Business Warehouse (BW) Engineer
role at
Intellibee Inc . Business Warehouse (BW) Engineer, Sacramento, CA, US Scope of Work
Sacramento Municipal Utility District (SMUD) is seeking a highly skilled and experienced Business Warehouse (BW) Engineer to support and advance our SAP analytics and data warehousing environment. The ideal candidate will possess deep expertise in SAP BW on HANA, SAP BPC, SAP BusinessObjects, SAP Web Intelligence (Webi), ABAP, SAP Datasphere, SAP S/4 HANA, SAP Analytics Cloud (SAC) Planning, and other next-generation SAP-related cloud technologies. 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 the technical and business impacts of migrating specific objects and provide recommendations accordingly. Mandatory Requirements
The proposed resource must have: 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. 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, emphasis 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 Qualifications
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. Benefits At IntelliBee
Long-Term Stability: Join us on a multi-year opportunities with room to grow. Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well. Future Planning: Enroll in our 401(k) program and invest in your financial security. GC Assistance: We support immediate Green Card processing, if required. Other Details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Business Development and Sales Industries: IT Services and IT Consulting Referrals increase your chances of interviewing at Intellibee Inc by 2x Get notified about new Business Warehouse Specialist jobs in Sacramento, CA. We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Join to apply for the
Business Warehouse (BW) Engineer
role at
Intellibee Inc . Business Warehouse (BW) Engineer, Sacramento, CA, US Scope of Work
Sacramento Municipal Utility District (SMUD) is seeking a highly skilled and experienced Business Warehouse (BW) Engineer to support and advance our SAP analytics and data warehousing environment. The ideal candidate will possess deep expertise in SAP BW on HANA, SAP BPC, SAP BusinessObjects, SAP Web Intelligence (Webi), ABAP, SAP Datasphere, SAP S/4 HANA, SAP Analytics Cloud (SAC) Planning, and other next-generation SAP-related cloud technologies. 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 the technical and business impacts of migrating specific objects and provide recommendations accordingly. Mandatory Requirements
The proposed resource must have: 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. 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, emphasis 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 Qualifications
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. Benefits At IntelliBee
Long-Term Stability: Join us on a multi-year opportunities with room to grow. Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well. Future Planning: Enroll in our 401(k) program and invest in your financial security. GC Assistance: We support immediate Green Card processing, if required. Other Details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Business Development and Sales Industries: IT Services and IT Consulting Referrals increase your chances of interviewing at Intellibee Inc by 2x Get notified about new Business Warehouse Specialist jobs in Sacramento, CA. We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr