*Lead Data Warehouse Analyst w/T-SQL and ETL and Java - Direct Client * *Immediate Interview and Start ASAP!!!*
*Please send resume to [email protected] <[email protected]> * Job title: Lead Data Warehouse Analyst w/T-SQL and ETL and Java Locaton: Columbia, SC Duration: 5 Months Direct Client Position Specific Duties and Responsibilities: The following application tasks are expected to be executed by the Data Warehouse systems/application analyst. All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and user acceptance testing. These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the SCDOR IRM organization. • Serve as project technical lead for development and implementation of tax compliance programs, including those based on IRS extract files. • Development of tax calculations via the PW “Tax Calc” component. There is a user interface that supports creation of the tax calc routines, however, complex calculations may require the development of external Java objects that are called by the tax calc process. • Creating and executing “views” to be utilized by the PW audit selection process. • Maintaining all application level configurations and parameters for the PW compliance programs. In addition to items listed above, these include various system reference codes, workflow rules, scoring parameters, correspondence templates. • Monitoring of PW offline processes. These include primary indicator, legacy system gateway, nightly data refresh process, and collections scoring. • Train less experienced SCDOR Data Warehouse staff, especially full-time SCDOR employees, in the development and implementation of tax compliance programs. • Performing ad hoc queries using T/SQL and stored procedures for data maintenance Lower priority: • Preparing and loading of data into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. • Setting up and running the PW Associate and Grow (A&G) offline process for data cleansing and matching. This includes configuring the A&G match keys. • Supporting installation of new PW, WinDRS, and TaxMaster releases • Maintaining custom offline routines such as legacy system Gateway, Primary Indicator, etc based on business rule changes • Performing database utility functions, such as SQL Server Analytical Services for OLAP , DTS, SSIS, etc for loading and analysis of data. SKILLS REQUIRED: The successful candidate will have, at minimum, the following skills: • Experience and expertise in gathering and analyzing business user requirements. • Proficiency in Java development. • Experience and expertise in SQL, including development of T/SQL queries and data manipulation. Expert knowledge of databases and relational database concepts. Experience with SQL Server 2005 required. • Experience with Windows 7 operating system and the Windows 2008 server environment. • Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. • Ability to learn new applications and skills sets. • Ability to communicate clearly and concisely, both orally and in writing. • Ability to establish and maintain good working relationships with business users, management, vendors, and peers. • Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. • Understanding of deployment methodology concepts including design, build, testing, and deployment. Highly desirable: • Prior experience with state tax applications, particularly tax compliance programs. • Experience with the RSI DiscoverTax application. *Please send resume to [email protected] <[email protected]> * Thanks, Sam CNC Consulting, Inc. 201-546-3096 [email protected] -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.
