Los Angeles Community College District

Develops, models, and maintains a District-wide SAP business data warehouse that enables end-users to extract and analyze business information from a wide range of data sources.

Analyzes reporting needs of client users, configures and models business data from a wide range of data sources, and develops SAP BW reports.

Develops and deploys query parameters, layout, filters, and analytics for client user reports.

Designs and executes testing plans to validate the data loading process, data integrity, and that reports meet business requirements.

Identifies and debugs business data upload and extract errors.

Performs quality assurance and essential data audit checks to ensure accuracy of SAP BW reports.

Analyzes business processes for metrics enterprise data architecture.

Interfaces with functional unit process owners and users to identify, define, and document operational reporting needs and objectives, current operational reporting procedures, problems, input and output requirements, and levels of systems access.

Interfaces with programming staff in the development of custom SAP BW reports and data extractors and retractors.

Identifies opportunities to leverage SAP data warehouse capabilities to address business, transactional, and operational problems and recommends improvements in functionality.

Identifies security requirements including the creation of new roles and/or additions to existing business needs.

Responds to end-user inquiries regarding the usage of the SAP data warehouse and data analysis.

Trains end-users in the usage of SAP BW reports.

Prepares and maintains SAP data warehouse documentation.

Maintains effective and cooperative working relationships with process owners, technical and functional team members, and users.

Performs related duties as assigned.

An SAP Business Data Warehouse Developer is responsible for developing, modeling, and maintaining a District-wide SAP business data warehouse that enables end-users to extract and analyze business information from a wide range of data sources.

A Data Base Systems Specialist is responsible for the integration of data base elements into a common system for the purpose of improving the efficiency of the data processing components related to applications and software systems and programming. An employee in this class analyzes many systems for discrete and common elements and integrates these elements into an operable system which satisfies the needs of all systems while maintaining the integrity of the data of each system.

General supervision is received from a classified technical manager or supervisor. No supervision is exercised.

Knowledge of:

Principles of SAP Business Warehouse including business objects

Business data warehouse concepts and applications including extraction, transformation, loading, data modeling, cleansing, and query tuning

SAP Enterprise Resource Planning (ERP) system

Public Budget Formation (PBF) system

Information access strategies

Multidimensional data modeling and mapping techniques and tools

Online analytical processing development and tools

Query and reporting tools

Building reports using Business Objects (BO) system

Support Packs Updates on Business Warehousing and Business Objects systems

NetWeaver Portal Integration for Reports

System development life cycle methodology

Techniques and methods of business analysis

Methods and techniques of project management

Current trends and developments in concepts, methodology and technology related to SAP business data warehousing and related fields

Principles and procedures of program documentation

Ability to:

Analyze reporting needs of client users, model business data, and develop SAP BW reports

Solve complex business data design problems from an enterprise perspective

Analyze structured and unstructured data, recognize significant factors, relationships and trends and formulate conclusions and solutions

Prepare effective written communications, reports, and training materials

Effectively communicate complex technical concepts in understandable terms

Provide technical assistance to users

Consistently use and promote professional standards and practices related to assignments

Maintain a focus on details, quality, and precision in the performance of duties

Actively contribute to a culture of constructive collaboration and innovation with colleagues

Build rapport with clients and maintain a professional demeanor while handling complex user issues

Maintain high levels of customer service and satisfaction

Maintain confidentiality of work-related information and materials

Establish and maintain effective and cooperative working relationships with administrators, technical and functional team members, and users

Train system users effectively

Write clear and logical documentation

Meet project schedules and deadlines

Present and lead discussions on SAP business data warehouse functionality as it relates to current operational reporting needs

Stay abreast of current trends and technical advancements in data warehousing/business intelligence

Learn and apply new concepts in SAP business data warehousing

Education and Experience:

A bachelor’s degree from a recognized college or university, preferably with a major in computer information systems, management information systems, computer science, computer engineering, or a related field AND three years of recent full-time paid experience in business data warehouse development and maintenance using an SAP Business Warehouse system

Our class specification generally describes the duties, responsibilities, and requirements characteristic of the position(s) within this job class. The duties, responsibilities, and requirements of a particular position within this class may vary from the duties of other positions within the class.

In accordance with the Americans with Disabilities Act (ADA), the Los Angeles Community College District provides reasonable accommodation to qualified individuals with covered disabilities on a case-by-case basis throughout the application, examination, and hiring processes and throughout employment. If an individual is in doubt about his or her ability to perform the duties and responsibilities of a position or possession of any other requirement noted in a class specification or job announcement, he or she should always apply for a position and request reasonable accommodation at the appropriate time.