$50.05-$62.00 hourly / $8,674.81-$10,746.57 monthly / $104,097.72-$128,958.84 annual
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.
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
Information access strategies
Multidimensional data modeling and mapping techniques and tools
Online analytical processing development and tools
Query and reporting tools
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 of program documentation
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
Establish and maintain effective and cooperative working relationships with administrators, technical and functional team members, and users
Train users effectively
Write clear and logical documentation
Meet 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
A bachelor’s degree from a recognized college or university, preferably with a major in computer information systems, management information systems, computer engineering, or a related field.
Three years of recent full-time paid experience in business data warehouse development and maintenance using an SAP Business Warehouse system
A valid Class "C" California driver's license may be required for some positions.
Travel to locations throughout the District may be required for some positions.
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.