Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW/BI reporting and applications
Design comprehensive BI solutions, translating complex requirements into an optimal BI design
Design data structures to optimize data load times and end-user data access response times
Design processes to minimize data quality risks and proactively identify potential data issues
Build and Enhance BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (DSOs, InfoCubes, and MultiProviders), and Process Chains.
Monitor BI loads, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing
Maintain BW structures and support for ETL processes for data feeding in and out of BW
Prepare project related documentation (functional design, technical design, test scripts) during the different stages of a project
Build Business Objects reports using Analysis Edition for MS (Analysis/MS), Analysis Edition for OLAP (Analysis/OLAP) and Web Intelligence (WebI)* Support the training of BI Power Users.
This includes WebI, Analysis/OLAP, Analysis/MS and dashboards developed with Design Studio
Build out current BW landscape to include non-SAP data sources
Adhere to BW/BI best practices and standards to maintain stable Business Information environment
Additional responsibilities per management
Complies with all local, state, federal, and A O Smith regulations, policies, and procedures
Qualifications
BA/BS Degree (Major: computer science, information systems, mathematics or related field)
A minimum of 5 years of experience in: SAP BI/BW, BOBJ and SAP Report Development.
A minimum of 5 years of Configuration of BW data objects: Info Objects, Transformations, DTPs, InfoProviders (DSOs, Info Cubes, and Multi Providers), and Process Chains.
A minimum of 5 years of knowledge of ECC extractors: SD, FI/CO, COPA PP. MM. QM, WM, TM.
Experience reconciling ECC and BW data.
Knowledge of SAP query development
A plus if experience with dashboards development using SAP Business Objects Design Studio.
Demonstrated analytical skills with a solid understanding of BI/BW development
Excellent project management skills.
Ability to create timeline and deliverables and execute plan successfully
Excellent PC skills including MS Project, Excel and PowerPoint
Strong communication, interpersonal and teamwork skills
Demonstrated capacity to effectively manage multiple and frequently changing priorities
High degree of accuracy with attention to detail and ability to meet strict deadlines
Minimal travel required, less than 25%. However, this may vary depending on project deadlines and implementation locations.