Job Summary:
The Business Intelligence (BI) Architect is a senior level position on the SAP Business Intelligence Team (BI) within the Global Corporate Information Technology. This role will serve as a strategic architect and liaison providing assistance to various members of the teams by understanding the business processes and requirements of the users at a depth sufficient to design and implement an appropriate BI architecture and solution to meet their needs. As a member of Business Intelligence team implementing enterprise data warehousing, based upon SAP BW architecture, the BI Architect is responsible for evolution and production support of the data warehouse architecture and BI environment.
Responsibilities:
- Works collaboratively with the business community and ITS colleagues to establish a secure, effective, and efficient data warehouse architecture supporting multiple business subject areas.
- Works directly with functional analysts and project teams as a lead or team member to develop new data warehouse functionality and architecture from business specifications by modelling, designing, developing, testing and implementing the appropriate back-end structures (including Info sources, ODSs, and Info Cubes) needed to meet business requirements.
- Provide proactive investigation, review, assessment, design and implementation of methods to improve existing processes, performance, security and data access.
- Assess existing and available data warehousing technologies and methods to ensure our BI architecture meets the needs of the business unit and enterprise and allows for business growth.
- Provides recommendations on evolution of the architecture.
- Prepares and reviews functional specifications and detailed technical designs for software solutions based on help desk tickets, user enhancement requests and functional requirements.
- Provides development support for existing environment including coding, documentation, and testing of modifications to existing BW production environment based upon prepared design.
- Experience in developing Infocubes and queries in at least one of the modules: HR, SD, MM, FI, PP and PU.
- Knowledge of BW and SAP Tools: ALE, IDOC, CTS, Authorizations and/or ABAP.
- Provides production support and administration of BW back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed, including off-hours and week-ends. Also includes resolution of daily issues/requests, performance management, maintenance upgrades, and production migrations.
- Performs various data analyses and generate and maintain various reports based upon departmental and enterprise needs.
- Participates on and lead teams as required to implement solutions to aid in improvements to BI functions, including participation on any cross-divisional projects to ensure solutions can be utilized corporate-wide.
- Provides insight based on past experiences, offer suggestions and possible solutions to challenges and issues presented.
- Strong desire to grow in Architecture, Business Intelligence, Leadership and Technical capacities.
- Performs other duties as assigned.
Skills Requirements:
- 7 or more years of relevant experience.
- Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
- Ability to define problems collects data, establish facts, and draw valid conclusions.
- Ability to operate a personal computer including using a Windows based operating system and related software.
- Advanced PC skills, including training and knowledge of iQor's software packages.
- Ability to write simple correspondence.Read and understand visual aid.
- Ability to apply common sense understanding to carry out simple one- or 2-step instructions.
- Ability to deal with standardized situations with only occasional or no variables.
- Ability to read and comprehend simple instructions, short correspondence, and memos.
- Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.
- Ability to compute rate, ratio, and percent and to draw and interpret graphs.
- Must be familiar with SAP BW3.5 or BW 7.0.
- Must have participated in 3 full lifecycle implementations.
Education Requirements:
Bachelor's Degree, First degree or Trade/Vocational school certificate or equivalent in Computer Science, Information Systems or computer related discipline required.
Physical Requirements:
Occasionally exert up to 10 lbs. of force to push, pull, lift or otherwise move objects. Have visual acuity to perform activities such as preparing and analyzing data and/or viewing a computer terminal. Type and/or sit for extended periods of time. Consistent attendance is an essential function of the job.
