IT Advisor (Senior BW Developer)

Information Technology Oklahoma City, Oklahoma

Job Summary

The IT Advisor/ SR. BW Developer is responsible for the overall design and architecture associated to SAP’s Business Warehouse (SAP/BW).  This position creates or modifies solutions to solve complex problems and must be competent to work in all phases of applications, systems analysis and programming activities.

Own Customer Success

  • Working with client stakeholders to understand business processes and requirements
  • Analyze business and functional requirements to define target BI/BW solution architecture
  • Design specifications for solution components, evaluating various options
  • Prepare detailed implementation plan with timelines
  • Work with other technical SMEs to develop long-term strategy for sustainable and flexible reporting architecture on top of SAP/BW
  • Execute project as per plan, and ensure defect-free delivery of solution on-time
  • Ensure adoption of best-in-class practices and standards for development, support, quality, control, and documentation
  • Drive timely  and proactive issue identification, escalation, and resolution

Provide Technical Leadership

  • Build InfoCubes, ODS Objects, Multi-Cubes, InfoSources, PSAs, Multi-Providers, Info Packages, Update Rules, Transfer Rules, Start Routines and Process Chains
  • Perform transformations (BI7), DTP, Aggregates, Open Hub Service (Info Spokes), and Business Content activation
  • Execute data loads including Info Package scheduling, Process Chain of events such as OLTP extractions, delta/full updates, ODS data activation, data load in cubes, aggregate roll-ups and index maintenance
  • Activate, Configure & Customize (extending) Generic and Business Content Extractors by functional area
  • Drive Performance Tuning of Queries through Aggregates, Indexes, InfoCube Compression, InfoCube Partitioning, Statistics, and BW Accelerator as well as data loads using BW tools
  • Develop and trouble shoot ABAP programs including user exits, function modules and start/end/expert routines
Technical Skills
  • Advanced knowledge of relational database design and data models.
  • BW Development (Backend and Frontend)
  • BW + BOBJ Integration
  • BW + ABAP
  • BW Security & Administration / BW Analysis Authorization
  • Proficient with data standards and concepts such as data quality, data profiling, and data virtualization
  • BW 7.4 + HANA
  • Strong communication skills, both written and oral
  • Proven team player


  • Bachelor’s degree in Computer Science, MIS or a related field from an accredited College or University
  • At least eight (8) years of recent related experience working in a development and support role
  • At least three (5) years of experience working as a developer/architect and/or administrator
  • Experience with large, complex initiatives, working with an in-house development team or commercial off the shelf application implementations and software vendors
  • Project management and business analyst experience
  • Aptitude to learn new concepts and technologies quickly and with minimal direction
  • An acceptable pre-employment background and drug test