SAP Technical Support Engineer - Rebid

Business Analyst-Project Lead

Scope of the project: The Department of Enterprise Applications (DEA) Reporting and Analytics Team is requesting the services of a senior consultant to assist in the design and development of Business Objects dashboards and reports in the SAP environment. The consultant will provide technical analysis and expertise to optimize universes and data structures; coordinate the development of functional specifications; design and develop requested reports and dashboards in a quality manner; create detailed documentation that facilitates the use and future modification of these reports and dashboards; and provide extensive knowledge transfer sessions for IT and business users in the use of Business Objects tools and techniques. The State of SC has implemented the following modules of SAP across all state agencies: FI, FM, HR, Payroll, SRM, CRM, Treasury Management, BW, and Business Objects. The consultant will design, develop, edit, and maintain queries using Business Objects tools and techniques to support reporting requirements and data integration tasks across a broad spectrum of applications and uses. The consultant will coordinate activities with DEA to ensure decisions, recommendations, and work products follow best practices and established standards.

Daily Duties / Responsibilities: Interact with DEA personnel and agencies to gather/develop functional and technical requirements and translate them into proposed business intelligence applications and reporting solutions. Coordinate with DEA personnel and agencies to design, develop, and maintain complex business intelligence reporting and analytical solutions using various Business Objects tools and techniques. Create and present prototypes to users as well as propose alternative solutions to legacy reports using different technologies and development techniques. Create requirements documents for approval by system owners and business users to be used in the development of reports and dashboards. Model, design, develop, test, and implement approved solutions in accordance with business reporting requirements. Provide daily support of the existing Business Objects reports and universes with a focus on performing root cause analysis and finding ways to increase efficiencies, improve user satisfaction, and reduce cost/time to maintain. Perform optimization reviews to consistently improve the universes, data structures, and to improve and streamline processes regarding data flow and data quality to improve data accuracy, viability, and value. Create detailed documentation, including data dictionaries, during the creation or modification of universes, reports, and dashboards. Assist business users in downloading and using data from Business Warehouse and Business Objects data to Crystal reports, dashboards, Excel, etc., for analysis and dissemination to internal and external users. Serve as a subject matter expert assisting STO with defining and developing treasury management, debt management, and investment management reports. Work with DEA personnel and agencies to determine the best approach to publish new dashboards to agency websites to promote transparency and access to information by the public. Work with DEA and DTO personnel to design, test, and implement a database to allow for the merging of SCEIS and Non-SCEIS data for the purposes of generating Business Objects reports and dashboards. Design, develop, and maintain interactive Tableau dashboards and reports to support business intelligence and analytics needs. Manage Tableau Server/Online environments, including architecting, upgrading, publishing, security, user access, and data source management. Design, develop, and maintain ETL workflows using Microsoft SSIS, Azure Synapse, etc.

Required Skills (rank in order of Importance): 5+ Years of Experience with Business Objects architecture and components, and the design of complex web intelligence reports and dashboards. 5+ Years of Experience with design and development of business intelligence applications and reporting solutions in an SAP environment. 5+ Years of Experience developing complex web intelligence reports, dashboards, Crystal Reports. 5+ Years of Tableau Administration experience. 3+ Years of Experience in the Public Sector. Bachelor’s Degree - Preferred Skills (rank in order of Importance): Preference will be given to qualified candidates who have a working knowledge of SCEIS and existing state reporting requirements and standards. Experience with Microsoft SSIS (ETL Development and Data Integration)

Required Education/Certifications: Bachelor’s degree in computer science, information technology, mathematics, engineering, or related discipline; - Preferred Education/Certifications:

Interview Process (phone, video, or in-person, how many rounds, etc)? Members of the DEA leadership team. Interviews may be on the phone or in-person. - Interview Availability: How soon can you schedule an interview (date / times)? As soon as qualified resumes are available.