Business Intelligence Technical Lead I, Madison, WI

Company: Confiance Tech Solutions
Location: Madison
Posted on: May 17, 2020

Job Description:

Job Description bull The candidate will work on PeopleSoft report development and maintenance tasks in support of STAR related project initiatives. bull It is responsible for correction, resolution and maintaining data quality and accuracy of the PeopleSoft Financial data in the DOT Data Warehouse,as well as providing expertise in the development and maintenance of PeopleSoft Reports for DOT. bull The duties of the position will require the incumbent to perform multiple activities on concurrent projects while maintaining the existing production environment. bull It will require understanding the PeopleSoft source system, enterprise architecture, change management procedures, implementation considerations and communication with Business Users. bull This position works with business users to ensure DOT's DW and STAR reporting platforms are appropriately utilized for all required reporting for the department. bull Projects will utilize PeopleSoft PS Query, QAS nVision, Informatica DVO, and SQL development. bull The position will create and deliver solutions, collaborating with business analysts, data modelers, database administrators, BI architects, and development teams to facilitate targeted content aggregation reporting delivery. The ideal candidate will have 8-10 years skills and experienced in the following 1. Data Warehouse and Business Intelligence domain 2. PeopleSoft Finance, HR, Procurement 3. PeopleSoft QAS, PS Query, and nVision report development 4. Informatica DVO for data validation 5. Oracle SQL Development 6. Data Quality, data reconciliation and synchronization concepts in a Data Warehouse and Business Intelligence domain 7. Project Leadership and timely delivering of projects 8. Good communication skills 9. Ability to work with clients on refining requirements, creating project plans, schedules, monitoring progress and assessing risk 10. Cherwell Skills required - Experience with Database Management using RDBMS, ORACLE, IBM DB2, SQL Server - Experience with Star Schema and Snow Flake Data Modeling - Good understanding of testing activities and methodologies - Results oriented with an ability to work in team and individual contributor work environments - Strong ability to decompose a broad level business requirement into technical implementation - Strong root cause investigation and problem solving skills - Experience in data warehouse design and development - Experience in requirements gathering for data warehouse - Data warehousing - DB2 - Experience in extract, transform, and load coding using Informatica - Oracle - Oracle PLSQL unit testing - Advanced SQL expertise - Advanced testing and debugging techniques - Expertise in PeopleSoft Financials APPO - Expertise in PeopleSoft Financials Expenses - Expertise in PeopleSoft Financials GL - Information processing methodologies Process analysis and design techniques - General knowledge of Peoplesoft HR systems

Keywords: Confiance Tech Solutions, Madison , Business Intelligence Technical Lead I, Madison, WI, IT / Software / Systems , Madison, Wisconsin