Job Description: SCOPE OF THE PROJECT:
The state is of South Carolina has implemented SAP Finance Material Management and HR. DHHS is leading the effort to report their finance & HR data with their existing system KPIs as well as with historical archives. DHHS has a current SAP BI Platform and SQL Server SSIS implementation that needs ongoing Operations Maintenance Changes and Enhancements as well as architectural leadership as DHHS goes through major data reporting changes and needs.
DAILY DUTIES / RESPONSIBILITIES:
Within project schedules and other defined deadlines candidate will provide functional and technical services including:
Design reporting architecture and platform configuration requirements to meet the high demand for analytical operational and compliance reporting.
Architect reporting data structures from DHHS data sources both relational and nonrelational.
Refine report and dashboard requirements with project team members finance and HR subject matter experts and executives.
Extract and Load data from diverse sources with MS SQL Server SSIS packages and model analytic infrastructure.
Design prototype develop test and implement SAP BusinessObjects 4.2 IDT universes Web Intelligence reports Dashboards and/or Crystal Reports to meet those requirements.
Assist in source data investigation plus help design/refine data models and strategies into an integrated high performing data warehouse design allowing for robust reporting and analytical capabilities.
Develop and execute unit system and user acceptance test plans
Resolve technical and business issues
Help mentor finance and HR staff and executives on BI Launchpad Web Intelligence & Crystal Reports for Enterprise
Help maintain and upgrade SAP Business Objects Intelligence Platform Crystal Servers and Data Federator as appropriate
Work closely with network database & system administrators.
Provide technical knowledge transfer via paired programming peer coaching and written documentation.
Provide effective and timely oral and written communications to management peers and users
Identify and escalate issues and risks to management in a timely manner.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Experienced with installation and configuration of SAP Business Intelligence software
3 years of experience in developing and implementing universes and Web Intelligence reports
Experienced in developing and implementing Dashboards
Experience in designing MS SQL Server SSIS packages and writing Sql queries.
Able to interpret and document business requirements develop technical specifications and test processes to meet requirements
Able to formulate technical resolutions to business issues
Able to troubleshoot and resolve problems
Able to work closely with others in a team environment
Able to work independently selfmotivated.
Excellent communication skills (written and verbal).
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Experience with BusinessObjects Tools and Data Federator
Experienced in full lifecycle of data warehouse delivery including analysis design dimensional modeling development testing implementation training and support
Familiarity with major industry relational and nonrelational database management systems
Proficient with MS Office tools (e.g. Word Excel Visio Project)
REQUIRED EDUCATION/CERTIFICATIONS:
Bachelors in IT Business or equivalent experience
PREFERRED EDUCATION/CERTIFICATIONS:
MCSA MCSE SAP CERTIFIED APPLICATION ASSOCIATE
Additional Sills:
Skills: | Category | Name | Required | Importance | Level | Last Used | Experience | |
ERP | SAP Data Services | Yes | 1 | Expert | Currently Using | 2 4 Years | |
ERP | SAP Upgrade Experience | Yes | 1 | Expert | Currently Using | 2 4 Years | |
Miscellaneous | Ability to analyze and document business and system processes using various methods and tools. | Yes | 1 | Expert | Currently Using | 2 4 Years | |
Miscellaneous | Ability to deal effectively with the needs of technical peers technical and user management users vendors and staff members and to communicate clearly and effectively in spoken and written form | Yes | 2 | Expert | Currently Using | 2 4 Years | |
Programming Languages | Crystal Reports | Yes | 1 | Expert | Currently Using | 2 4 Years | |
SAP | Experience with SAP Business Warehours Business Objects Tableua PCM | Yes | 1 | Expert | Currently Using | 2 4 Years | |