SAP Business Intelligence Developer II

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:

• Bachelor’s 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