SAP BW Business Intelligence Developer II
Full-time | Hybrid | Greenville, SC / Tempe, AZ / Sacramento, CA
NO C2C | USC or GC Holder
Summary
The Business Intelligence Developer II plays a key technical role within the Data & Analytics team, responsible for building, optimizing, and maintaining SAP BI and BW data solutions. This position focuses on SAP development, SQL programming, and BW architecture to support a scalable enterprise data ecosystem. The ideal candidate combines a strong command of SAP HANA modeling, SQL query optimization, and data integration with a meticulous, problem-solving mindset. This role collaborates across business and IT teams to design, implement, and support reliable BI solutions that drive data-informed decisions.
Responsibilities
SAP Development & Data Modeling
- Design, develop, and maintain SAP BW (7.x / BW on HANA / BW / 4HANA) data models, including InfoProviders, ADSOs, CompositeProviders, Open ODS Views, and Transformations.
- Develop and optimize SAP HANA Calculation Views (graphical and scripted), leveraging SQLScript for complex data logic and transformations.
- Create, maintain, and enhance BOBJ reports, dashboards, and Analysis for Office workbooks that support business objectives.
- Integrate data from multiple disparate systems and ensure accuracy, consistency, and performance across environments.
Data Architecture & Engineering
Implement and maintain data pipelines and ETL processes using SAP extractors and SQL Server Integration Services (SSIS).Optimize SQL queries and HANA performance through indexing, partitioning, and query plan tuning.Design and execute data validation, reconciliation, and error-handling frameworks.Monitor process chains, transports, and data loads across SAP landscapes.Operational Excellence & Quality Assurance
Enforce coding and modeling standards for BW / HANA objects and SQL development.Develop and maintain technical documentation, process flows, and version histories.Partner with Basis and Security teams to manage user authorizations and system performance.Participate in system upgrades, patches, and testing cycles, ensuring seamless transitions.Collaboration & Support
Engage with business stakeholders to translate analytical needs into technical specifications.Provide user support, troubleshoot BI performance issues, and deliver user training where needed.Collaborate with cross-functional IT peers, analysts, and data engineers to align BI solutions with enterprise goals.Participate in daily standups, sprint reviews, and ongoing improvement initiatives.Qualifications
Required :
Bachelors degree in Computer Science, Information Systems, Engineering, or related discipline.8+ years of SAP development experience with emphasis on BI / BW architecture and design.Strong expertise in SAP BW 7.x, BW on HANA, or BW / 4HANA, including InfoProviders, ADSOs, CompositeProviders, and Process Chains.Proven experience with SAP HANA modeling and SQL / SQLScript for complex queries, data transformations, and performance tuning.5+ years of experience in multi-dimensional database design and modeling.3+ years of experience integrating data from multiple sources using SSIS or similar tools.Advanced Microsoft Excel skills (pivot tables, macros, formulas, vlookups).Exceptional analytical thinking, attention to detail, and ability to troubleshoot complex data challenges.Excellent written and verbal communication skills with the ability to convey technical concepts to non-technical stakeholders.Preferred :
Hands-on experience with ABAP for BW, AMDP, or Python for automation.Familiarity with SAP Analytics Cloud (SAC) or other advanced visualization tools.Experience implementing CI / CD pipelines or version control for SAP BI assets.Knowledge of SDLC and QA methodologies, including test automation for data models.Exposure to AI or machine learning tools for data enrichment and predictive analytics.Experience with ServiceNow, Jira, or other project tracking tools.Reporting Relationships
Reports to : Enterprise Architecture Manager, Data & Analytics