*Lead Data Warehouse Analyst - Direct Client * *Immediate Interview and Start ASAP!!!*
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * Job Title: Lead Data Warehouse Analyst Location: 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 s...@cncconsulting.com <s...@cncconsulting.com> * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/groups/opt_out.